Informin Connection Enabling Error

, ,
1

i 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.

2

can you check, if the jars are loaded correctly, when IS is started? Check if all the jars are listed in the java classpath.

3

yes i have started IS i kept in same location mentioned above getting same error,can i using correct jars file ,do i need to kepp any other jar file.

please provide me the links to download all jar files to connect informix 11.50 version database,i think i need to keep new jar files ,those files may be corrupted.

am i giving correct property setting to connect to informix database?

4

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

5

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

6

Hi All,
i removed all jar file from lib locations and i sucedded by these jar files ifxjdbc.jar and ifxjdbcx.jar,before ifxjdbcx.jar i didnot have this jar file,only these two files required to connect to the informix 11.50 database with below details.

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

regards,
anil kumar ellendula

7

Hi All,
i removed all jar file from lib locations and i sucedded by these jar files ifxjdbc.jar and ifxjdbcx.jar,before ifxjdbcx.jar i didnot have this jar file,only these two files required to connect to the informix 11.50 database with below details.

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

regards,
anil kumar ellendula