Skip to Content
avatar image
Former Member

JDBC Adapter Receiver

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 18, 2007 at 03:40 PM

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

    thanx

    Aamir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 05:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 09:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 10:54 PM

    It was the driver version, thanks.

    Add comment
    10|10000 characters needed characters exceeded