javax.resource.ResourceException: Could not create connection

Stack Overflow | Karthik Kumar | 6 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.

Root Cause Analysis

  1. java.sql.SQLException

    [XQuery][DB2 JDBC Driver]Bind process is not active. Please ensure that the user has permissions to create packages. Packages cannot be created in an XA Connection.

    at com.ddtek.xquery.jdbc.db2base.ddcp.b()
  2. com.ddtek.xquery
    BaseDriver.connect
    1. com.ddtek.xquery.jdbc.db2base.ddcp.b(Unknown Source)[xqdb2.jar:]
    2. com.ddtek.xquery.jdbc.db2base.ddcp.a(Unknown Source)[xqdb2.jar:]
    3. com.ddtek.xquery.jdbc.db2base.ddco.b(Unknown Source)[xqdb2.jar:]
    4. com.ddtek.xquery.jdbc.db2base.ddco.a(Unknown Source)[xqdb2.jar:]
    5. com.ddtek.xquery.jdbc.db2.drda.ddb.a(Unknown Source)[xqdb2.jar:]
    6. com.ddtek.xquery.jdbc.db2.drda.ddp.b(Unknown Source)[xqdb2.jar:]
    7. com.ddtek.xquery.jdbc.db2.ddj.e(Unknown Source)[xqdb2.jar:]
    8. com.ddtek.xquery.jdbc.db2.ddj.a(Unknown Source)[xqdb2.jar:]
    9. com.ddtek.xquery.jdbc.db2.DB2ImplConnection.d(Unknown Source)[xqdb2.jar:]
    10. com.ddtek.xquery.jdbc.db2base.BaseConnection.b(Unknown Source)[xqdb2.jar:]
    11. com.ddtek.xquery.jdbc.db2base.BaseConnection.k(Unknown Source)[xqdb2.jar:]
    12. com.ddtek.xquery.jdbc.db2base.BaseConnection.b(Unknown Source)[xqdb2.jar:]
    13. com.ddtek.xquery.jdbc.db2base.BaseConnection.a(Unknown Source)[xqdb2.jar:]
    14. com.ddtek.xquery.jdbc.db2base.BaseDriver.connect(Unknown Source)[xqdb2.jar:]
    14 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:571)[rt.jar:1.7.0_51]
    2. java.sql.DriverManager.getConnection(DriverManager.java:215)[rt.jar:1.7.0_51]
    2 frames
  4. com.ddtek.xquery
    MediatorConnection.connect
    1. com.ddtek.xquery.extractor.ExtractorDataSource.createJDBCConnection(ExtractorDataSource.java:257)[ddxq.jar:]
    2. com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:120)[ddxq.jar:]
    3. com.ddtek.xquery.mediator.SqlAdapter.connect(SqlAdapter.java:68)[ddxq.jar:]
    4. com.ddtek.xquery.mediator.MediatorConnection.connect(MediatorConnection.java:85)[ddxq.jar:]
    4 frames
  5. com.ddtek.xquery3
    XQueryDriver.connect
    1. com.ddtek.xquery3.xqj.DDXQConnection.<init>(DDXQConnection.java:81)[ddxq.jar:]
    2. com.ddtek.xquery3.xqj.DDXQDataSource._getConnection(DDXQDataSource.java:1528)[ddxq.jar:]
    3. com.ddtek.xquery3.xqj.DDXQDataSource.getConnection(DDXQDataSource.java:883)[ddxq.jar:]
    4. com.ddtek.xquery3.jdbc.XQueryDriver.connect(XQueryDriver.java:152)[ddxq.jar:]
    4 frames
  6. IronJacamar
    LocalManagedConnectionFactory.getLocalManagedConnection
    1. org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:260)[ironjacamar-jdbc.jar:1.0.23.1.Final-redhat-1]
    1 frame
  7. IronJacamar
    AbstractConnectionManager.allocateConnection
    1. org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:344)
    2. org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:404)
    3. org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:372)
    4. org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:364)
    5. org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
    6. org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
    6 frames
  8. IronJacamar
    WrapperDataSource.getConnection
    1. org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)[ironjacamar-jdbc.jar:1.0.23.1.Final-redhat-1]
    1 frame
  9. com.amex.common
    ConnectionFactory.createJNDIConnection
    1. com.amex.common.dataaccess.ConnectionFactory.createJNDIConnection(ConnectionFactory.java:117)[AmexCommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    1 frame
  10. com.amex.dce
    XMLJNDIConnectionType.getConnection
    1. com.amex.dce.common.dataaccess.XMLJNDIConnectionType.getConnection(XMLJNDIConnectionType.java:35)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    1 frame
  11. com.amex.common
    AbstractAmexConnectionType.getConnection
    1. com.amex.common.dataaccess.AbstractAmexConnectionType.getConnection(AbstractAmexConnectionType.java:20)[AmexCommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    1 frame
  12. com.amex.dce
    DataDirectXQueryDAO.writeXQueryResultsToFile
    1. com.amex.dce.common.dataaccess.xquery.XMLJNDIConnection.getConnection(XMLJNDIConnection.java:54)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    2. com.amex.dce.common.dataaccess.xquery.XMLJNDIConnection.openConnection(XMLJNDIConnection.java:38)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    3. com.amex.dce.common.dataaccess.xquery.XMLJNDIConnection.getXQConnection(XMLJNDIConnection.java:30)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    4. com.amex.dce.common.dataaccess.xquery.AbstractDDXQConnection.getPreparedExpressionWithBinding(AbstractDDXQConnection.java:56)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    5. com.amex.dce.common.dataaccess.xquery.DataDirectXQueryFileStreamer.streamToFile(DataDirectXQueryFileStreamer.java:105)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    6. com.amex.dce.common.dataaccess.xquery.DataDirectXQueryFileStreamer.streamXQueryToFile(DataDirectXQueryFileStreamer.java:48)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    7. com.amex.dce.common.dataaccess.xquery.DataDirectXQueryDAO.writeXQueryResultsToFile(DataDirectXQueryDAO.java:87)[DCECommon-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
    7 frames
  13. com.amex.matic
    DCEItemPreparer.execute
    1. com.amex.matic.dce.CatalogBuilder.prepareCatalogFile(CatalogBuilder.java:126)[classes:]
    2. com.amex.matic.dce.CatalogBuilder.buildCatalog(CatalogBuilder.java:77)[classes:]
    3. com.amex.matic.dce.Catalog.build(Catalog.java:55)[classes:]
    4. com.amex.matic.dce.Catalog.<init>(Catalog.java:33)[classes:]
    5. com.amex.matic.dce.DCEItemPreparer.getCatalog(DCEItemPreparer.java:239)[classes:]
    6. com.amex.matic.dce.DCEItemPreparer.buildAndUploadItem(DCEItemPreparer.java:197)[classes:]
    7. com.amex.matic.dce.DCEItemPreparer.handleRosterItem(DCEItemPreparer.java:168)[classes:]
    8. com.amex.matic.dce.DCEItemPreparer.prepareItems(DCEItemPreparer.java:88)[classes:]
    9. com.amex.matic.dce.DCEItemPreparer.execute(DCEItemPreparer.java:59)[classes:]
    10. com.amex.matic.dce.DCEItemPreparer.prepareItems(DCEItemPreparer.java:88)[classes:]
    11. com.amex.matic.dce.DCEItemPreparer.execute(DCEItemPreparer.java:59)[classes:]
    11 frames
  14. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)[quartz-2.2.1.jar:]
    2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)[quartz-2.2.1.jar:]
    2 frames