Hello,

We are uisng Hinernate 3.0.5 and WAS 6.0.
Some times we get the following error while building configuration

[9/1/05 11:49:48:908 EDT] 00000038 DatasourceCon I org.hibernate.connection.DatasourceConnectionProvider configure Using datasource: java:comp/env/jdbc/bookingDatasource
[9/1/05 11:49:48:909 EDT] 00000038 XATransaction E J2CA0026E: Method addSync caught javax.transaction.RollbackException: Transaction rolled back
at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3366)
at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3345)
at com.ibm.ws.Transaction.JTA.TranManagerSet.registerSynchronization(TranManagerSet.java:484)
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:284)
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:1233)
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:976)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:331)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:300)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at com.starwood.valhalla.booking.util.HibernateHelper.<clinit>(HibernateHelper.java:67)
at com.starwood.valhalla.booking.dao.ProductDAOImpl.checkGuaranteeType(ProductDAOImpl.java:108)
at com.starwood.valhalla.booking.bo.ProductBO.validateGuaranteeType(ProductBO.java:376)
at com.starwood.valhalla.booking.bo.ProductBO.validate(ProductBO.java:360)
at com.starwood.valhalla.booking.bo.ProductBO.create(ProductBO.java:89)
at com.starwood.valhalla.booking.bo.BinderBO.create(BinderBO.java:167)
at com.starwood.valhalla.booking.bo.ItineraryBO.createBinder(ItineraryBO.java:370)
at com.starwood.valhalla.booking.bo.ItineraryBO.create(ItineraryBO.java:150)
at com.starwood.valhalla.booking.bs.CreateBookingService.createBooking(CreateBookingService.java:120)
at com.starwood.valhalla.booking.facade.BookingFacadeBean.createBooking(BookingFacadeBean.java:373)
at com.starwood.valhalla.booking.facade.EJSRemoteStatelessBookingFacade_7e4054e8.createBooking(Unknown Source)
at com.starwood.valhalla.booking.facade._BookingFacade_Stub.createBooking(_BookingFacade_Stub.java:519)
at com.starwood.valhalla.booking.requestHandler.CreateBookingHandler.processRequest(CreateBookingHandler.java:70)
at com.starwood.valhalla.bknginterface.listener.BookingServlet.doPost(BookingServlet.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:286)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
while trying to register the Resource Adapter with the Synchronization Manager for the current transaction, and threw a ResourceException.
[9/1/05 11:49:48:912 EDT] 00000038 SettingsFacto W org.hibernate.cfg.SettingsFactory buildSettings Could not obtain connection metadata
java.sql.SQLException: addSync: caught Exception
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1160)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:344)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:300)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at com.starwood.valhalla.booking.util.HibernateHelper.<clinit>(HibernateHelper.java:67)
at com.starwood.valhalla.booking.dao.ProductDAOImpl.checkGuaranteeType(ProductDAOImpl.java:108)
at com.starwood.valhalla.booking.bo.ProductBO.validateGuaranteeType(ProductBO.java:376)
at com.starwood.valhalla.booking.bo.ProductBO.validate(ProductBO.java:360)
at com.starwood.valhalla.booking.bo.ProductBO.create(ProductBO.java:89)
at com.starwood.valhalla.booking.bo.BinderBO.create(BinderBO.java:167)
at com.starwood.valhalla.booking.bo.ItineraryBO.createBinder(ItineraryBO.java:370)
at com.starwood.valhalla.booking.bo.ItineraryBO.create(ItineraryBO.java:150)
at com.starwood.valhalla.booking.bs.CreateBookingService.createBooking(CreateBookingService.java:120)
at com.starwood.valhalla.booking.facade.BookingFacadeBean.createBooking(BookingFacadeBean.java:373)
at com.starwood.valhalla.booking.facade.EJSRemoteStatelessBookingFacade_7e4054e8.createBooking(Unknown Source)
at com.starwood.valhalla.booking.facade._BookingFacade_Stub.createBooking(_BookingFacade_Stub.java:519)
at com.starwood.valhalla.booking.requestHandler.CreateBookingHandler.processRequest(CreateBookingHandler.java:70)
at com.starwood.valhalla.bknginterface.listener.BookingServlet.doPost(BookingServlet.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:286)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.ResourceException: addSync: caught Exception
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:294)
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:1233)
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:976)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:331)
... 38 more
Caused by: javax.transaction.RollbackException: Transaction rolled back
at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3366)
at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3345)
at com.ibm.ws.Transaction.JTA.TranManagerSet.registerSynchronization(TranManagerSet.java:484)
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:284)
... 42 more


Any pointers to solve this will be great help...

Thanks and Regards,
Raja