mySQL setup with JBoss Nukes

[mrjabba]

Hi,

So far, Nukes looks great as far as being an early port still. But, I'm having a little problem with the setup to get my data saved.

I am using mySQL 4.0.17 on Win2K Pro.

I downloaded jboss-3.2.3_nukes-1.0.0RC1

I was able to get Nukes to start the first time without setting up the database. Obviously you don't make it very far :-)

So, I downloaded the DDL files and ran the setup. I got an error when it was granting the nukes user privileges.

[kevin1] ERROR 1221: Wrong usage of DB GRANT and GLOBAL PRIVILEGES

So, I manually went into MySQL Control Center and granted Nukes pretty much all privileges to the nukes database. I was able to create the schema, etc. No worries.

I added the database driver to the right directory under server/default/lib : mysql-connector-java-3.0.10-stable-bin.jar

I modified nukes-ds.xml to include my datasource like this:

<local-tx-datasource>
<jndi-name>NukesDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/nukes</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>nukes</user-name>
nukes
</local-tx-datasource>

I think that is correct? Anyone know a different way of doing this? :-)

Then, I fired up Nukes.

This time I knew the password for admin and user and could login because I was a good boy and read the database setup...

However, I cannot save anything, such as create a new topic in the forum or modify the main HTML page. If I do, I get an error: "Cannot invoke the operation : the module threw an exception"

The console seems to catch this error. Looks like a SQL problem.
Is my version of MySQL compatible?

at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: Syntax error or access violation, message from server: "
You have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'CALL IDENTITY()' at line
1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2048)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2005)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1156)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(Wrapped
Statement.java:241)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.execut
eInsert(JDBCIdentityColumnCreateCommand.java:58)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInser
t(JDBCAbstractCreateCommand.java:287)


Thanks for any advice you can give!
I am not a big JBoss developer (yet). I am still exploring. So, thanks for reading the "stupid question"

Kevin

[mrjabba]

Nevermind. I figured out my problem.

I didn't copy over t he .ear files from the mysql download. As always, never skip steps in the setup instructions :-)

Nukes looks pretty good. Now I gotta try some other modules.

Kevin