thanks,
I managed to resolve that one and you are right! :-)
Regards,
Michael
- Original Message -
From: Neal Sanche [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 01, 2002 12:53 AM
Subject: Re: [JBoss-user] Error creating table
Probably because 'index' is a reserved
Hi,
I´m getting an error while my beans are being deployed. Why is the SQL
syntax wrong?
When I try to execute the following SQL manually ...
CREATE TABLE gbSequence (name VARCHAR(255) BINARY NOT NULL, index INTEGER
NOT NULL, CONSTRAINT pk_gbSequence PRIMARY KEY (name))
... I also get an
Hi,
problem solved. Mysql doesn´t like it if you use index as a field name.
After renaming it to id it worked!
Regards,
Michael
- Original Message -
From: Michael Delamere [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 30, 2002 11:24 PM
Subject: [JBoss-user] Error
Probably because 'index' is a reserved word. Try changing the name of
your field to something else, like 'value'.
Cheers.
-Neal
On Sunday 30 June 2002 05:24 pm, you wrote:
Hi,
I´m getting an error while my beans are being deployed. Why is the
SQL syntax wrong?
When I try to execute the