as400 driver

[alan_sec]

Hi.

Does the com.ibm.as400.a ccess.AS400JDBC Driver 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.a ccess.AS400JDBC Driver");
Connection connection =
DriverManager.g etConnection("j dbc:as400://hostname","user ","password ");
Statement statement = connection.crea teStatement();
ResultSet resultSet = statement.execu teQuery("select * from
tablename");

, and I get this
java.sql.SQLExc eption: The application requester cannot establish the
connection. (Connection refused: connect)
at
com.ibm.as400.a ccess.JDError.t hrowSQLExceptio n(JDError.java: 521)
at
com.ibm.as400.a ccess.AS400JDBC Connection.setP roperties(AS400 JDBCConnection. java:2797)
at
com.ibm.as400.a ccess.AS400JDBC Driver.prepareC onnection(AS400 JDBCDriver.java :1212)
at
com.ibm.as400.a ccess.AS400JDBC Driver.initiali zeConnection(AS 400JDBCDriver.j ava:1103)
at
com.ibm.as400.a ccess.AS400JDBC Driver.connect( AS400JDBCDriver .java:355)
at java.sql.Driver Manager.getConn ection(Unknown
Source)
at java.sql.Driver Manager.getonne ction(Unknown
Source)
at test.DB2Test.ma in(DB2Test.java :16)

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

[Bernd Hohmann]

alan_sec wrote:

":" + strDB_Port

6790

Does the com.ibm.as400.a ccess.AS400JDBC Driver driver that is part of
JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that
is installed on windows 2000?
I have no idea but this ...
java.sql.SQLExc eption: The application requester cannot establish the
connection. (Connection refused: connect)

... sounds if your driver doesn't connect to the right port. The default
port for the DB2JD process (at least under eCS) is 6790 so
"jdbc:as400 ://hostname:6790" will solve your problems.

Let me hear if it helps.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin

[alan_sec]

It doesn't help. I tryed with db2java driver that was shiped with db2
udb and it works fine, but i need to test it with as400 driver.
Thanx for repying.
Alan

[Bernd Hohmann]

alan_sec wrote:

It doesn't help. I tryed with db2java driver that was shiped with db2
udb and it works fine, but i need to test it with as400 driver.

In this case I'm out of ideas, unfortunately.

Bernd