Websphere 3.5 on AS400

MagarG

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/String;)V+4 (Throwable.java:94)


----------------------------
Anyone running this configuration and seen this or have gotten it to work? tia, Grant.
 
We got the same problem on trying to use the Native Driver for JAS in AS/400.
What we found was the html.logon servlet is trying to load the non-native
driver (com.ibm.as400.,,,) even you configure not to.

AS400 V4R5, XE SP15, JAS SP15, WebSphere 3.5 with SP3

Wilson Chen
Systems Management Inc

Quoting MagarG <[email protected]>:

------------
------------
Cat=0&Board=OW&Number=9726



Wilson H. Chen
Systems Management Inc.
 
Back
Top