Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

as400 driver

74 views
Skip to first unread message

alan_sec

unread,
Sep 29, 2005, 9:18:46 AM9/29/05
to
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.AS400JDBCDriver");
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(JDError.java:521)
at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2797)
at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1212)
at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1103)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.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.

alan_sec

unread,
Sep 29, 2005, 10:02:42 AM9/29/05
to

Bernd Hohmann

unread,
Sep 29, 2005, 5:25:25 PM9/29/05
to
alan_sec wrote:

":" + strDB_Port

6790

> 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 have no idea but this ...

> java.sql.SQLException: 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ämpfe
des 18. März in Berlin

alan_sec

unread,
Sep 30, 2005, 2:44:52 AM9/30/05
to
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

unread,
Sep 30, 2005, 4:08:50 AM9/30/05
to
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

0 new messages