-
1. Re: Setup nukes with mysql
julien1 Jul 21, 2003 4:39 PM (in response to chitech)what are you using ? what jboss, where did you get nukes ?
julien -
2. Re: Setup nukes with mysql
alainmg Jul 22, 2003 7:55 AM (in response to chitech)I tries jboss_3_2_2RC1 andt I had the same problem yesterday.
It may be due to the fact that I haven't sync up to nukes for a few weeks. For this reason I went back to jboss_3_2_1, until I'm ready to sync up with Nukes again. -
3. Re: Setup nukes with mysql
julien1 Jul 22, 2003 8:02 AM (in response to chitech)the cvs version we have a rarely stale, it compiles and runs well.
anyway, jboss-3.2.2rc2 is going out tomorrow and nukes will work with it (not under)
julien -
4. Re: Setup nukes with mysql
chitech Jul 22, 2003 9:31 AM (in response to chitech)I am using the jboss included in Jboss 3.2.1-nukes-1.0 alpha and i get the source from cvs.
-
5. Re: Setup nukes with mysql
elaineqs Jul 30, 2003 8:49 AM (in response to chitech)I am using jboss-3.2.2RC2, nukes cvs version and mysql. When I deploy nukes, I get the following error:
...
11:35:14,679 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Could not load driver class: com.mysq.jdbc.PreparedStatement; - nested throwable: (java.lang.ClassNotFoundException:
com.mysql.jdbc.PreparedStatement) at org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.init(JDCMySQLCreateCommand.java:45)at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createCreateEntityCommand(JDBCCommandFactory.java:128) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDCStoreManager.java:481) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:410) at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:160) at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java: ....
What is wrong?
Thanks!
elaineqs -
6. Re: Setup nukes with mysql
julien1 Jul 30, 2003 8:55 AM (in response to chitech)you have not installed the mysql jdbc drivers. you can get them at www.mysql.com. the current package is 3.0.8 as far as I know. it is called connectorj.
julien -
7. Re: Setup nukes with mysql
elaineqs Jul 30, 2003 1:55 PM (in response to chitech)Thanks Julien!
Now I have another problem. When I log with admin user, edit and update a html file, I get the error:
16:05:03,053 ERROR [STDERR] java.sql.SQLException: General error: Warning: Some non-transactional changed tables couldn't be rolled back
16:05:03,053 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
16:05:03,063 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
16:05:03,063 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
16:05:03,063 ERROR [STDERR] at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
16:05:03,063 ERROR [STDERR] at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
16:05:03,063 ERROR [STDERR] at org.gjt.mm.mysql.Connection.rollback(UnknownSource)
16:05:03,063 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:116)...
The file nukes\nukes\output\resources\nukes-ejb-jar\META-INF\jbosscmp-jdbc.xml have the following lines:
<entity-commands>
<entity-command name="nukes-entity-command"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand"/>
</entity-commands>
Is missing anything?
Thanks!!
elaineqs -
8. Re: Setup nukes with mysql
julien1 Jul 31, 2003 9:10 AM (in response to chitech)yes, your mysql is not transactionnal, so a rollback is not possible. you should use mysql-max instead.
this a no big consequence on nukes except that it is not transactionnal.
julien