JBosss 5.1.0 and Connection Issue

[Joydeep Ghatak]

Hi All,

I have a EAR file which runs fine on IBM websphere (6.0 and 6.1), now I have deployed the same in Jboss 5.1.0.As this is a dynamic website I need to make an oracle connection and where the datasource name is different from DefaultDS. I am not using EJB's.

I have configured JBoss inside Eclipse 3.7 (Indigo) and going to do any modification on the code etc through eclipse-JBoss combination only.
The application is deployed successfully and is working fine (log in, quite almost all the functionality is working fine) except one, which is throwing the following exception. Though we have not changed anything for that functionality in the code.

What I have done so far in this approach,

1. Created the oracle-ds.xml with DB and application specific parameters.
2. Deployed the oracle-ds.xml in C:\jboss-5.1.0.GA_MYAPP\server\default\deploy directory
3. Kept the hsqldb-ds.xml as it is, in the same location (As it comes default)
4. Provided the ojdbc14.jar in C:\jboss-5.1.0.GA_MYAPP\common\lib
5. Created and kept jboss-web.xml in <project_home>/src/web/WEB-INF

Output ::
==========
1. JBoss starts successfully showing it is able to detect the new application specific JNDI name (MY_ds)

2. But I am getting the following 2 different exceptions ,

2.1

15:12:48,691 ERROR [LOG] You cannot commit with autocommit set!
15:12:48,691 ERROR [DEV] You cannot commit with autocommit set!
java.sql.SQLException: You cannot commit with autocommit set!
	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:661)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:486)
	at pkg1.pkg2.pkg3.pkg4.pkg5.TwoBO.commitTrans(TwoBO.java:301)
	at pkg1.pkg2.pkg3.pkg4.pkg5.OneBO.createOneExportJob(OneBO.java:782)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)
15:12:53,957 ERROR [LOG] Error rolling back trans.  You cannot rollback with autocommit set!
15:12:53,957 ERROR [DEV] Error rolling back trans. 
java.sql.SQLException: You cannot rollback with autocommit set!
	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:695)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:500)
	at pkg1.pkg2.pkg3.pkg4.pkg5.TwoBO.rollbackTrans(TwoBO.java:323)
	at pkg1.pkg2.pkg3.pkg4.pkg5.OneBO.createOneExportJob(OneBO.java:811)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)

2.2 This exception we are getting whenever some basic functionality is hitting the DB

15:12:08,223 INFO  [CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@10a2f29
java.lang.Throwable: STACKTRACE
	at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:278)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:524)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)
	at pkg1.pkg2.pkg3.pkg4.pkg5.DBConnection.getNewConnection(DBConnection.java:95)
	at pkg1.pkg2.pkg3.pkg4.pkg5.TwoBO.getConn(TwoBO.java:188)
	at pkg1.pkg2.pkg3.pkg4.pkg5.OneBO.getAllOneVendors(OneBO.java:92)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at pkg1.pkg2.pkg3.pkg4.pkg5.CustomRequestProcessor.processActionPerform(CustomRequestProcessor.java:45)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)

What has been done so far ::
=================
1. Tried with commeting out the autoCommit() statements from the code (As the log shows that the autoCommit is set at the JBoss level, so code level autocommit has been closed)
Output :: Receiving the same exception,

2. Modified the oracle-ds.xml with
connection property's autoCommit as 'false', but with no luck.

Info ::
oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>   
<datasources>   
  <local-tx-datasource>   
    <jndi-name>MY_ds</jndi-name>   
    <connection-url>jdbc:oracle:thin:@<server_name>:<port>:<DBName></connection-url>   
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>   
    <user-name>User</user-name>   
    <password>pass</password>   
    <connection-property name="autoCommit">false</connection-property>
  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->   
      <metadata>   
         <type-mapping>Oracle9i</type-mapping>   
      </metadata>   
  </local-tx-datasource>   
</datasources>

Thanks in advance,
Joydeep

[James Boswell]

Hi

If it isn't too long, could you post the code for the entire class com.lilly.sdd.common.data.TwoBO please?

[Peter Johnson]

Are you sure you spelled the option correctly? Is it "autoCommit" or "autocommit"? Case matters! By the way, this in bot a JBoss question, it is a question about Oracle and its JDBC driver. All the JBossdoesi s pass the settings to the Oracle JDBC driver, which is the one complaining (though based on the exception stack trace it appears that JBoss is not properly wrapping the original exception).

[Joydeep Ghatak]

Thanks James, Thanks Peter,

Hi Peter,
I have tried with both "autoCommit" and "autocommit" in the parameter list, but both are giving the same exception :-(
Moreover the same code was deployed in webshpere AS, where it was working perfectly well.

And as you have mentioned "JBoss is not properly wrapping the original exception", is there any issue with this specific version of JBoss (Jboss 5.1) ? or if you can provide some more information on the same it will be great.

Hi James,
The complete code is more than 350 lines long so I am not putting that here.
But the method which is throwing the exceptions is,

public void commitTrans() throws ServiceException {
    		try {
 		      if (myTX) {
		      //connection.commit();
		      //connection.setAutoCommit(true);
		    }
		} catch (Exception e) {
			Logger.getLogger(ErrorLogger.LOG).error(e.getMessage());
			Logger.getLogger(ErrorLogger.DEV).error(e.getMessage(), e);
			throw new ServiceException("TwoBO:commitTrans()", true);
		}
	}

Note ::
1. Originally the following two lines were not commented out, but once we received the above exception we have commented out the above two lines

//connection.commit();
//connection.setAutoCommit(true);

2. I have checked the the control is going into the 'if (myTX)'
3. myTx is a boolean operator.
and same is the case for rollbackTrans()
I think the main issue is the following exception :-(

"
10:22:19,604 ERROR [LOG] You cannot commit with autocommit set!
10:22:19,604 ERROR [DEV] You cannot commit with autocommit set!
java.sql.SQLException: You cannot commit with autocommit set!
	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:661)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:486)"

Note ::
and

10:22:19,635 ERROR [LOG] Error rolling back trans.  You cannot rollback with autocommit set!
10:22:19,635 ERROR [DEV] Error rolling back trans. 
java.sql.SQLException: You cannot rollback with autocommit set!
	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:695)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:500)

Thanks in advance to both of you.
Thanks,
Joydeep

[Joydeep Ghatak]

Hi all,

The issue is resolved. Doing a change at the code base level we are able to resolve the issue.
Though we are still facing the following exception,

2011-11-21 13:00:21,391 INFO  [org.jboss.resource.connectionmanager.CachedConnectionManager] (http-127.0.0.1-8080-2) Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@ebad43
java.lang.Throwable: STACKTRACE
	at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:278)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:524)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)

Thanks,
Joydeep

[James Boswell]

Hi Joydeep

It may be worth checking where you use the Connection instances and make sure you explicitly close them (say in a finally block).

[Joydeep Ghatak]

Thanks James,
We are working on the same.

But just a thought, the same code works properly in Websphere but showing this exception in JBoss.
May be JBoss is more fine tuned from connection point of view.

Thanks,
Joydeep