4 Replies Latest reply on Mar 8, 2006 6:21 AM by Joao Cerdeira

    JDBC-call in a Session-Bean does not work

    Oliver Roell Newbie

      Hello,

      I am working with JBoss 4.0.2 and Informix, and I want to access from a Session-Bean with a JDBC-call to the database. Thus I have done the following steps:

      a) Copied the IBM Informix JDBC Driver 2.21.JC5-file ifxjdbc.jar in the directory \server\default\lib.

      b) Created a new file named informix-ds.xml in the directory \server\default\deploy:


      <local-tx-datasource>
      <jndi-name>InformixDS</jndi-name>
      <connection-url>jdbc:informix-sqli://server:port//database:INFORMIXSERVER=server</connection-url>
      <driver-class>com.informix.jdbc.IfxDriver</driver-class>
      <user-name>user</user-name>
      password
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <type-mapping>InformixDB</type-mapping>

      </local-tx-datasource>


      c) Created a new business-method in the Session-Bean to connect to the database.
      At the first try I connected only to the default-database:

      Context context = new InitialContext();
      DataSource ds = (DataSource) context.lookup("java:DefaultDS");
      Connection con = ds.getConnection();
      con.close();

      This works fine.

      d) At the second try I connected to the informix-database without a connection:

      Context context = new InitialContext();
      DataSource ds = (DataSource) context.lookup("java:InformixDS");

      This works, too.

      e) At the third try I connected to the informix-database with a connection:

      Context context = new InitialContext();
      DataSource ds = (DataSource) context.lookup("java:InformixDS");
      Connection con = ds.getConnection();
      con.close();

      Now the problems begun, and the JBoss-server logged 270 error-lines to the screen. The first lines looked like the following:

      09:49:18,375 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=roell/17, BranchQual=, localId=17] errorCode=XA_UNKNOWN(0)
      org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Transactions not supported)) at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:657)
      at org.jboss.tm.TransactionImpl$Resource.startResource(TransactionImpl.java:1952)
      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:548) at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:436) at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:322) at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:583) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:450) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:874) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)

      The Swing-Client, who has connected to the bean, shows me another exception:

      org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=roell/17, BranchQual=, localId=17] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in commit: expected: null, got: XidImpl[FormatId=257, GlobalId=roell/17, BranchQual=1, localId=17]); - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=roell/17, BranchQual=, localId=17] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in commit: expected: null, got: XidImpl[FormatId=257, GlobalId=roell/17, BranchQual=1, localId=17]))

      f) I have added the <resource-ref> to the ejb-jar.xml and the jboss.xml:

      <enterprise-beans>

      [CDATA[Description for Access]]
      <display-name>Name for Access</display-name>
      <ejb-name>Access</ejb-name>
      access.interfaces.AccessHome
      access.interfaces.Access
      <ejb-class>access.ejb.AccessBean</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>

      <resource-ref>
      Informix-Database
      <res-ref-name>InformixDS</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>


      </enterprise-beans>


      <enterprise-beans>

      <ejb-name>Access</ejb-name>
      <jndi-name>ejb/Access</jndi-name>

      <resource-ref>
      <res-ref-name>InformixDS</res-ref-name>
      <jndi-name>InformixDS</jndi-name>
      </resource-ref>

      </enterprise-beans>

      <resource-managers>
      </resource-managers>


      The error is the same like above. Nothing has changed after adding the resource-ref-tags.

      What's wrong with my approach? I have read a lot of tutorials and other threads, but nowhere I can find a solution for my problem.

      Would anyone help me, please?

      Regards
      Oliver