1 Reply Latest reply on Feb 25, 2004 6:30 PM by mrjabba

    mySQL setup with JBoss Nukes

    mrjabba Newbie

      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