Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Posts
    2

    Unanswered: DB2 connectivity error with type 2 driver

    I am getting the following exception:

    db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (C:\IBM\SQLLIB\BIN\db2jcct2.dll is not a valid Win32 application. ): ERRORCODE=-4472, SQLSTATE=null DSRA0010E: SQL State = null, = -4 472

    while trying to connect to DB2 using `com.ibm.db2.jcc.DB2XADataSource` as datasource , but with `com.ibm.db2.jcc.DB2Driver` the connection works fine.

    com.ibm.db2.jcc.DB2XADataSource is created on WebShpere 8.5.5

    Note

    1>with was8.5.5 is 64 bit db2 64 bit OS is 64 bit windows7 - com.ibm.db2.jcc.DB2XADataSource fails db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (C:\IBM\SQLLIB\BIN\db2jcct2.dll is not a valid Win32 application. ): ERRORCODE=-4472, SQLSTATE=null DSRA0010E: SQL State = null, = -4 472

    com.ibm.db2.jcc.DB2Driver also fails same exception as above .

    2>with was8.5.5 is 64 bit db2 32 bit OS is 64 bit windows7 - com.ibm.db2.jcc.DB2Driver works –
    com.ibm.db2.jcc.DB2XADataSource fails with

    with was8.5.5 is 64 bit db2 64 bit OS is 64 bit windows7 - com.ibm.db2.jcc.DB2XADataSource fails db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (C:\IBM\SQLLIB\BIN\db2jcct2.dll is not a valid Win32 application. ): ERRORCODE=-4472, SQLSTATE=null DSRA0010E: SQL State = null, = -4 472

    Full error log

    R java.sql.SQLException: [jcc][10389][12245][3.65.77] Konekielisen kirjaston lataus on epäonnistunut db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (C:\IBM\SQLLIB\BIN\db2jcct2.dll is not a valid Win32 application. ): ERRORCODE=-4472, SQLSTATE=null DSRA0010E: SQL State = null, Error Code = -4 472
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.am.cd.a(cd.java:682)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.am.cd.a(cd.java:60)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.am.cd.a(cd.java:94)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.t2.a.a(a.java:37)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.t2.T2Configuration.<clinit>(T2Conf iguration.java:95)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at java.lang.J9VMInternals.initializeImpl(Native Method)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at java.lang.J9VMInternals.initialize(J9VMInternals.j ava:236)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.DB2BaseDataSource.instantiateLogWr iter(DB2BaseDataSource.java:11074)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWri terForNewConnection(DB2BaseDataSource.java:10986)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWri terForNewConnection(DB2BaseDataSource.java:10939)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB 2XADataSource.java:160)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreH elper$1.run(InternalGenericDataStoreHelper.java:13 53)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:118)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreH elper.getPooledConnection(InternalGenericDataStore Helper.java:1372)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.InternalDB2UniversalDataS toreHelper.getPooledConnection(InternalDB2Universa lDataStoreHelper.java:1821)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java:1998)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.getConnection(WSManagedConnectionFactoryImpl .java:1778)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:1547)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:1103)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.FreePool.createManagedConnectionWi thMCWrapper(FreePool.java:2160)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection (FreePool.java:1838)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.ja va:3802)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.ja va:3078)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java:1548)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java:1031)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:644)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:920)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCHelper.makeJNDIConnect ion(JDBCHelper.java:240)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCHelper.makeConnection( JDBCHelper.java:91)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCExecutor.doDatabaseAcc ess(JDBCExecutor.java:261)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCExecutor.doDatabaseAcc essLoop(JDBCExecutor.java:232)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCExecutor.execute(JDBCE xecutor.java:171)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.jdbc.JDBCExecutor.executeQuery( JDBCExecutor.java:96)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.query.QueryRouter.execute(Query Router.java:69)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.transaction.TXGatewayBean.execu teNonXATrans(TXGatewayBean.java:70)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.transaction.EJSLocalStatelessTX Gateway_3e4b6570.executeNonXATrans(Unknown Source)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.transaction.TXGatewayProxy.exec uteNonXADSProcess(TXGatewayProxy.java:112)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.transaction.TXGatewayProxy.exec ute(TXGatewayProxy.java:82)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.query.QueryPartManager.execute( QueryPartManager.java:133)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.query.QuerySetManager.executeOr dinaryQuery(QuerySetManager.java:105)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.query.QuerySetManager.execute(Q uerySetManager.java:70)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.query.QueryManager.execute(Quer yManager.java:152)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.core.EIFDataProviderWorker.doWo rk(EIFDataProviderWorker.java:117)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.comm.core.ejb.workerproxy.WorkerPro xyBeanImpl.runWorker(WorkerProxyBeanImpl.java:111)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.comm.core.ejb.workerproxy.WorkerPro xyBeanImpl.runWorkerSupports(WorkerProxyBeanImpl.j ava:193)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.comm.core.ejb.workerproxy.EJSLocalS tatelessEISLocalWorkerProxySLSB_f23d1ba3.runWorker Supports(Unknown Source)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.comm.rmi.RMISender.execute(RMISende r.java:291)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.comm.rmi.RMISender.execute(RMISende r.java:237)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.eis.external.EIFInformationGatewayI mpl.execute(EIFInformationGatewayImpl.java:131)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.referencedata.ReferenceDataManager. readReferenceData(ReferenceDataManager.java:540)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.referencedata.ReferenceDataManager. getLocaleMap(ReferenceDataManager.java:682)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.referencedata.ReferenceDataManager. getReferenceDataMap(ReferenceDataManager.java:607)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.referencedata.ReferenceDataManager. getMergedReferenceDataMap(ReferenceDataManager.jav a:308)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.referencedata.ReferenceDataManager. getKeys(ReferenceDataManager.java:279)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.util.ReferenceDataStartupHelper.exe cute(ReferenceDataStartupHelper.java:39)
    [15.5.2014 21:09:48:639 EEST] 000000d3 SystemErr R at com.meridea.cs.wfengine.activities.InitActivity.ru n_act(InitActivity.java:40)

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Use only the type-4 driver (as the type-2 driver is discontinued from v10)

  3. #3
    Join Date
    May 2014
    Posts
    2
    Are you sure of this fact since with websphere 7 and DB 10 the type 2 works fine.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Quote Originally Posted by Joydeep_bha View Post
    Are you sure of this fact since with websphere 7 and DB 10 the type 2 works fine.
    The type 2 driver has been deprecated since DB2 v8.2 and discontinued from V10

    Information Source:
    What's new in DB2 V10.1: DB2 JDBC Type 2 Driver has been discontinued

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •