Hi Team,
I have a table schema in my H2 DB like below and when I am doing the build
with H2DB 1.4.199 the table query is working fine but when using the H2DB
2.2.224 jar and while doing hte build it was giving "Expected NULLS" issue
as shown below:
Create Table Query:
================
CREATE TABLE nim_config_properties (
id INT AUTO_INCREMENT
,mdr_id INT
,property_name VARCHAR(50)
,property_value VARCHAR(400)
,PRIMARY KEY (id)
,FOREIGN KEY (mdr_id) REFERENCES nim_config(mdr_id)
,UNIQUE KEY mdrIdProeprtyName(mdr_id, property_name)
);
Giving the following error when using H2DB 2.2.224 jar but working fine
wiht H2DB 1.4.199 Jar
=================================================================================
Syntax error in SQL statement " CREATE TABLE nim_config_properties (\000a
id INT AUTO_INCREMENT\000a ,mdr_id INT\000a ,property_name VARCHAR(50)\000a
,property_value VARCHAR(400)\000a ,PRIMARY KEY (id)\000a ,FOREIGN KEY
(mdr_id) REFERENCES nim_config(mdr_id)\000a ,UNIQUE [*]KEY
mdrIdProeprtyName(mdr_id, property_name)\000a )"; expected "NULLS, ("; SQL
statement:
Any pointers would be highly appriciated.
Thanks in advance.
Regards,
Balamurali
--
This electronic communication and the information and any files transmitted
with it, or attached to it, are confidential and are intended solely for
the use of the individual or entity to whom it is addressed and may contain
information that is confidential, legally privileged, protected by privacy
laws, or otherwise restricted from disclosure to anyone else. If you are
not the intended recipient or the person responsible for delivering the
e-mail to the intended recipient, you are hereby notified that any use,
copying, distributing, dissemination, forwarding, printing, or copying of
this e-mail is strictly prohibited. If you received this e-mail in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/8ded9f22-993c-4515-81e3-bf96a57e8c8cn%40googlegroups.com.
