× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Sorry, I just reread your post and noticed that you're on v5r4. The PTFs
there are SI30131 and SI30132 or anything superseding those PTFs.

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Gary L Peskin
Sent: Wednesday, April 22, 2009 4:04 PM
To: 'Java Programming on and around the iSeries / AS400'
Subject: 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)
--


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.