on 02-20-2006 9:02 AM
Hi,
I want to call a DB on AS 400 OS.
do i need to deply the JDBC to the XI first?
does anyone know which driver i should use?
thanks
HI Udi,
pls take a look at http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html
First you have to deploy with SDM the corresponding Drivers.
In my case the driver is:
com.ibm.as400.access.AS400JDBCDriver
Then in your configuration Channel you have to use this string:
jdbc:as400://"Your IP":446/"Your Schema";date format=iso;date separator=-
Good luck.
JJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Refer to the documentation on the URL
http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/index.htm?info/java/rzaha/jdbc.htm
It is the driver for DB2.
If your XI server does not have the DB2 drivers already installed, you will have to install the same.
There is a new tool available at Service Marketplace which makes it easy to deploy JDBC / JMS driver.
the URL is
https://websmp105.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDriver.zip
Check out the drivertool utility in this zip.
Regards,
Amol
PS : Please reward points for useful posts.
Message was edited by: Amol Joshi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am using the AS/400 Toolbox for java, instead of AS/400 DevKit4Java, and I found this other IBM page very useful.
http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/info/java/rzahh/jdbc.htm
Regards,
Alex
Hi Udi,
//do i need to deply the JDBC to the XI first?
Yes. To access any Database from XI, the corresponding driver has to be deployed on your XI server.
For info on how the drivers have to be installed, check these links,
Regards,
Bhavesh
Message was edited by: Bhavesh Kantilal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.