-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Websphere 6, Hibernate 3, DB2 8.2, Datasource Connection Iss
PostPosted: Wed May 10, 2006 12:49 pm 
Newbie

Joined: Wed May 10, 2006 11:38 am
Posts: 3
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

When I run my code using my local DB2 instance, the logging capability works fine. When I created a datasource in Websphere Application Server 6 and then attempted to use the datasource to connect to a remote DB2 instance, I got the exception below.

Hibernate version: Hibernate 3

Mapping documents:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="HibernateSessionFactory">
<property name="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
<property name="hibernate.connection.password">db2admin</property>
<property name="hibernate.connection.url">jdbc:db2:TMP</property>
<property name="hibernate.connection.username">db2admin</property>
<property name="hibernate.default_schema">TMP</property>
<property name="hibernate.show_sql">true</property>
<property name="org.hibernate.transaction">true</property>
<property name="org.hibernate.jdbc">true</property>
<property name="connection.datasource">jdbc/TMPXA</property>
<property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property>
<mapping resource="com/tmp/hibernate/beans/TmpLogging.hbm.xml" />

</session-factory>

</hibernate-configuration>


Code between sessionFactory.openSession() and session.close():
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);

if (session != null) {
session.close();
}
}


public static Session currentSession() throws HibernateException {
Session session = null;
if (sessionFactory == null) {
try {
cfg.configure(CONFIG_FILE_LOCATION);
sessionFactory = cfg.buildSessionFactory();
} catch (Exception e) {
logger.error("%%%% Error Creating SessionFactory %%%%", e);
e.printStackTrace();
}
}
session = sessionFactory.openSession();

return session;



Full stack trace of any exception that occurs:
07 EDT] 0000000a ApplicationMg A WSVR0200I: Starting application: SchedulerCalendars
[5/10/06 12:41:28:237 EDT] 0000000a ArtifactLoade I com.ibm.ws.al.bootstrap.WASBootstrap appStart(DeployedApplication) CWLAG0205I: Artifactloader initializing is complete for module SchedulerCalendars.
[5/10/06 12:41:28:257 EDT] 0000000a EJBContainerI I WSVR0207I: Preparing to start EJB jar: Calendars.jar
[5/10/06 12:41:28:267 EDT] 0000000a EJBContainerI I WSVR0037I: Starting EJB jar: Calendars.jar
[5/10/06 12:41:28:297 EDT] 0000000a ApplicationMg A WSVR0221I: Application started: SchedulerCalendars
[5/10/06 12:41:28:318 EDT] 0000000a ApplicationMg A WSVR0200I: Starting application: cbebrowser
[5/10/06 12:41:28:408 EDT] 0000000a ArtifactLoade I com.ibm.ws.al.bootstrap.WASBootstrap appStart(DeployedApplication) CWLAG0205I: Artifactloader initializing is complete for module cbebrowser.
[5/10/06 12:41:29:269 EDT] 0000000a ArtifactLoade I com.ibm.ws.al.bootstrap.WASBootstrap warStart(DeployedModule) CWLAG0205I: Artifactloader initializing is complete for module cbebrowser.war.
[5/10/06 12:41:29:289 EDT] 0000000a WebGroup A SRVE0169I: Loading Web Module: Common Base Event Browser.
[5/10/06 12:41:29:509 EDT] 0000000a VirtualHost I SRVE0250I: Web Module Common Base Event Browser has been bound to admin_host[*:9060,*:9043].
[5/10/06 12:41:29:539 EDT] 0000000a ApplicationMg A WSVR0221I: Application started: cbebrowser
[5/10/06 12:41:29:549 EDT] 0000000a ApplicationMg A WSVR0200I: Starting application: TaskContainer_widNode_server1
[5/10/06 12:41:29:639 EDT] 0000000a ArtifactLoade I com.ibm.ws.al.bootstrap.WASBootstrap appStart(DeployedApplication) CWLAG0205I: Artifactloader initializing is complete for module TaskContainer_widNode_server1.
[5/10/06 12:41:30:180 EDT] 0000000a EJBContainerI I WSVR0207I: Preparing to start EJB jar: taskejb.jar
[5/10/06 12:41:30:190 EDT] 0000000a EJBContainerI I WSVR0037I: Starting EJB jar: taskejb.jar
[5/10/06 12:41:30:701 EDT] 0000000a ApplicationMg A WSVR0221I: Application started: TaskContainer_widNode_server1
[5/10/06 12:41:30:721 EDT] 0000000a StaffServiceI I com.ibm.ws.staffsupport.StaffServiceImpl start CWWBS0032I: The staff service started successfully.
[5/10/06 12:41:33:916 EDT] 0000000a BusinessRules I com.ibm.wbiservers.brules.runtime.component.BusinessRulesComponentImpl start CWLBR0001I: The Business Rules service has started.
[5/10/06 12:41:33:946 EDT] 0000000a SelectorCompo I com.ibm.wbiservers.selector.runtime.component.SelectorComponentImpl start CWLFW0001I: The Selector service has started.
[5/10/06 12:41:33:996 EDT] 0000000a TCPChannel A TCPC0001I: TCP Channel TCP_1 is listening on host * (IPv4) port 9060.
[5/10/06 12:41:34:026 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain WCInboundAdmin.
[5/10/06 12:41:34:036 EDT] 0000000a TCPChannel A TCPC0001I: TCP Channel TCP_2 is listening on host * (IPv4) port 9080.
[5/10/06 12:41:34:046 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain WCInboundDefault.
[5/10/06 12:41:34:056 EDT] 0000000a TCPChannel A TCPC0001I: TCP Channel TCP_3 is listening on host * (IPv4) port 9043.
[5/10/06 12:41:34:066 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain WCInboundAdminSecure.
[5/10/06 12:41:34:076 EDT] 0000000a TCPChannel A TCPC0001I: TCP Channel TCP_4 is listening on host * (IPv4) port 9443.
[5/10/06 12:41:34:076 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain WCInboundDefaultSecure.
[5/10/06 12:41:34:096 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain SOAPAcceptorChain1.
[5/10/06 12:41:34:096 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain SOAPAcceptorChain2.
[5/10/06 12:41:34:106 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain SOAPAcceptorChain3.
[5/10/06 12:41:34:116 EDT] 0000000a WSChannelFram A CHFW0019I: The Transport Channel Service has started chain SOAPAcceptorChain4.
[5/10/06 12:41:34:136 EDT] 0000005d SchedulerServ I SCHD0077I: The Scheduler Service is starting the Schedulers.
[5/10/06 12:41:34:206 EDT] 0000005d SchedulerImpl I SCHD0032I: The Scheduler AppScheduler is initializing.
[5/10/06 12:41:34:286 EDT] 0000005d ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource WPS DataSource.
[5/10/06 12:41:34:647 EDT] 0000000a RMIConnectorC A ADMC0026I: The RMI Connector is available at port 2809
[5/10/06 12:41:34:787 EDT] 00000049 WorkSpaceMana A WKSP0500I Workspace configuration consistency check is false.
[5/10/06 12:41:35:258 EDT] 0000005d InternalGener I DSRA8203I: Database product name : DBMS:db2j
[5/10/06 12:41:35:338 EDT] 0000005d InternalGener I DSRA8204I: Database product version : 5.1.60.30
[5/10/06 12:41:35:348 EDT] 0000005d InternalGener I DSRA8205I: JDBC driver name : Cloudscape Embedded JDBC Driver
[5/10/06 12:41:35:358 EDT] 0000005d InternalGener I DSRA8206I: JDBC driver version : 5.1.60.30
[5/10/06 12:41:35:908 EDT] 0000005d SchedulerImpl I SCHD0033I: The Scheduler AppScheduler has initialized.
[5/10/06 12:41:36:059 EDT] 0000005d SchedulerDaem I SCHD0038I: The Scheduler Daemon for instance AppScheduler has started.
[5/10/06 12:41:36:099 EDT] 0000005d SchedulerImpl I SCHD0032I: The Scheduler BPEScheduler is initializing.
[5/10/06 12:41:36:159 EDT] 0000005d ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource BPEDataSourceCloudscape.
[5/10/06 12:41:36:419 EDT] 0000005d SchedulerImpl I SCHD0033I: The Scheduler BPEScheduler has initialized.
[5/10/06 12:41:36:449 EDT] 0000005d SchedulerDaem I SCHD0038I: The Scheduler Daemon for instance BPEScheduler has started.
[5/10/06 12:41:36:499 EDT] 0000005d SchedulerServ I SCHD0078I: The Scheduler Service has completed starting the Schedulers.
[5/10/06 12:41:36:529 EDT] 0000005e LeaseAlarm I SCHD0133I: Scheduler AppScheduler (AppScheduler) has acquired the lease and will run all tasks on this application server.
[5/10/06 12:41:36:820 EDT] 00000014 LeaseAlarm I SCHD0133I: Scheduler BPEScheduler (BPEScheduler) has acquired the lease and will run all tasks on this application server.
[5/10/06 12:41:37:290 EDT] 0000000a WsServerImpl A WSVR0001I: Server server1 open for e-business
[5/10/06 12:47:14:966 EDT] 00000063 ServletWrappe A SRVE0242I: [filetransfer] [/FileTransfer] [transfer]: Initialization successful.

[5/10/06 12:48:00:812 EDT] 00000065 SystemOut O >>>>> JMSBackEnd
[5/10/06 12:48:00:812 EDT] 00000065 SystemOut O MessageEnvelopeMDB::JMSBackendBean::onMessage()::Received text message: <?xml version="1.0" encoding="UTF-8"?><LDM:MessageEnvelope xmlns:LDM="http://tempuri.org/LinkDataModel.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><verb>UPDATE</verb><message Originator="ASSETT-Air-Simulator" Topic="LDM/MessageEnvelope/TrackMessage/AirLinkUnit"><airLinkUnit><num>511</num><linkTN><Val>5</Val></linkTN><reportingUnit><Val>O4</Val></reportingUnit><position><lat>37.81680761643989</lat><lon>-77.79656912537705</lon><timeOfValidity>2006-02-20T16:11:32.636-05:00</timeOfValidity></position><course><Val>1.9023521614737513</Val></course><speed><Val>508.93800870400776</Val></speed><forceTell><Val>false</Val></forceTell><emergency><Val>false</Val></emergency><simulation><Val>true</Val></simulation><exercise><Val>false</Val></exercise><source><Val>LOCAL</Val></source><primaryId><Val>5</Val></primaryId><realTime><Val>true</Val></realTime><activity><Val>0</Val></activity><altitude><Val>12000</Val></altitude><trackQuality><Val>11</Val></trackQuality><identity><Val>HOSTILE</Val></identity></airLinkUnit></message></LDM:MessageEnvelope>
[5/10/06 12:48:02:014 EDT] 00000065 SystemOut O TMPLoggingMessageEnvelope::insertTmpLogging()::tmpLogging::cstn : 5 message is: speed=508.93800870400776,positionLat=37.81680761643989,activity=0,forceTell=false,emergency=false,linkTN=5,trackQuality=11,realTime=true,source=LOCAL,course=1.9023521614737513,positionLon=-77.79656912537705,altitude=12000.0, messageorig is: timestamp is: Sat Jan 02 00:00:00 EST 2100
[5/10/06 12:48:02:114 EDT] 00000065 Environment I org.hibernate.cfg.Environment <clinit> Hibernate 3.1 rc3
[5/10/06 12:48:02:154 EDT] 00000065 Environment I org.hibernate.cfg.Environment <clinit> hibernate.properties not found
[5/10/06 12:48:02:174 EDT] 00000065 Environment I org.hibernate.cfg.Environment <clinit> using CGLIB reflection optimizer
[5/10/06 12:48:02:184 EDT] 00000065 Environment I org.hibernate.cfg.Environment <clinit> using JDK 1.4 java.sql.Timestamp handling
[5/10/06 12:48:02:725 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration configure configuring from resource: /hibernate.cfg.xml
[5/10/06 12:48:02:755 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration getConfigurationInputStream Configuration resource: /hibernate.cfg.xml
[5/10/06 12:48:03:055 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/tmp/hibernate/beans/TmpLogging.hbm.xml
[5/10/06 12:48:03:275 EDT] 00000065 HbmBinder I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.tmp.hibernate.beans.TmpLogging -> TMP_LOGGING
[5/10/06 12:48:03:386 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration doConfigure Configured SessionFactory: HibernateSessionFactory
[5/10/06 12:48:03:396 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration secondPassCompile processing extends queue
[5/10/06 12:48:03:406 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration secondPassCompile processing collection mappings
[5/10/06 12:48:03:416 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration secondPassCompile processing association property references
[5/10/06 12:48:03:426 EDT] 00000065 Configuration I org.hibernate.cfg.Configuration secondPassCompile processing foreign key constraints
[5/10/06 12:48:03:606 EDT] 00000065 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/10/06 12:48:03:726 EDT] 00000065 ConnectionFac W J2CA0294W: Deprecated usage of direct JNDI lookup of resource jdbc/TMP. The following default values are used: [Resource-ref settings]

res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
loginConfigurationName: null
loginConfigProperties: null
[Other attributes]

res-resolution-control: 999 (undefined)
isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)

[5/10/06 12:48:03:756 EDT] 00000065 DatasourceCon I org.hibernate.connection.DatasourceConnectionProvider configure Using datasource: jdbc/TMP
[5/10/06 12:48:06:770 EDT] 0000006b WSChannelFram A CHFW0019I: The Transport Channel Service has started chain OutboundBasicMQLink.
[5/10/06 12:48:10:916 EDT] 00000065 InternalGener I DSRA8203I: Database product name : DB2/NT
[5/10/06 12:48:10:926 EDT] 00000065 InternalGener I DSRA8204I: Database product version : SQL08020
[5/10/06 12:48:10:926 EDT] 00000065 InternalGener I DSRA8205I: JDBC driver name : IBM DB2 JDBC Universal Driver Architecture
[5/10/06 12:48:10:936 EDT] 00000065 InternalGener I DSRA8206I: JDBC driver version : 2.3.63
[5/10/06 12:48:10:936 EDT] 00000065 WSRdbDataSour I DSRA8208I: JDBC driver type : 2
[5/10/06 12:48:10:967 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings RDBMS: DB2/NT, version: SQL08020
[5/10/06 12:48:10:977 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 2.3.63
[5/10/06 12:48:11:017 EDT] 00000065 Dialect I org.hibernate.dialect.Dialect <init> Using dialect: org.hibernate.dialect.DB2Dialect
[5/10/06 12:48:11:027 EDT] 00000065 TransactionFa I org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory Using default transaction strategy (direct JDBC transactions)
[5/10/06 12:48:11:037 EDT] 00000065 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[5/10/06 12:48:11:037 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Automatic flush during beforeCompletion(): disabled
[5/10/06 12:48:11:047 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Automatic session close at end of transaction: disabled
[5/10/06 12:48:11:047 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Scrollable result sets: enabled
[5/10/06 12:48:11:057 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings JDBC3 getGeneratedKeys(): disabled
[5/10/06 12:48:11:057 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Connection release mode: auto
[5/10/06 12:48:11:067 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Default schema: TMP
[5/10/06 12:48:11:077 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Default batch fetch size: 1
[5/10/06 12:48:11:077 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Generate SQL with comments: disabled
[5/10/06 12:48:11:087 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Order SQL updates by primary key: disabled
[5/10/06 12:48:11:087 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[5/10/06 12:48:11:097 EDT] 00000065 ASTQueryTrans I org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> Using ASTQueryTranslatorFactory
[5/10/06 12:48:11:097 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Query language substitutions: {}
[5/10/06 12:48:11:107 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Second-level cache: enabled
[5/10/06 12:48:11:117 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Query cache: disabled
[5/10/06 12:48:11:127 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory createCacheProvider Cache provider: org.hibernate.cache.EhCacheProvider
[5/10/06 12:48:11:137 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Optimize cache for minimal puts: disabled
[5/10/06 12:48:11:137 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Structured second-level cache entries: disabled
[5/10/06 12:48:11:147 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Echoing all SQL to stdout
[5/10/06 12:48:11:157 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Statistics: disabled
[5/10/06 12:48:11:157 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Deleted entity synthetic identifier rollback: disabled
[5/10/06 12:48:11:167 EDT] 00000065 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Default entity-mode: POJO
[5/10/06 12:48:11:227 EDT] 00000065 SessionFactor I org.hibernate.impl.SessionFactoryImpl <init> building session factory
[5/10/06 12:48:11:247 EDT] 00000065 Configurator W net.sf.ehcache.config.Configurator configure No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/widwps6/runtimes/bi_v6/classes/ehcache-1.1.jar!/ehcache-failsafe.xml
[5/10/06 12:48:11:708 EDT] 00000065 SessionFactor I org.hibernate.impl.SessionFactoryObjectFactory addInstance Factory name: HibernateSessionFactory
[5/10/06 12:48:11:718 EDT] 00000065 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/10/06 12:48:11:728 EDT] 00000065 SessionFactor I org.hibernate.impl.SessionFactoryObjectFactory addInstance Bound factory to JNDI name: HibernateSessionFactory
[5/10/06 12:48:11:738 EDT] 00000065 SessionFactor W org.hibernate.impl.SessionFactoryObjectFactory addInstance InitialContext did not implement EventContext
[5/10/06 12:48:11:738 EDT] 00000065 SessionFactor I org.hibernate.impl.SessionFactoryImpl checkNamedQueries Checking 0 named HQL queries
[5/10/06 12:48:11:748 EDT] 00000065 SessionFactor I org.hibernate.impl.SessionFactoryImpl checkNamedQueries Checking 0 named SQL queries
[5/10/06 12:48:15:593 EDT] 00000065 SystemOut O session.toString():SessionImpl(PersistenceContext[entityKeys=[EntityKey[com.tmp.hibernate.beans.TmpLogging#41]],collectionKeys=[]];ActionQueue[insertions=[EntityInsertAction[com.tmp.hibernate.beans.TmpLogging#41]] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
[5/10/06 12:48:15:603 EDT] 00000065 SystemOut O Hibernate: insert into TMP.TMP_LOGGING (CSTN, TIMESTAMP, MESSAGE, MESSAGEORIGINATOR, ID) values (?, ?, ?, ?, ?)
[5/10/06 12:48:16:004 EDT] 00000065 JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2396)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.spi.SharingViolationException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1044)
... 18 more

[5/10/06 12:48:16:024 EDT] 00000065 JDBCTransacti E org.hibernate.transaction.JDBCTransaction commit JDBC commit failed
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:16:034 EDT] 00000065 SystemOut O <<<<< JMSBackEnd
[5/10/06 12:48:16:034 EDT] 00000065 RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[5/10/06 12:48:16:054 EDT] 00000065 RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 0000010B1F32A4B40000000100000023A51677D56C8D0DF9D60736C0D0BF238E0E0265850000010B1F32A4B40000000100000023A51677D56C8D0DF9D60736C0D0BF238E0E02658500000001. Local resources follow.
[5/10/06 12:48:16:054 EDT] 00000065 RegisteredRes E WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@4440e71 <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@4468e71> <meName=widNode.server1-SCA.APPLICATION.widCell.Bus> <meUuid=1A9E7668A287160E> <busName=SCA.APPLICATION.widCell.Bus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=8>]: Vote: commit.
[5/10/06 12:48:16:064 EDT] 00000065 RegisteredRes E WTRN0089I: LocalTransactionWrapper@:28114e0c localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@2e820e0c enlisted:true registeredForSynctruemcWrapper.hashcode()452595212: Vote: none.
[5/10/06 12:48:16:414 EDT] 00000067 SystemOut O >>>>> JMSBackEnd
[5/10/06 12:48:16:414 EDT] 00000067 SystemOut O MessageEnvelopeMDB::JMSBackendBean::onMessage()::Received text message: <?xml version="1.0" encoding="UTF-8"?><LDM:MessageEnvelope xmlns:LDM="http://tempuri.org/LinkDataModel.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><verb>UPDATE</verb><message Originator="ASSETT-Air-Simulator" Topic="LDM/MessageEnvelope/TrackMessage/AirLinkUnit"><airLinkUnit><num>511</num><linkTN><Val>5</Val></linkTN><reportingUnit><Val>O4</Val></reportingUnit><position><lat>37.81680761643989</lat><lon>-77.79656912537705</lon><timeOfValidity>2006-02-20T16:11:32.636-05:00</timeOfValidity></position><course><Val>1.9023521614737513</Val></course><speed><Val>508.93800870400776</Val></speed><forceTell><Val>false</Val></forceTell><emergency><Val>false</Val></emergency><simulation><Val>true</Val></simulation><exercise><Val>false</Val></exercise><source><Val>LOCAL</Val></source><primaryId><Val>5</Val></primaryId><realTime><Val>true</Val></realTime><activity><Val>0</Val></activity><altitude><Val>12000</Val></altitude><trackQuality><Val>11</Val></trackQuality><identity><Val>HOSTILE</Val></identity></airLinkUnit></message></LDM:MessageEnvelope>
[5/10/06 12:48:16:414 EDT] 00000067 SystemOut O TMPLoggingMessageEnvelope::insertTmpLogging()::tmpLogging::cstn : 5 message is: speed=508.93800870400776,positionLat=37.81680761643989,activity=0,forceTell=false,emergency=false,linkTN=5,trackQuality=11,realTime=true,source=LOCAL,course=1.9023521614737513,positionLon=-77.79656912537705,altitude=12000.0, messageorig is: timestamp is: Sat Jan 02 00:00:00 EST 2100
[5/10/06 12:48:16:464 EDT] 00000067 SystemOut O session.toString():SessionImpl(PersistenceContext[entityKeys=[EntityKey[com.tmp.hibernate.beans.TmpLogging#42]],collectionKeys=[]];ActionQueue[insertions=[EntityInsertAction[com.tmp.hibernate.beans.TmpLogging#42]] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
[5/10/06 12:48:16:464 EDT] 00000067 SystemOut O Hibernate: insert into TMP.TMP_LOGGING (CSTN, TIMESTAMP, MESSAGE, MESSAGEORIGINATOR, ID) values (?, ?, ?, ?, ?)
[5/10/06 12:48:16:825 EDT] 00000067 JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2396)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.spi.SharingViolationException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1044)
... 18 more

[5/10/06 12:48:16:835 EDT] 00000067 JDBCTransacti E org.hibernate.transaction.JDBCTransaction commit JDBC commit failed
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:16:845 EDT] 00000067 SystemOut O <<<<< JMSBackEnd
[5/10/06 12:48:16:845 EDT] 00000067 RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[5/10/06 12:48:16:855 EDT] 00000067 RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 0000010B1F32E21E0000000100000026A51677D56C8D0DF9D60736C0D0BF238E0E0265850000010B1F32E21E0000000100000026A51677D56C8D0DF9D60736C0D0BF238E0E02658500000001. Local resources follow.
[5/10/06 12:48:16:865 EDT] 00000067 RegisteredRes E WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@22500e7c <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@22528e7c> <meName=widNode.server1-SCA.APPLICATION.widCell.Bus> <meUuid=1A9E7668A287160E> <busName=SCA.APPLICATION.widCell.Bus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=8>]: Vote: commit.
[5/10/06 12:48:16:875 EDT] 00000067 RegisteredRes E WTRN0089I: LocalTransactionWrapper@:28114e0c localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@2e820e0c enlisted:true registeredForSynctruemcWrapper.hashcode()452595212: Vote: none.
[5/10/06 12:48:16:905 EDT] 0000006c SystemOut O >>>>> JMSBackEnd
[5/10/06 12:48:16:905 EDT] 0000006c SystemOut O MessageEnvelopeMDB::JMSBackendBean::onMessage()::Received text message: <?xml version="1.0" encoding="UTF-8"?><LDM:MessageEnvelope xmlns:LDM="http://tempuri.org/LinkDataModel.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><verb>UPDATE</verb><message Originator="ASSETT-Air-Simulator" Topic="LDM/MessageEnvelope/TrackMessage/AirLinkUnit"><airLinkUnit><num>511</num><linkTN><Val>5</Val></linkTN><reportingUnit><Val>O4</Val></reportingUnit><position><lat>37.81680761643989</lat><lon>-77.79656912537705</lon><timeOfValidity>2006-02-20T16:11:32.636-05:00</timeOfValidity></position><course><Val>1.9023521614737513</Val></course><speed><Val>508.93800870400776</Val></speed><forceTell><Val>false</Val></forceTell><emergency><Val>false</Val></emergency><simulation><Val>true</Val></simulation><exercise><Val>false</Val></exercise><source><Val>LOCAL</Val></source><primaryId><Val>5</Val></primaryId><realTime><Val>true</Val></realTime><activity><Val>0</Val></activity><altitude><Val>12000</Val></altitude><trackQuality><Val>11</Val></trackQuality><identity><Val>HOSTILE</Val></identity></airLinkUnit></message></LDM:MessageEnvelope>
[5/10/06 12:48:16:905 EDT] 0000006c SystemOut O TMPLoggingMessageEnvelope::insertTmpLogging()::tmpLogging::cstn : 5 message is: speed=508.93800870400776,positionLat=37.81680761643989,activity=0,forceTell=false,emergency=false,linkTN=5,trackQuality=11,realTime=true,source=LOCAL,course=1.9023521614737513,positionLon=-77.79656912537705,altitude=12000.0, messageorig is: timestamp is: Sat Jan 02 00:00:00 EST 2100
[5/10/06 12:48:17:085 EDT] 0000006c SystemOut O session.toString():SessionImpl(PersistenceContext[entityKeys=[EntityKey[com.tmp.hibernate.beans.TmpLogging#43]],collectionKeys=[]];ActionQueue[insertions=[EntityInsertAction[com.tmp.hibernate.beans.TmpLogging#43]] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
[5/10/06 12:48:17:085 EDT] 0000006c SystemOut O Hibernate: insert into TMP.TMP_LOGGING (CSTN, TIMESTAMP, MESSAGE, MESSAGEORIGINATOR, ID) values (?, ?, ?, ?, ?)
[5/10/06 12:48:17:115 EDT] 0000006c JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2396)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.spi.SharingViolationException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1044)
... 18 more

[5/10/06 12:48:17:125 EDT] 0000006c JDBCTransacti E org.hibernate.transaction.JDBCTransaction commit JDBC commit failed
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:17:135 EDT] 0000006c SystemOut O <<<<< JMSBackEnd
[5/10/06 12:48:17:135 EDT] 0000006c RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[5/10/06 12:48:17:145 EDT] 0000006c RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 0000010B1F32E3FF0000000100000027A51677D56C8D0DF9D60736C0D0BF238E0E0265850000010B1F32E3FF0000000100000027A51677D56C8D0DF9D60736C0D0BF238E0E02658500000001. Local resources follow.
[5/10/06 12:48:17:165 EDT] 0000006c RegisteredRes E WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@7accce26 <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@7acf4e26> <meName=widNode.server1-SCA.APPLICATION.widCell.Bus> <meUuid=1A9E7668A287160E> <busName=SCA.APPLICATION.widCell.Bus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=8>]: Vote: commit.
[5/10/06 12:48:17:165 EDT] 0000006c RegisteredRes E WTRN0089I: LocalTransactionWrapper@:75f38e16 localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@a374e19 enlisted:true registeredForSynctruemcWrapper.hashcode()1726451222: Vote: none.
[5/10/06 12:48:17:205 EDT] 0000006b SystemOut O >>>>> JMSBackEnd
[5/10/06 12:48:17:205 EDT] 0000006b SystemOut O MessageEnvelopeMDB::JMSBackendBean::onMessage()::Received text message: <?xml version="1.0" encoding="UTF-8"?><LDM:MessageEnvelope xmlns:LDM="http://tempuri.org/LinkDataModel.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><verb>UPDATE</verb><message Originator="ASSETT-Air-Simulator" Topic="LDM/MessageEnvelope/TrackMessage/AirLinkUnit"><airLinkUnit><num>511</num><linkTN><Val>5</Val></linkTN><reportingUnit><Val>O4</Val></reportingUnit><position><lat>37.81680761643989</lat><lon>-77.79656912537705</lon><timeOfValidity>2006-02-20T16:11:32.636-05:00</timeOfValidity></position><course><Val>1.9023521614737513</Val></course><speed><Val>508.93800870400776</Val></speed><forceTell><Val>false</Val></forceTell><emergency><Val>false</Val></emergency><simulation><Val>true</Val></simulation><exercise><Val>false</Val></exercise><source><Val>LOCAL</Val></source><primaryId><Val>5</Val></primaryId><realTime><Val>true</Val></realTime><activity><Val>0</Val></activity><altitude><Val>12000</Val></altitude><trackQuality><Val>11</Val></trackQuality><identity><Val>HOSTILE</Val></identity></airLinkUnit></message></LDM:MessageEnvelope>
[5/10/06 12:48:17:205 EDT] 0000006b SystemOut O TMPLoggingMessageEnvelope::insertTmpLogging()::tmpLogging::cstn : 5 message is: speed=508.93800870400776,positionLat=37.81680761643989,activity=0,forceTell=false,emergency=false,linkTN=5,trackQuality=11,realTime=true,source=LOCAL,course=1.9023521614737513,positionLon=-77.79656912537705,altitude=12000.0, messageorig is: timestamp is: Sat Jan 02 00:00:00 EST 2100
[5/10/06 12:48:17:236 EDT] 0000006b SystemOut O session.toString():SessionImpl(PersistenceContext[entityKeys=[EntityKey[com.tmp.hibernate.beans.TmpLogging#44]],collectionKeys=[]];ActionQueue[insertions=[EntityInsertAction[com.tmp.hibernate.beans.TmpLogging#44]] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
[5/10/06 12:48:17:236 EDT] 0000006b SystemOut O Hibernate: insert into TMP.TMP_LOGGING (CSTN, TIMESTAMP, MESSAGE, MESSAGEORIGINATOR, ID) values (?, ?, ?, ?, ?)
[5/10/06 12:48:17:256 EDT] 0000006b JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2396)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.spi.SharingViolationException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1044)
... 18 more

[5/10/06 12:48:17:266 EDT] 0000006b JDBCTransacti E org.hibernate.transaction.JDBCTransaction commit JDBC commit failed
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:17:276 EDT] 0000006b SystemOut O <<<<< JMSBackEnd
[5/10/06 12:48:17:276 EDT] 0000006b RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[5/10/06 12:48:17:296 EDT] 0000006b RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 0000010B1F32E52B0000000100000028A51677D56C8D0DF9D60736C0D0BF238E0E0265850000010B1F32E52B0000000100000028A51677D56C8D0DF9D60736C0D0BF238E0E02658500000001. Local resources follow.
[5/10/06 12:48:17:306 EDT] 0000006b RegisteredRes E WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@6ac20e1c <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@4468e71> <meName=widNode.server1-SCA.APPLICATION.widCell.Bus> <meUuid=1A9E7668A287160E> <busName=SCA.APPLICATION.widCell.Bus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=8>]: Vote: commit.
[5/10/06 12:48:17:306 EDT] 0000006b RegisteredRes E WTRN0089I: LocalTransactionWrapper@:28114e0c localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@2e820e0c enlisted:true registeredForSynctruemcWrapper.hashcode()452595212: Vote: none.
[5/10/06 12:48:17:336 EDT] 00000067 SystemOut O >>>>> JMSBackEnd
[5/10/06 12:48:17:336 EDT] 00000067 SystemOut O MessageEnvelopeMDB::JMSBackendBean::onMessage()::Received text message: <?xml version="1.0" encoding="UTF-8"?><LDM:MessageEnvelope xmlns:LDM="http://tempuri.org/LinkDataModel.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><verb>UPDATE</verb><message Originator="ASSETT-Air-Simulator" Topic="LDM/MessageEnvelope/TrackMessage/AirLinkUnit"><airLinkUnit><num>511</num><linkTN><Val>5</Val></linkTN><reportingUnit><Val>O4</Val></reportingUnit><position><lat>37.81680761643989</lat><lon>-77.79656912537705</lon><timeOfValidity>2006-02-20T16:11:32.636-05:00</timeOfValidity></position><course><Val>1.9023521614737513</Val></course><speed><Val>508.93800870400776</Val></speed><forceTell><Val>false</Val></forceTell><emergency><Val>false</Val></emergency><simulation><Val>true</Val></simulation><exercise><Val>false</Val></exercise><source><Val>LOCAL</Val></source><primaryId><Val>5</Val></primaryId><realTime><Val>true</Val></realTime><activity><Val>0</Val></activity><altitude><Val>12000</Val></altitude><trackQuality><Val>11</Val></trackQuality><identity><Val>HOSTILE</Val></identity></airLinkUnit></message></LDM:MessageEnvelope>
[5/10/06 12:48:17:346 EDT] 00000067 SystemOut O TMPLoggingMessageEnvelope::insertTmpLogging()::tmpLogging::cstn : 5 message is: speed=508.93800870400776,positionLat=37.81680761643989,activity=0,forceTell=false,emergency=false,linkTN=5,trackQuality=11,realTime=true,source=LOCAL,course=1.9023521614737513,positionLon=-77.79656912537705,altitude=12000.0, messageorig is: timestamp is: Sat Jan 02 00:00:00 EST 2100
[5/10/06 12:48:17:366 EDT] 00000067 SystemOut O session.toString():SessionImpl(PersistenceContext[entityKeys=[EntityKey[com.tmp.hibernate.beans.TmpLogging#45]],collectionKeys=[]];ActionQueue[insertions=[EntityInsertAction[com.tmp.hibernate.beans.TmpLogging#45]] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
[5/10/06 12:48:17:366 EDT] 00000067 SystemOut O Hibernate: insert into TMP.TMP_LOGGING (CSTN, TIMESTAMP, MESSAGE, MESSAGEORIGINATOR, ID) values (?, ?, ?, ?, ?)
[5/10/06 12:48:17:396 EDT] 00000067 JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2396)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: javax.resource.spi.SharingViolationException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1044)
... 18 more

[5/10/06 12:48:17:406 EDT] 00000067 JDBCTransacti E org.hibernate.transaction.JDBCTransaction commit JDBC commit failed
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:17:416 EDT] 00000067 SystemOut O <<<<< JMSBackEnd
[5/10/06 12:48:17:416 EDT] 00000067 RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[5/10/06 12:48:17:426 EDT] 00000067 RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 0000010B1F32E5B8000000010000002BA51677D56C8D0DF9D60736C0D0BF238E0E0265850000010B1F32E5B8000000010000002BA51677D56C8D0DF9D60736C0D0BF238E0E02658500000001. Local resources follow.
[5/10/06 12:48:17:426 EDT] 00000067 RegisteredRes E WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@43514e05 <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@7acf4e26> <meName=widNode.server1-SCA.APPLICATION.widCell.Bus> <meUuid=1A9E7668A287160E> <busName=SCA.APPLICATION.widCell.Bus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=8>]: Vote: commit.
[5/10/06 12:48:17:436 EDT] 00000067 RegisteredRes E WTRN0089I: LocalTransactionWrapper@:75f38e16 localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@a374e19 enlisted:true registeredForSynctruemcWrapper.hashcode()1726451222: Vote: none.
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at com.tmp.hibernate.common.SequenceManager.getNextSeqValueThroughJDBC(SequenceManager.java:215)
at com.tmp.hibernate.common.SequenceManager.getTmpLoggingIdValue(SequenceManager.java:48)
at com.tmp.hibernate.common.SequenceManager.getTmpLoggingId(SequenceManager.java:258)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:62)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.hibernate.common.SequenceManager.getNextSeqValueThroughJDBC(SequenceManager.java:215)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.hibernate.common.SequenceManager.getTmpLoggingIdValue(SequenceManager.java:48)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.hibernate.common.SequenceManager.getTmpLoggingId(SequenceManager.java:258)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:62)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at $Proxy6.onMessage(Unknown Source)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
[5/10/06 12:48:15:533 EDT] 00000065 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
[5/10/06 12:48:16:034 EDT] 00000065 SystemErr R org.hibernate.TransactionException: JDBC commit failed
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130)
at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by: java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
... 14 more
[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
at com.tmp.hibernate.common.SequenceManager.getNextSeqValueThroughJDBC(SequenceManager.java:215)
at com.tmp.hibernate.common.SequenceManager.getTmpLoggingIdValue(SequenceManager.java:48)
at com.tmp.hibernate.common.SequenceManager.getTmpLoggingId(SequenceManager.java:258)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:62)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy6.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)

[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:790)
[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R at com.tmp.hibernate.common.SequenceManager.getNextSeqValueThroughJDBC(SequenceManager.java:215)
[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R at com.tmp.hibernate.common.SequenceManager.getTmpLoggingIdValue(SequenceManager.java:48)
[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R at com.tmp.hibernate.common.SequenceManager.getTmpLoggingId(SequenceManager.java:258)
[5/10/06 12:48:16:464 EDT] 00000067 SystemErr R at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:62)
[5/10/06 12:48:1


Top
 Profile  
 
 Post subject:
PostPosted: Wed May 10, 2006 1:33 pm 
Expert
Expert

Joined: Tue Apr 25, 2006 12:04 pm
Posts: 260
It depends what you are doing in the following three files. By any chance are you calling Connection.setAutoCommit() method in these 2 files.

at com.tmp.hibernate.common.HibernateAccess.commitHibernateTransaction(HibernateAccess.java:288)
at com.tmp.hibernate.common.HibernateAccess.endHibernateTransaction(HibernateAccess.java:267)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:77)

If you want to add more configuration elements, you could add following

Code:
<property name="transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereExtendedJTATransactionLookup</property>
<property name="transaction.flush_before_completion">true</property>
<property name="transaction.auto_close_session">true</property>


Top
 Profile  
 
 Post subject: Not doing a setAutoCommit()
PostPosted: Wed May 10, 2006 1:41 pm 
Newbie

Joined: Wed May 10, 2006 11:38 am
Posts: 3
No I am not doing a setAutoCommit. Supposely, there is an issue with Hibernate 3 and WAS 6 and a workaround has been looked into. I just need information on this workaround. Or if someone else already has this working, please let me know how you resolved the issue. Thanks.


Top
 Profile  
 
 Post subject: WAS 6 Can't Use Hibernate Transaction????
PostPosted: Wed May 10, 2006 3:21 pm 
Newbie

Joined: Wed May 10, 2006 11:38 am
Posts: 3
I read some documentation which indicated that WAS 6 can't use Hibernate's transaction, so I made the following changes:

1. I am no longer managing the transaction
2. I am no longer managing the closing of the session
3. I am no longer using Hibernate's Transaction and instead am using com.ibm.websphere.jtaextensions.ExtendedJTATransaction
4. I am now getting the following error:

[5/10/06 15:15:20:703 EDT] 00000079 JTATransactio E org.hibernate.transaction.JTATransaction <init> Could not find UserTransaction in JNDI
javax.naming.NameNotFoundException: Name "comp/UserTransaction" not found in context "java:".
at com.ibm.ws.naming.ipbase.NameSpace.lookupInternal(NameSpace.java:1094)
at com.ibm.ws.naming.ipbase.NameSpace.lookup(NameSpace.java:990)
at com.ibm.ws.naming.urlbase.UrlContextImpl.lookup(UrlContextImpl.java:1263)
at com.ibm.ws.naming.java.javaURLContextRoot.lookup(javaURLContextRoot.java:201)
at com.ibm.ws.naming.java.javaURLContextRoot.lookup(javaURLContextRoot.java:142)
at javax.naming.InitialContext.lookup(InitialContext.java:361)
at org.hibernate.transaction.JTATransaction.<init>(JTATransaction.java:60)
at org.hibernate.transaction.JTATransactionFactory.createTransaction(JTATransactionFactory.java:53)
at org.hibernate.jdbc.JDBCContext.getTransaction(JDBCContext.java:187)
at org.hibernate.impl.SessionImpl.getTransaction(SessionImpl.java:1159)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1166)
at com.tmp.hibernate.common.HibernateAccess.getHibernateTransaction(HibernateAccess.java:252)
at com.tmp.hibernate.common.HibernateAccess.beginHibernateTransaction(HibernateAccess.java:265)
at com.tmp.logging.TMPLogging.doTransaction(TMPLogging.java:72)
at com.tmp.logging.TMPLoggingMessageEnvelope.insertTmpLogging(TMPLoggingMessageEnvelope.java:107)
at com.tmp.message.MessageEnvelopeMessageListener.processTextMessage(MessageEnvelopeMessageListener.java:30)
at com.ibm.jms.backend.JMSBackendBean.onMessage(JMSBackendBean.java:41)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:990)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:723)
at $Proxy12.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:571)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:450)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:463)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.