JBoss-3.0.0_tomcat-4.0.3 + mysql (linux)

[hrfaria]

Hi!
Has anyone run the gangster example with Jboss-3.0.0_tomcat-4.0.3, MySQL and Linux? I'm having a few problems with (I believe) some db relationships.
The 'gangster' table is created, then I get an SQL syntax error near 'desc VARCHAR(255) BINARY NOT NULL, the_boss INTEGER, CONSTRAINTS pk_organization ...'.
How can I see the entire SQL query? Has anyone already gone through it?
Thanks!

Henrique R. Faria

[hrfaria]

I found the error! And it was stupid! The gangster example package tries to create the 'organization' table with a field called 'desc', that is a mysql reserved word!
All I had to do was change the field name to something else. Eh mole? Ossos do oficio =^( ...
Thanks anyway!

Henrique R. Faria

[hrfaria]

Ok! I found the error! The gangster example package tries to create the 'organization' table with a field called 'desc', which is a mysql reserved word!
All I had to do was change the field name to something else.
Thanks anyway!

Henrique R. Faria