on 09-18-2007 4:36 PM
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
It was the driver version, thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30
thanx
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.