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 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 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. Does this mean that my sql configuration > > is wrong or why am I getting the error below. I�m already using > > the mysql-service to get data from a table and that works. For > > some reason creating one seems to be a problem (I think)!?! > > > > Any help would be _very_ appreciated! > > > > Thanks, > > > > Michael > > > > p.s. I�m using jboss 3.0RC2 > > > > =================== ERROR ========================= > > 2002-06-30 23:16:50,078 DEBUG > > [org.jboss.ejb.plugins.local.BaseLocalContainerInvoker] Bound > > EJBLocalHome of guestbook/Sequence to > > ejb/guestbook/SequenceLocalHome > > 2002-06-30 23:16:50,204 DEBUG > > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.guestbook/Sequence > >] Executing SQL: CREATE TABLE gbSequence (name VARCHAR(255) BINARY > > NOT NULL, index INTEGER NOT NULL, CONSTRAINT pk_gbSequence PRIMARY > > KEY (name)) 2002-06-30 23:16:50,215 DEBUG > > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.guestbook/Sequence > >] Could not create table gbSequence > > 2002-06-30 23:16:50,258 ERROR [STDERR] java.sql.SQLException: > > Syntax error or access violation: You have an error in your SQL > > syntax near 'INTEGER NOT NULL, CONSTRAINT pk_gbSequence PRIMARY KEY > > (name))' at line 1 ========================================= > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
