-
1. Re: deploying nukes with mysql
superdave591 Aug 29, 2003 11:05 PM (in response to khooke)That is pretty much what it took to get my site up. Although I built from source (snapshot from around 7 days ago), so I cant really answer on the alpha binary download. I would build from source, if you have ant it is relatively simple. I used jikes as my compiler, and the property file already has options for jikes compiling although they are turned off.
-
2. Re: deploying nukes with mysql
unngh Sep 2, 2003 1:15 PM (in response to khooke)Hello,
I am also trying to deploy nukes with mysql. So far, following the docs, I was able to download nukes-snapshot.tar.gz for 2003-09-02, build it and deploy on jboss-3.2.2RC3.
I am using mysql 4.0.12 and I receive the error below when attempting to "add an html page" with the "manage html" module.
2003-09-02 14:59:51,700 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.core.ejb.FileEJBLocal org.jboss.nukes.core.ejb.FileEJBLocalHome.create(java.lang.String,int,java.lang.String,byte[]) throws javax.ejb.CreateException, causedBy:
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:1651)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1871)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1805)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:213)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.executeInsert(JDBCIdentityColumnCreateCommand.java:63)
Any advice on how to resolve this?
Thanks,
Chris -
3. Re: deploying nukes with mysql
superdave591 Sep 2, 2003 9:38 PM (in response to khooke)For what its worth, my JBOSS version is 3.2.2.RC2, and my mysql version is 4.0.14.
Im not sure what your problem is, as I have only been running the system for a little over a week and most the time that was with hsqldb. But this is what it sounds like to me.
in your build directory there is a file called local.properties. You should check that file my guess is your file has "nukes.type-mapping=hsqldb" instead of "nukes.type-mapping=mySQL" in it. You can find a local.properties configured for mySQL in build/etc directory. Try rebuilding your system and modules after making that change and see if it works.
David -
4. Re: deploying nukes with mysql
wolfie Sep 4, 2003 6:34 AM (in response to khooke)It seems like you are still using the Hypersonic CMP mapping. First, check that you have the right nukes.type-mapping in nukes/build/local.properties. Then recompile. If your problem still exists, delete the directory nukes/nukes/${build.resources} (a simple "build clean" doesn't seem to delete that directory). The compile the nukes module with "build deploy".
I had this problem when trying to configure nukes for MS SQL Server 2000 earlier today. Now it works perfectly... -
5. Re: deploying nukes with mysql
julien1 Sep 4, 2003 10:45 AM (in response to khooke)man, send me your how to for configuring sqlserver, I will include it in the codebase.
thanks
julien -
6. Re: deploying nukes with mysql
wolfie Sep 5, 2003 12:41 AM (in response to khooke)I have only adapted the core module config to MS SQL Server 2000, but I'll send you my config files via e-mail in a minute.
/Ulf -
7. Re: deploying nukes with mysql
unngh Sep 5, 2003 10:34 AM (in response to khooke)Thanks wolfie.
Your advice resolved the issue.
Chris