[CTJUG Forum] Re: EJB 2.1 Problem with JBoss and MySQL

[Bruce Stewart]

Hi,   Also, should the SQL statement include the field name in the PK definition: CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY (id))   Doesn't look like a JBoss problem....possibly PK field needs to be specified somewhere in the meta-data/config of the EJB or something like that?   Bruce. -----Original Message----- From: CTJUG-Forum@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Paul Gilowey Sent: 25 May 2006 08:46 To: CTJUG-Forum@googlegroups.com Subject: [CTJUG Forum] Re: EJB 2.1 Problem with JBoss and MySQL Hi Fritz   <rant> Lisa will problebly flame me for this ;) but scheeesh, why can't JBoss give more helpful error messages??? We often get weird error messages. </rant>   Just on a cursory look, doesn't it seem as though there's something wrong with the brackets in the SQL statement?   Souldn't this CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY () be this CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY ()) ?   Paul   --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CTJUG Forum" group. To post to this group, send email to CTJUG-Forum@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/CTJUG-Forum For the ctjug home page see http://www.ctjug.org.za -~----------~----~----~----~------~----~------~--~---