on 02-07-2006 4:33 PM
Hi,
I need to connect to the DB2 database running in As400 and and i need to know how would you specify the connection parameter in the JDBC adapter for DB2 database.
I have worked on SQL and Oracle but the similar ways doesn't work for DB2 ..
can any one help me.
thankx,
Shree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
what means similar way does not work? What have you done so far?
Necessary steps would be:
1. Get a JDBC driver for your DB2 version and deploy it as stated in XI documentation
2. Check the Documentation of your JDBC driver for the driver class name (with package) to be put in configuration
3. Check the JDBC driver doc for the syntax of the connection string, as this differs from driver to driver.
Have you carried out any of this steps or where are you stuck right now?
Have a look at this link on IBM documentation giving some hints. http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/tjvjcccn.htm
For example the connection string should look like String "jdbc:db2://sysmvs1.stl.ibm.com:5021/san_jose:user=db2adm;password=db2adm;" if you use the DB2 Universal JDBC Driver.
Best regards
Christine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.