crimeportal example w/ mysql?

kitz Sep 4, 2002 2:27 AM

Hey,

Has anybody tried deploying the crimeportal example with a Mysql datasource?

I get two of the tables created properly and then:

23:21:10,670 INFO [GangsterEJB] Created table 'gangster' successfully.
23:21:10,710 INFO [GangsterEJB] Created table 'gangster_enemies' successfully.
23:21:11,461 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Job
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'desc VARCHAR(255) BINARY NOT NULL, the_boss INTEGER, CONSTRAINT pk_organization ' at line 1)

1. Re: crimeportal example w/ mysql?

dsundstrom Sep 4, 2002 12:01 PM (in response to kitz)

Did you also change the datasouce-mapping? Each database has a different SQL mapping.
Actions
2. Re: crimeportal example w/ mysql?

kitz Sep 4, 2002 8:14 PM (in response to kitz)

yeah, changed it to mySQL ...

weird b/c the first two tables create properly...
Actions
3. Re: crimeportal example w/ mysql?

dsundstrom Sep 6, 2002 4:59 PM (in response to kitz)

There was a bug reported on this yesterday. One of the columns is named desc which is a SQL reserved word. If you change that, it should work.
Actions
4. Re: crimeportal example w/ mysql?

tlaresch Sep 9, 2002 3:01 PM (in response to kitz)

Works great - I changed "desc" below to "description" in jbosscmp-jdbc.xml and it deploys just fine (with MySQL).
<cmp-field>
<field-name>description</field-name>
<column-name>desc</column-name>
<not-null/>
</cmp-field>

Thanks for the hint!
- Tom
Actions

Go to original post