Re: sqlState: 08004 vendor code -99999 Error when creating JDBC Connection on AS400

Are you using a user name and password for the JDBC connection when using
JT400Native and is that username the same as the job user?





-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:
java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Ashish Kulkarni
Sent: 22 April 2009 16:44
To: java400-l@xxxxxxxxxxxx
Subject: sqlState: 08004 vendor code -99999 Error when creating JDBC
Connection on AS400

HiI am having a JDBC connection issue on V5R4 machine since last 2 days,
when trying to create JDBC connection with jt400Native.jar
and com.ibm.as400.access.AS400JDBCDriver
This happens when the java program is running on AS400, but if i change the
classpath to use jt400.jar then the program works fine
The complete error stack is
Tue Apr 21 17:21:18:070 IST 2009 as400: Connection null (159644216) :
Throwing exception. Actual exception: The application server rejected the
connection. (General security error.) sqlState: 08004 vendor code
-99999.java.sql.SQLException: The application server rejected the
connection. (General security error.)
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Exception.<init>(Exception.java:41)
at java.sql.SQLException.<init>(SQLException.java:40)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at

com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:3021)
at

com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
1256)
at

com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:1107)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:357)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
GetAS400JDBCConnection.getJDBCConnection(GetAS400JDBCConnection.java:28)
at GetAS400JDBCConnection.main(GetAS400JDBCConnection.java:35)

java.sql.SQLException: The application server rejected the connection.
(General security error.)
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Exception.<init>(Exception.java:41)
at java.sql.SQLException.<init>(SQLException.java:40)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at

com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:3021)
at

com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
1256)
at

com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:1107)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:357)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
GetAS400JDBCConnection.getJDBCConnection(GetAS400JDBCConnection.java:28)
at GetAS400JDBCConnection.main(GetAS400JDBCConnection.java:35)
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.