Blog : How to connect to AS400 database from Java JDBC

May27


 

Today I had to connect to AS400 database from java application using JDBC connection. AS400 uses DB2 database to store data. So we should get the proper driver for DB2connection.

This will explain how to connect to AS400 from Java Version 5

Driver Name: jt400.jar  

Steps

  1. Download jt400.jar and place it in your lib folder
  2. Driver Name is com.ibm.as400.access.AS400JDBCDriver
  3. Connection URL will be like jdbc:as400:///
  4. Provide Database user name and password

Code(Driver Load)

Connection con =DriverManager.getConnection(url,userId, Password);
Then everything else will as in normal JDBC call

Good Luck


Join Indian Community is USA
Posted in Software / Software category on May 27 2010, 06:17 PM
845 Views, 0 Comments, 10 Appreciations, Overall rating:
Tags: AS400, Java, Programming, Software, code, Oracle
Post a comment | Appreciate this post | Report abuse |

Comments

Back to home

 
X