JDBC Adapter Receiver

[Former Member]

Hello everybody,

I need to insert some lines in a Informix DB, I've already deployed the jar file in the Integration Server, now I need to configure the communication channel but this is my first time working with JDBC Adapter, I've got some doubts about the JDBC Driver, Connection and SQL Syntax Parameters, I read the documentation about the Informix JDBC 2.21 Driver and I see that the URL for accessing the DB is

'jdbc:informix-sqli://myhost:1533:informixserver=myserver;

user=myname;password=mypasswd;NEWNLSMAP=rumanian,ro_RO,ISO8859_2;' I think this parameters goes in the Connection parameter, is this right? and with the driver parameter where can I find the driver that I need to call I think is something like this 'com.informix.jdbc.IfxDriver' but is there a place where I can confirm that in the Integration Server or VA just to be sure????? and the where I have more doubts is on the SQL Syntax can anyone give an example on how the parameters should be given in this part, thanks in advance.

Regards,

Julio Cesar

[Former Member]

It was the driver version, thanks.

[Former Member]

Thanks, but I'm having a problem with the driver parameter i get this error

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:informix-sqli://192.168.51.21:1601/INFORMIXSERVER=simefpru_tcp': SAPClassNotFoundException: com.informix.jdbc.IfxDriver

I'm not sure if com.informix.jdbc.IfxDriver is the correct parameter, is there a place where I can see what should this parameter be, I mean I've read the Configuring the Receiver JDBC Adapter help but it makes reference to check driver documentation I've donde that but not specifies anything else than the connection parameter, I can see the deployed jar file in the visual administrator under Libraries com.sap.aii.af.jmsproviderlib and there is the jar file under JAR Files Contained, but I don't know if this is all that is needed and if the value com.informix.jdbc.IfxDriver is the correct parameter or it should be com.sap.aii.af.jmsproviderlib, I've deployed the driver according to file How to Install and Configure External Drivers for JDBC & JMS any help would be really appreciated it.

Regards,

Julio Cesar

[Former Member]

Hi

Refer these they have all the information required for the question:

FILE to JDBC Adapter using SAP XI 3.0

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Thanks

[Former Member]

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

thanx

Aamir

[Former Member]

Here another:

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures