Connecting Tech Pros Worldwide Forums | Help | Site Map

as400 driver

alan_sec
Guest
 
Posts: n/a
#1: Nov 12 '05
Hi.

Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of
JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that
is installed on windows 2000?
I' m trying to access db2 from java aplication like this:

Class.forName("com.ibm.as400.access.AS400JDBCDrive r");
Connection connection =
DriverManager.getConnection("jdbc:as400://hostname","user","password");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from
tablename");

, and I get this
java.sql.SQLException: The application requester cannot establish the
connection. (Connection refused: connect)
at
com.ibm.as400.access.JDError.throwSQLException(JDE rror.java:521)
at
com.ibm.as400.access.AS400JDBCConnection.setProper ties(AS400JDBCConnection.java:2797)
at
com.ibm.as400.access.AS400JDBCDriver.prepareConnec tion(AS400JDBCDriver.java:1212)
at
com.ibm.as400.access.AS400JDBCDriver.initializeCon nection(AS400JDBCDriver.java:1103)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400 JDBCDriver.java:355)
at java.sql.DriverManager.getConnection(Unknown
Source)
at java.sql.DriverManager.getonnection(Unknown
Source)
at test.DB2Test.main(DB2Test.java:16)

What is the problem?
DB2 is working OK because i accessed it with another driver.
Thanx,
Alan.


Closed Thread