The native stuff will try to keep everything in the same job and will
connect to the database with the user profile associated with the java
job (the job in which the jvm is running. Non-native will create a
connection through the IP port to the database server and operate in a
QZDASOINIT job under the user profile you specify when you create the
connection. Native pretty much ignores the user profile you specify when
you create the connection.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Tuesday, February 24, 2009 11:09 AM
To: Java Programming on and around the iSeries / AS400
Subject: Issue with JDBC connection on AS400
HiI have a java program which creates JDBC connection, I using
com.ibm.as400.access.AS400JDBCDriver as driver, this java program runs
on AS400.
When i run this java program using jt400Native.jar file, i get following
error, but when i run it with JT400.jar file which i copied from my PC
to IFS folder it works
Java call to use jt400Native.jar
java -Djava.version=1.5 -cp
/QIBM/ProdData/OS400/jt400/lib/jt400Native.jar:.
GetAS400JDBCConnection
feb 24 17:13:56:062 CET 2009 as400: Connection null (1469825337) :
Throwing exception. Original exception: .com.ibm.as400.ac
cess.AS400SecurityException: General security error.
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
com.ibm.as400.access.AS400ImplRemote.mapNativeSecurityException(AS400Imp
lRemote.java:2073)
at
com.ibm.as400.access.AS400ImplRemote.swapTo(AS400ImplRemote.java:2033)
at
com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1818)
at
com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2585)
at com.ibm.as400.access.AS400.promptSignon(AS400.java:2156)
at com.ibm.as400.access.AS400.signon(AS400.java:3426)
at com.ibm.as400.access.AS400.connectService(AS400.java:877)
at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnecti
on.java:3017)
at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.j
ava:1256)
at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDrive
r.java:1107)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:357)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:140)
at
GetAS400JDBCConnection.getJDBCConnection(GetAS400JDBCConnection.java:28)
at
GetAS400JDBCConnection.main(GetAS400JDBCConnection.java:35)
mar feb 24 17:13:56:063 CET 2009 as400: Connection null (1469825337)
:
Throwing exception. Actual exception: The application se
rver 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:196)
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(AS400JDBCConnecti
on.java:3021)
at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.j
ava:1256)
at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDrive
r.java:1107)
at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:357)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:140)
at
GetAS400JDBCConnection.getJDBCConnection(GetAS400JDBCConnection.java:28)
at GetAS400JDBCConnection.main(GetAS400JDBCConnection.java:35)
Command to use JT400.jar
java -Djava.version=1.5 -cp /test/jt400.jar:. GetAS400JDBCConnection
This works, i get JDBC connection, what may be the issue
Ashish
--
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.
midrange.com
