4 Replies Latest reply on Nov 27, 2003 12:42 AM by Rick Lin

    Wierd problem mysql w/jboss-tomcat

    coltzhao Newbie

      I am new to use JBoss, I experienced some wierd problem to config jboss-tomcat with mysql.

      First, my OS is windows XP pro, J2SE sdk is 1.4.1-02

      I downloaded jboss-4.0.0DR1_tomcat-4.1.24.zip from this website. unzip to c:\ rename as jboss-tomcat.

      Tested with simple servlet, jsp, stateless session bean, simple entity bean. All worked great.

      Than I try to integrate mySQL. I downloaded and installed mysql-4.0.13-win.zip(seems fine as its standalone)
      downloaded the connector from this website, copyed mysql-connector-java-3.1.0-alpha-bin.jar to
      c:\jboss-tomcat\server\default\lib

      I deleted hsqldb-ds.xml under
      c:\jboss-tomcat\server\default\deploy

      copyed the mysql-ds.xml from
      c:\jboss-tomcat\docs\examples\jca
      to
      c:\jboss-tomcat\server\default\deploy
      changed MySqlDS to DefaultDS, dell to localhost,
      org.gjt.mm.mysql.Driver to com.mysql.jdbc.Driver


      also, I edited
      C:\jboss-tomcat\server\default\conf\standardjaws.xml
      and
      C:\jboss-tomcat\server\default\conf\standardjbosscmp-jdbc.xml
      to change "Hypersonic SQL" to "mySQL"

      than after restart jboss, all test run fine except the entity bean. The ear seems can not load correctly. I have no idea why, because lack of information, I must make some mistake to modify jboss configuration files.

      because if I roll back the changes done to integrate mySQL, entity bean works fine again.

      Thank you in advance for your help

        • 1. Re: Wierd problem mysql w/jboss-tomcat
          coltzhao Newbie

          Forget to mention, the entity bean seems use CMP.

          • 2. Re: Wierd problem mysql w/jboss-tomcat
            coltzhao Newbie

            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 Newbie

              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
                Rick Lin Newbie

                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,