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

Was PTF SI29733 applied over the weekend? You can check *MSGQ QSECOFR and
see if there is a message in there to that effect.

HTH,
Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Wednesday, April 22, 2009 1:51 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: sqlState: 08004 vendor code -99999 Error when creating JDBC
Connection on AS400

HiThis used to work till Monday and works on most of other AS400 machines,
the code i have is as below
If i replace jt400Native.jar with jt400.jar every thing works

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class GetAS400JDBCConnection
{
public Connection getJDBCConnection(String system, String userId,String
password, String libraryList, boolean isDebug)throws Exception
{
Properties prop = new Properties();
prop.put("prompt", "false");
prop.put("naming", "system");
prop.put("date format", "iso");
prop.put("time format", "hms");
prop.put("behavior override", "1");
prop.put("translate binary", "true");
prop.put("libraries", libraryList);
prop.put("user", userId);
prop.put("password", password);
if(isDebug)
{
prop.put("trace", "true");
prop.put("errors", "full");
}
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
String url = "jdbc:as400:" + system;
Connection db2conn = DriverManager.getConnection(url, prop);
return db2conn;
}
}

On Wed, Apr 22, 2009 at 4:37 PM, Neill Harper <neill.harper@xxxxxxxx>
wrote:

I think that might be your problem, I'm not sure but I think the host

might

be rejecting the login because one user is attempting to log in as

another.

If you don't specify a username and password on the jdbc calls it might
actually work as it will detect the user id of the job and use native
authentication.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:
java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Ashish Kulkarni
Sent: 22 April 2009 20:30
To: Java Programming on and around the iSeries / AS400
Subject: Re: sqlState: 08004 vendor code -99999 Error when creating JDBC
Connection on AS400

HiI am using user id, password to create connection and not of the job
user.


On Wed, Apr 22, 2009 at 1:46 PM, Neill Harper <neill.harper@xxxxxxxx>
wrote:

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.j

a

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.j

a

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)
--