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 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, 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
