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

[Fritz Meissner]

Could be - that's another avenue to explore. From what I can see I have marked the id field as the primary key. I'll check again.

On 5/26/06, Bruce Stewart <[EMAIL PROTECTED]> wrote:

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:CTJUG-Forum@googlegroups.com]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
-~----------~----~----~----~------~----~------~--~---