Skip to Content
0
Former Member
Sep 18, 2007 at 03:36 PM

JDBC Adapter Receiver

48 Views

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