Error While Creating Informix Connection Pool

[Nitin Nair]

Hi,
I am trying to port an application from Weblogic 6.1 to Weblogic 8.1. The Application accesses Informix database. I used the following driver, url and properties while connecting to this database using Weblogic 6.1
url:->[b]jdbc:weblogic:informix4:snss_live[/b]
Driver ClassName :-> [b]weblogic.jdbc.informix.InformixDriver[/b]
Properties :->
[b]port=22000[/b]
[b]user=snssadmn[/b]
[b]password=snssadmn[/b]
[b]server=10.115.26.40[/b]

The above used to work fine with weblogic 6.1

With Weblogic 8.1, I am using the following properties

url :-> [b]jdbc:bea:informix://10.115.26.40:22000;informixServer=10.115.26.40;databaseName=snss_live[/b]

Driver ClassName :-> [b]weblogic.jdbc.informix.InformixDriver[/b]

Properties :->
[b]informixServer=10.115.26.40[/b]
[b]user=snssadmn[/b]
[b]portNumber=22000[/b]
[b]databaseName=snss_live[/b]
[b]serverName=10.115.26.40[/b]

However using these properties I am getting the following error while deploying the Connection Pool to the Managed Server
[b]<Dec 29, 2004 12:26:53 PM EST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "Btv_Vms_Pool": [BEA][Informix JDBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.>[/b]
[b]<Dec 29, 2004 12:26:54 PM EST> <Error> <JDBC> <BEA-001150> <Connection Pool "Btv_Vms_Pool" deployment failed with the following error: 0:Could not create pool connection. The DBMS driver exception was: [BEA][Informix JDBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES..>[/b]

Any idea as to why this is happening

Regards
Nitin Nair

[Joe Weinstein]

Hi. I suspect that the databaseName property is causing the problem in
8.1. Remove it and see if that works. Also, try running:

java utils.dbping, and giving it the properties it asks for, for your
Informix connection. Once it succeeds in making a connection, it will
print out the URL and properties it used. Then define the pool with
those (and only those) properties and URL.
Joe

Post by Nitin Nair
Hi,
I am trying to port an application from Weblogic 6.1 to Weblogic 8.1. The Application accesses Informix database. I used the following driver, url and properties while connecting to this database using Weblogic 6.1
url:->[b]jdbc:weblogic:informix4:snss_live[/b]
Driver ClassName :-> [b]weblogic.jdbc.informix.InformixDriver[/b]
Properties :->
[b]port=22000[/b]
[b]user=snssadmn[/b]
[b]password=snssadmn[/b]
[b]server=10.115.26.40[/b]
The above used to work fine with weblogic 6.1
With Weblogic 8.1, I am using the following properties
url :-> [b]jdbc:bea:informix://10.115.26.40:22000;informixServer=10.115.26.40;databaseName=snss_live[/b]
Driver ClassName :-> [b]weblogic.jdbc.informix.InformixDriver[/b]
Properties :->
[b]informixServer=10.115.26.40[/b]
[b]user=snssadmn[/b]
[b]portNumber=22000[/b]
[b]databaseName=snss_live[/b]
[b]serverName=10.115.26.40[/b]
However using these properties I am getting the following error while deploying the Connection Pool to the Managed Server
[b]<Dec 29, 2004 12:26:53 PM EST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "Btv_Vms_Pool": [BEA][Informix JDBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.>[/b]
[b]<Dec 29, 2004 12:26:54 PM EST> <Error> <JDBC> <BEA-001150> <Connection Pool "Btv_Vms_Pool" deployment failed with the following error: 0:Could not create pool connection. The DBMS driver exception was: [BEA][Informix JDBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES..>[/b]
Any idea as to why this is happening
Regards
Nitin Nair

[Deepak Vohra]

Add Informix JDBC jar to Classpath.
Set Connection URL:

jdbc:informix-sqli://<host>:<port>/<database>:INFORMIXSERVER=<server>

Driver Class:
com.informix.jdbc.IfxDriver

[Joe Weinstein]

Post by Deepak Vohra
Add Informix JDBC jar to Classpath.
jdbc:informix-sqli://<host>:<port>/<database>:INFORMIXSERVER=<server>
com.informix.jdbc.IfxDriver

He's not using IBM's informix driver.

[Deepak Vohra]

[i]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.[/i]

Set the INFORMIXSERVER to match the DBSERVERNAME.