am working on 7.1.1 version having 6.5 JDBC Adapter and informix Databse is 11 version
while am enable the connection i got the following error.
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.InformixConnection:InformixConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class “com.informix.jdbcx.ifxDataSource” cannot be located.
com.informix.jdbcx.ifxDataSource
i copied the jar file in
<int_Loc>\lib\jars\ifxjdbc-2.1.jar
<int_Loc>\lib\jars\ifxjdbc.jar
<int_Loc>\lib\jars\xerces.jar
<int_Loc>\packages\WmJDBCAdapter\code\jars\static\ifxjdbc-2.1.jar
<int_Loc>\packages\WmJDBCAdapter\code\jars\static\ifxjdbc.jar
<int_Loc>\packages\WmJDBCAdapter\code\jars\static\xerces.jar
connection details are
DWAFCommon.InformixConnection:InformixConnection Details
Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.informix.jdbcx.ifxDataSource
serverName inf_10_wart
user wmarsrd
password ******
databaseName nc_ws
portNumber 1541
networkProtocol olsoctcp
Other Properties ifxIFXHOST=10.132.32.228
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
any one help me why am getting the error,am i using correct jar files can any one attach the jar file need to connect to the Informix database.
Hi All,
I Removed ifxjdbc-2.1.jar,ifxjdbc.jar,xerces.jar files from the <int_Loc>\lib\jars\ and <int_Loc>\packages\WmJDBCAdapter\code\jars\static\ locations and
i kept
JDBC.2.21.JC4.jar,JDBC.3.50.JC3DE.jar files in <int_Loc>\lib\jars\ <int_Loc>\packages\WmJDBCAdapter\code\jars\static\ and which i downloaded from IBM site. the propert setting for connection is
InformixConnection Details
Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.informix.jdbcx.IfxDataSource
serverName inf_10_wart
user warmsrd
password ******
databaseName nc_ws
portNumber 1565
networkProtocol tcp/ip
Other Properties IfxIFXHOST=10.132.32.228
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
i got below error while enabling the connection
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource DWAFCommon.InformixConnection:InformixConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class “com.informix.jdbcx.IfxDataSource” cannot be located.
com.informix.jdbcx.IfxDataSource.
please any one help me on drivers jar files where i can be downloaded the jar files for informix database 11.50 version and WM 7.1.1 version having JDBC 6.5 version adapters.
please attach me (anilellendula@gmail.com)the jar files to connect to the informix databse or give me the url to get download it.
regards,
anil kumar e
hi all,
i downloaded JDBC.2.21.JC4.jar,JDBC.3.50.JC3DE.jar,JDBC.3.00.JC1DE.jar and
JDBC.3.10.JC1DE jar files,which i downloaded from ibm
site(http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc),kept these files in in IntegrationServer/lib/jars and
WmJDBCAdapter\code\jars\static folde,i got the below error.
InformixConnection Details
Connection Type JDBC Adapter Connection
Package Name DWAFCommon
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.informix.jdbcx.IfxDataSource
serverName inf_10_wart
user warmsrd
password ******
databaseName nc_ws
portNumber 1565
networkProtocol tcp/ip
Other Properties IfxIFXHOST=10.132.32.228
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
Error
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable
connection resource DWAFCommon.InformixConnection:InformixConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure
connection manager.
[ADA.1.200] The JDBC DataSource class
“com.informix.jdbcx.IfxDataSource” cannot be located.
com.informix.jdbcx.IfxDataSource
please send me the jar files and connection properties to set in connection