-
1. Re: Wierd problem mysql w/jboss-tomcat
coltzhao Jun 10, 2003 10:59 PM (in response to coltzhao)Forget to mention, the entity bean seems use CMP.
-
2. Re: Wierd problem mysql w/jboss-tomcat
coltzhao Jun 11, 2003 12:02 AM (in response to coltzhao)SOme other detail about this problem.
Seems it is because mysql won't load.
23:50:54,783 ERROR [PersistenceManager] Starting failed: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation ' l to a valid JDBC level.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation ' l to a valid JDBC level.)))
23:50:54,783 WARN [ServiceController] Problem starting service jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation ' l to a valid JDBC level.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation ' l to a valid JDBC level.)))
at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:267)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1235)
........
c:>more mysql-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ==================================================================== -->
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
root
</local-tx-datasource> -
3. Re: Wierd problem mysql w/jboss-tomcat
icons Jun 23, 2003 11:26 AM (in response to coltzhao)I have exactly the same problem with:
JBoss3.0.6_tomcat4.1.18 + mysql 3.23.49 + mysql-connector-java-3.0.6-stable-bin.jar
Java HotSpot(TM) Client VM (build 1.4.1_03-b02, mixed mode)
Need help ASAP. Thanks! -
4. Re: Wierd problem mysql w/jboss-tomcat
ccricklin Nov 27, 2003 12:42 AM (in response to coltzhao)I have the same problem with:
JBoss3.2.2 + mysql 4.0.16 + mysql-connector-java-3.0.6-stable-bin.jar and JVM 1.4. + WindowsXP pro.
However, if I installed everything onWindows2000 pro, everything is working just fine. (I've tried it on 3 machines).
Help please,
thanks,