Re: switching from toolbox to native DB2 JDBC drivers

You know, I had another problem report show up a couple weeks ago that was
just like this.  T.java is a part of the trace functionality in the Native
JDBC driver.  (It has to be found whether or not you are going to be using
tracing).

In that case, we suggested that they make sure they had the latest PTFs and
the problem went away.  It is almost like something got built wrong, but we
put every JDBC PTF we build through about 6000 testcases that test every
function for regression problems and we never saw any problems along the
way (certainly no problems with code not being found at startup).

I would suggest you put one of our latest PTF on the system.
(5769JV1-SF60735) is a good choice.  But please do one thing for me first.
Please provide me with a list of the PTFs you currently have on the system
for the JV1 product so that I can dig into this a little further.  You need
to get that list before putting the latest on so that superceeded PTFs will
not be in the list.  You can send that to me directly.  If I learn
something specific, I will pass it along to the group.

I hope this helps to resolve your issue.  Please stay in touch with me
(again, you can e-mail me directly) so that we know that we get this
resolved.


Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




"Luther Ananda Miller" <luther.miller@HYPERE.COM> on 01/28/2000 05:10:18 AM

Please respond to JAVA400-L@midrange.com

To:   "L-JAVA400@midrange.com" <JAVA400-L@midrange.com>
cc:
Subject:  switching from toolbox to native DB2 JDBC drivers




I am attempting to switch a server app (servlet running under websphere
2.02) on our AS/400 (JDK 1.1.7) over from using the toolbox JDBC drivers to
the native DB2 drivers.

The connection manager is unable to open a connection.

If I use the Toolbox instead of the DB2 native drivers, then I do not get
any of these problems.
I tried adding /QIBM/ProdData/Java400/jdk117/db2_classes.jar to my class
path in the bootstrap props but that did not seem to make a difference (I
think they already in the system classpath which is set to be used).

If anyone knows what I am doing wrong, or how to correct this, please let
me
know! Thanks!

TIA,
Luther

PS: Exception details from the logs:


The servletservice error_log has the following Exception (this occurs when
the connection manager is asked to provide a connection):

[28 January 2000 20:04:56] Exception raised in servlet invoker.
[28 January 2000 20:04:56] START EXCEPTION BLOCK
[28 January 2000 20:04:56] com.ibm.servlet.engine.SEInvokerException:
java.lang.UnsatisfiedLinkError
      com/ibm/db2/jdbc/app/T.initTrace()V+189 (T.java:103)
      com/ibm/db2/jdbc/app/DB2Driver.<clinit>()V+36 (DB2Driver.java:147)

com/ibm/servlet/connmgr/IBMJdbcConnPool.addConnection(Lcom/ibm/servlet/connm

gr/IBMConnSpec;)Lcom/ibm/servlet/connmgr/IBMConnection;+11
(IBMJdbcConnPool.java:136)

com/ibm/servlet/connmgr/IBMConnPool.getConnectionFromPool(Lcom/ibm/servlet/c

onnmgr/IBMConnSpec;Ljava/lang/String;)Lcom/ibm/servlet/connmgr/IBMConnection

;+169 (IBMConnPool.java:452)

com/ibm/servlet/connmgr/IBMConnMgr.getIBMConnection(Lcom/ibm/servlet/connmgr

/IBMConnSpec;Ljava/lang/String;)Lcom/ibm/servlet/connmgr/IBMConnection;+33
(IBMConnMgr.java:398)

com/ibm/servlet/connmgr/IBMConnMgr.getIBMConnection(Lcom/ibm/servlet/connmgr

/IBMConnSpec;)Lcom/ibm/servlet/connmgr/IBMConnection;+1
(IBMConnMgr.java:367)

com/hypere/ebiz/server/RequestServerHttpServlet.processRequests(Ljavax/servl

et/http/HttpSession;[Lcom/hypere/ebiz/edata/Request;)[Lcom/hypere/ebiz/edata

/Response;+57 (RequestServerHttpServlet.java:450)

com/hypere/ebiz/server/RequestServerHttpServlet.doPost(Ljavax/servlet/http/H

ttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+133
(RequestServerHttpServlet.java:125)

javax/servlet/http/HttpServlet.service(Ljavax/servlet/http/HttpServletReques

t;Ljavax/servlet/http/HttpServletResponse;)V+142 (HttpServlet.java:521)

javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/

servlet/ServletResponse;)V+25 (HttpServlet.java:588)

com/sun/server/ServletState.callService(Ljavax/servlet/ServletRequest;Ljavax

/servlet/ServletResponse;)V+50 (ServletState.java:316)

com/sun/server/ServletManager.callServletService(Ljava/lang/String;Ljavax/se

rvlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+81
(ServletManager.java:1323)

com/ibm/servlet/engine/SEServletManager.callServletService(Ljava/lang/String

;Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+12
(SEServletManager.java:133)

com/sun/server/http/InvokerServlet.service(Ljavax/servlet/http/HttpServletRe

quest;Ljavax/servlet/http/HttpServletResponse;)V+131
(InvokerServlet.java:104)

javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/

servlet/ServletResponse;)V+25 (HttpServlet.java:588)

com/sun/server/ServletState.callService(Ljavax/servlet/ServletRequest;Ljavax

/servlet/ServletResponse;)V+50 (ServletState.java:316)

com/sun/server/ServletManager.callServletService(Ljava/lang/String;Ljavax/se

rvlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+81
(ServletManager.java:1323)

com/ibm/servlet/engine/SEServletManager.callServletService(Ljava/lang/String

;Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+12
(SEServletManager.java:133)
      com/sun/server/ProcessingState.invokeTargetServlet()V+106
(ProcessingState.java:434)

com/sun/server/http/HttpProcessingState.execute(Lcom/sun/server/ProcessingSt

age;)V+29 (HttpProcessingState.java:93)

com/sun/server/ProcessingSupport.process(Lcom/sun/server/ProcessingState;Lja

vax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)Z+73
(ProcessingSupport.java:260)

com/sun/server/Service.process(Lcom/sun/server/ProcessingState;Ljavax/servle

t/ServletRequest;Ljavax/servlet/ServletResponse;)Z+11 (Service.java:229)

com/ibm/servlet/engine/SELauncher.processMultiThreaded(Lcom/ibm/servlet/engi

ne/SEService;Lcom/ibm/servlet/engine/SEConnectionHandler;)Z+13
(SEEngine.java:563)

com/ibm/servlet/engine/SEEngine.service(Lcom/ibm/servlet/engine/api/IAppServ

erConnection;)V+117 (SEEngine.java:312)

com/ibm/servlet/engine/api/ServerEntry.service(Lcom/ibm/servlet/engine/api/I

ServerRequestConnection;)I+89 (ServerEntry.java:201)

com/ibm/servlet/engine/nativeEntry/NativeServerEntry.service(JJILjava/lang/S

tring;Ljava/lang/String;)I+48 (NativeServerEntry.java:144)



The jvm_stderr.log is filled with the following exceptions (this exception
appears to occur when the servlet is intitialized, thus initializing the
connection manager):

java.lang.ClassNotFoundException:
com.ibm.security12.sun.security.provider.IdentityDatabase
      java/security/IdentityScope.initializeSystemScope()V+11
(IdentityScope.java:65)

java/security/IdentityScope.getSystemScope()Ljava/security/IdentityScope;+6
(IdentityScope.java:115)
      sun/tools/jar/JarVerifierStream.<init>(Ljava/io/InputStream;)V+80
(JarVerifierStream.java:88)

com/ibm/servlet/classloader/JarFileClassProvider.hasResource(Ljava/lang/Stri

ng;)Z+43 (JarFileClassProvider.java:88)

com/ibm/servlet/classloader/JarDirClassProvider.hasResource(Ljava/lang/Strin

g;)Z+7 (JarDirClassProvider.java:104)

com/ibm/servlet/classloader/DynamicClassLoader.getNonSystemResourceAsStream(

Ljava/lang/String;)Ljava/io/InputStream;+26 (DynamicClassLoader.java:60)

com/ibm/servlet/classloader/ClassLoaderTemplate.getResourceAsStream(Ljava/la

ng/String;)Ljava/io/InputStream;+9 (ClassLoaderTemplate.java:68)

com/ibm/servlet/classloader/PowerClassLoader.getNonSystemResourceAsStream(Lj

ava/lang/String;)Ljava/io/InputStream;+4 (PowerClassLoader.java:59)

com/ibm/servlet/classloader/ClassLoaderTemplate.getResourceAsStream(Ljava/la

ng/String;)Ljava/io/InputStream;+9 (ClassLoaderTemplate.java:68)

com/ibm/servlet/engine/SEServletManager.loadServlet(Ljava/lang/String;)V+32
(SEServletManager.java:163)
      com/sun/server/ServletManager.loadStartupServlets()V+73
(ServletManager.java:490)
      com/sun/server/http/HttpService.run()V+181 (HttpService.java:195)
      java/lang/Thread.run()V+11 (Thread.java:466)

luther.miller @ hypere.com


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---