4 Replies Latest reply on Jun 1, 2003 9:30 PM by yjyang

    What's wrong with jboss3.2.1?

    yjyang Newbie

      I used the jboss3.0.6 ago,But today I changed it to jboss3.2.1. I don't know what's wrong with jboss3.2.1.And I run the program which is well on jboss3.0.6,but it occurs error on jboss3.2.1.
      Who can tell me what i should do? Thanks

      Now is a simple program.But when i deploy it ,it error:
      ); - nested throwable:(org.jboss.resource.JBossResourceException: Could not cre
      ate connection; - nested throwable: (java.sql.SQLException: ERROR: Option 'xact
      isolevel' is not recognized
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEnt
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBC
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea

        • 1. Re: What's wrong with jboss3.2.1?
          Jon Barnett Master

          If you are using Postgresql as the back-end database, it means there is an incompatibility between the back-end database and the JDBC driver. I can't remember which way it went but it is either that the new drivers don't match the old back-end interface or vice-versa. I think the newer drivers are incompatible with the older Postgresql interface, hence doesn't support the isolevel option in the connection establishment.

          • 2. Re: What's wrong with jboss3.2.1?
            yjyang Newbie

            But why the driver has not any errors when i use the jboss3.0.6?
            And can you give me an example for configuration?


            • 3. Re: What's wrong with jboss3.2.1?
              Jon Barnett Master

              I think the pools are more exacting in the connection process to better handle events such as the database or network connection bouncing - and the isolevels were not introduced until the either 7.2 or 7.3. In any event, we use Postgresql 7.3 in Cygwin and Linux with pg73jdbc3.jar without any issues.

              The postgres-ds.xml in docs/jca/examples is an operational definition. I give an ECperf 1.1 definition below.

              <?xml version="1.0" encoding="UTF-8"?>

              <!-- ===================================================================== -->
              <!-- -->
              <!-- JBoss Server Configuration -->
              <!-- -->
              <!-- ===================================================================== -->

              <!-- $Id: postgres-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
              <!-- ==================================================================== -->
              <!-- Datasource config for Postgres -->
              <!-- ==================================================================== -->


              • 4. Re: What's wrong with jboss3.2.1?
                yjyang Newbie

                Thanks jonlee.

                I have understood what you said.