java.sql.SQLException: enlist: caught Exception at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(Ad apterUtil.java:1247) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTr ansactionIfNecessary(WSJdbcConnection.java:654) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.getMeta Data(WSJdbcConnection.java:1533) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:169) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:92) at org.springframework.jdbc.support.JdbcAccessor.getE xceptionTranslator(JdbcAccessor.java:96) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:266) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:326) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:330) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:334) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:342) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:347) at ca.thedominion.brokergateway.persistence.impl.Brok erGatewayDAOImpl.getNextSrcDtlId(BrokerGatewayDAOI mpl.java:65) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.getCorrelationId(BrokerGatewaySer viceImpl.java:181) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.splitPaymentsForLoad(BrokerGatewa yServiceImpl.java:109) at ca.thedominion.brokergateway.listeners.BrokerGatew ayImportListenerBean.onMessage(BrokerGatewayImport ListenerBean.java:62) at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnM essage.run(MDBWrapper.java:302) at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:63) at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage( MDBWrapper.java:271) at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBW rapper.java:240)

spring.io | 2 months ago
  1. 0

    Error while extracting DatabaseMetaData - Spring Forum

    spring.io | 2 months ago
    java.sql.SQLException: enlist: caught Exception at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(Ad apterUtil.java:1247) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTr ansactionIfNecessary(WSJdbcConnection.java:654) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.getMeta Data(WSJdbcConnection.java:1533) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:169) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:92) at org.springframework.jdbc.support.JdbcAccessor.getE xceptionTranslator(JdbcAccessor.java:96) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:266) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:326) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:330) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:334) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:342) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:347) at ca.thedominion.brokergateway.persistence.impl.Brok erGatewayDAOImpl.getNextSrcDtlId(BrokerGatewayDAOI mpl.java:65) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.getCorrelationId(BrokerGatewaySer viceImpl.java:181) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.splitPaymentsForLoad(BrokerGatewa yServiceImpl.java:109) at ca.thedominion.brokergateway.listeners.BrokerGatew ayImportListenerBean.onMessage(BrokerGatewayImport ListenerBean.java:62) at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnM essage.run(MDBWrapper.java:302) at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:63) at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage( MDBWrapper.java:271) at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBW rapper.java:240)
  2. 0

    EJB Trasaction & Spring - Spring Forum

    spring.io | 2 months ago
    java.sql.SQLException: DSRA9002E: ResourceException with error code null: javax.resource.ResourceException: enlist: caught Exception at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(Loc alTransactionWrapper.java:609) at com.ibm.ejs.j2c.ConnectionEventListener.interactio nPending(ConnectionEventListener.java:743) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImp l.processInteractionPendingEvent(WSRdbManagedConne ctionImpl.java:1299) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTr ansactionIfNecessary(WSJdbcConnection.java:328) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.getMeta Data(WSJdbcConnection.java:1014) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:95) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:209) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:115) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:96) at org.springframework.jdbc.support.JdbcAccessor.getE xceptionTranslator(JdbcAccessor.java:76) at org.springframework.jdbc.support.JdbcAccessor.afte rPropertiesSet(JdbcAccessor.java:93) at org.springframework.jdbc.core.JdbcTemplate.<init>( JdbcTemplate.java:131) at org.springframework.jdbc.core.support.JdbcDaoSuppo rt.setDataSource(JdbcDaoSupport.java:58)
  3. 0

    Mombu the Microsoft Forum - Integrating w 3rd party TransactionManager

    mombu.com | 11 months ago
    java.sql.SQLException: Failed to create the XA control connection. Error: xp_sqljdbc_xa_init failure, status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_init, state=1, StatusCode:0 (0x00000000) ***. at edu.taylor.jta.TransactionAwareXADataSource.enlist ResourceIfTransactionExists(TransactionAwareXAData Source.java:49) at edu.taylor.jta.TransactionAwareXADataSource.getCon nection(TransactionAwareXADataSource.java:28) at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java:77) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:164) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:92) at org.springframework.orm.hibernate3.SessionFactoryU tils.newJdbcExceptionTranslator(SessionFactoryUtil s.java:133) at org.springframework.orm.hibernate3.HibernateAccess or.getJdbcExceptionTranslator(HibernateAccessor.ja va:235) at org.springframework.orm.hibernate3.HibernateTempla te.getSession(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTempla te.execute(HibernateTemplate.java:354) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:817) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:809) at edu.taylor.jta.QuerierObjectImpl.getSomeEntities(Q uerierObjectImpl.java:12) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Integrating w/ 3rd party TransactionManager?

    tech-archive.net | 11 months ago
    java.sql.SQLException: Failed to create the XA control connection. Error: xp_sqljdbc_xa_init failure, status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_init, state=1, StatusCode:0 (0x00000000) ***. at edu.taylor.jta.TransactionAwareXADataSource.enlistResourceIfTransactionExists(TransactionAwareXADataSource.java:49) at edu.taylor.jta.TransactionAwareXADataSource.getConnection(TransactionAwareXADataSource.java:28) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:164) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:92) at org.springframework.orm.hibernate3.SessionFactoryUtils.newJdbcExceptionTranslator(SessionFactoryUtils.java:133) at org.springframework.orm.hibernate3.HibernateAccessor.getJdbcExceptionTranslator(HibernateAccessor.java:235) at org.springframework.orm.hibernate3.HibernateTemplate.getSession(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:354) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:817) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:809) at edu.taylor.jta.QuerierObjectImpl.getSomeEntities(QuerierObjectImpl.java:12)
  6. 0

    error code [17041]; Missing IN or OUT parameter at index:: - Spring Forum

    spring.io | 1 year ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 4 at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:951) at org.springframework.jdbc.core.JdbcTemplate.call(Jd bcTemplate.java:984) at org.springframework.jdbc.object.StoredProcedure.ex ecute(StoredProcedure.java:117)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      enlist: caught Exception at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(Ad apterUtil.java:1247) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTr ansactionIfNecessary(WSJdbcConnection.java:654) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.getMeta Data(WSJdbcConnection.java:1533) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:169) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:92) at org.springframework.jdbc.support.JdbcAccessor.getE xceptionTranslator(JdbcAccessor.java:96) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:266) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:326) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:330) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:334) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:342) at org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:347) at ca.thedominion.brokergateway.persistence.impl.Brok erGatewayDAOImpl.getNextSrcDtlId(BrokerGatewayDAOI mpl.java:65) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.getCorrelationId(BrokerGatewaySer viceImpl.java:181) at ca.thedominion.brokergateway.service.impl.BrokerGa tewayServiceImpl.splitPaymentsForLoad(BrokerGatewa yServiceImpl.java:109) at ca.thedominion.brokergateway.listeners.BrokerGatew ayImportListenerBean.onMessage(BrokerGatewayImport ListenerBean.java:62) at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnM essage.run(MDBWrapper.java:302) at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:63) at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage( MDBWrapper.java:271) at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBW rapper.java:240)

      at com.ibm.mq.jms.MQSession.run()
    2. com.ibm.mq
      MQSession.run
      1. com.ibm.mq.jms.MQSession.run(MQSession.java:1682)
      1 frame
    3. Java RT
      Method.invoke
      1. java.lang.reflect.Method.invoke(Method.java:615)
      1 frame