Re: [JBoss-user] Error creating table

2002-07-01 Thread Michael Delamere
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 > > P

Re: [JBoss-user] Error creating table

2002-06-30 Thread Neal Sanche
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

Re: [JBoss-user] Error creating table

2002-06-30 Thread Michael Delamere
une 30, 2002 11:24 PM Subject: [JBoss-user] Error creating table > 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,

[JBoss-user] Error creating table

2002-06-30 Thread Michael Delamere
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 error