MagarG
VIP Member
AS400 V4R5
CO on NT SP6a
Xe SP14.1
JAS 14.1
WebSphere 3.5 on AS400
With our current setup we can access Xe through the HTML client. On page 72 of the "OW Java Server Installation Guide, AS400 with Websphere 3.5", there are performance changes you can make if your AS400 is your web server. The section is called "Editting the jas.ini to include the AS400 Native JDBC Driver". When we make these changes we can no longer get by the login screen and get a null pointer error so we have to put it back. Here's the ini.
Works
------------------------------------------------------------------------------------------
[JDBC DRIVERS]
I=com.ibm.as400.access.AS400JDBCDriver
[JDBC URL]
JDV7333=jdbc:as400://MYAS400|I|DV7333DNT|JDE|JDE
JPY7333=jdbc:as400://MYAS400|I|PY7333DNT|JDE|JDE
JPD7333=jdbc:as400://MYAS400|I|PD7333DNT|JDE|JDE
DEFAULT=jdbc:as400://MYAS400|I|PD7333DNT|JDE|JDE
Doesn't work
------------------------------------------------------------------------------------------
[JDBC DRIVERS]
I=com.ibm.db2.jdbc.app.DB2Driver
[JDBC URL]
JDV7333=jdbc:db2://MYAS400|I|DV7333DNT|JDE|JDE
JPY7333=jdbc:db2://MYAS400|I|PY7333DNT|JDE|JDE
JPD7333=jdbc:db2://MYAS400|I|PD7333DNT|JDE|JDE
DEFAULT=jdbc:db2://MYAS400|I|PD7333DNT|JDE|JDE
----------------------------
jas.log
2001-04-24 11:00:34.279 [Pooled ORB request dispatch WorkerThread] LIB : ***** File [/JDEdwardsOneWorld/B7333/jas.log] opened
2001-04-24 11:00:34.313 [Pooled ORB request dispatch WorkerThread] LIB : SysInfo: OS/400 V4R5M0 PowerPC JavaInfo: IBM Corporation 1.2
2001-04-24 11:00:36.151 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup initiated
2001-04-24 11:00:38.138 [Pooled ORB request dispatch WorkerThread] JAS : JDBC Driver <com.ibm.db2.jdbc.app.DB2Driver> is registered. Major Version <4> Minor Version <0>
2001-04-24 11:00:41.984 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup complete
2001-04-24 11:02:30.867 [Worker#23] JAS : trying DriverManager.getConnection/new OWConnection to Datasource : OMDATP: PD7333, OMSRVR: MHSAS400, OMDATB: System - B7333, OMOOWN: null, OMLL: null, OMLIB: SYS7333, OMOMUI: null, OMOMTO: Y, OMOMDS: Y, OMOMJD: Y, OMOMCC: null, OMDSTP: I, OMOCMB: null, dbUser: null
java.sql.SQLException: No suitable driver
java/lang/Throwable.<init>(Ljava/lang/StringV+4 (Throwable.java:94)
----------------------------
Anyone running this configuration and seen this or have gotten it to work? tia, Grant.
CO on NT SP6a
Xe SP14.1
JAS 14.1
WebSphere 3.5 on AS400
With our current setup we can access Xe through the HTML client. On page 72 of the "OW Java Server Installation Guide, AS400 with Websphere 3.5", there are performance changes you can make if your AS400 is your web server. The section is called "Editting the jas.ini to include the AS400 Native JDBC Driver". When we make these changes we can no longer get by the login screen and get a null pointer error so we have to put it back. Here's the ini.
Works
------------------------------------------------------------------------------------------
[JDBC DRIVERS]
I=com.ibm.as400.access.AS400JDBCDriver
[JDBC URL]
JDV7333=jdbc:as400://MYAS400|I|DV7333DNT|JDE|JDE
JPY7333=jdbc:as400://MYAS400|I|PY7333DNT|JDE|JDE
JPD7333=jdbc:as400://MYAS400|I|PD7333DNT|JDE|JDE
DEFAULT=jdbc:as400://MYAS400|I|PD7333DNT|JDE|JDE
Doesn't work
------------------------------------------------------------------------------------------
[JDBC DRIVERS]
I=com.ibm.db2.jdbc.app.DB2Driver
[JDBC URL]
JDV7333=jdbc:db2://MYAS400|I|DV7333DNT|JDE|JDE
JPY7333=jdbc:db2://MYAS400|I|PY7333DNT|JDE|JDE
JPD7333=jdbc:db2://MYAS400|I|PD7333DNT|JDE|JDE
DEFAULT=jdbc:db2://MYAS400|I|PD7333DNT|JDE|JDE
----------------------------
jas.log
2001-04-24 11:00:34.279 [Pooled ORB request dispatch WorkerThread] LIB : ***** File [/JDEdwardsOneWorld/B7333/jas.log] opened
2001-04-24 11:00:34.313 [Pooled ORB request dispatch WorkerThread] LIB : SysInfo: OS/400 V4R5M0 PowerPC JavaInfo: IBM Corporation 1.2
2001-04-24 11:00:36.151 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup initiated
2001-04-24 11:00:38.138 [Pooled ORB request dispatch WorkerThread] JAS : JDBC Driver <com.ibm.db2.jdbc.app.DB2Driver> is registered. Major Version <4> Minor Version <0>
2001-04-24 11:00:41.984 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup complete
2001-04-24 11:02:30.867 [Worker#23] JAS : trying DriverManager.getConnection/new OWConnection to Datasource : OMDATP: PD7333, OMSRVR: MHSAS400, OMDATB: System - B7333, OMOOWN: null, OMLL: null, OMLIB: SYS7333, OMOMUI: null, OMOMTO: Y, OMOMDS: Y, OMOMJD: Y, OMOMCC: null, OMDSTP: I, OMOCMB: null, dbUser: null
java.sql.SQLException: No suitable driver
java/lang/Throwable.<init>(Ljava/lang/StringV+4 (Throwable.java:94)
----------------------------
Anyone running this configuration and seen this or have gotten it to work? tia, Grant.