-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------

> Raimee Stevens wrote:
> Hello all,
> 
> Platform:
> --------
> NT 4.0 SP 4
> Apache 1.3.6 JServ 1.05b ()
> DB2 UDB v.6.1 Personal
> 
> ERROR DriverManager.setLogStream(*snip_below):
> =====
> *java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path
> 

I have gotton things to work.  The solution to the above was to provide
JServ with wrapper.path=java.library.path=h:\sqllib\bin in
jserv.properties.

I tried many other things.  The 'Unsatisfied link error' was only the
start of my problems.
At this point I am starting JServ manualy and I am also using DB2's
'net' JDBC Driver.  
>From what I understand, the 'app' Driver is the preferred choice.  As
for starting JServ
in manual mode, I can't say yet if that is necessary.  I have read that
Apache doesn't pass
JServ the current DB2 environment settings.  Such as DB2PATH, etc... 
Obviously I have some
way to go yet!

I found the following very helpful for monitoring Driver status:

FileOutputStream fout = new
FileOutputStream("E:\\ApacheJServ\\logs\\drvmgr.txt");
PrintStream pout = new PrintStream(fout);
DriverManager.setLogStream(pout);

You can also use the Event Monitor and Performance Monitor of DB2 to
monitor your servlet
activity.

This SQLException catch phrase might help get you on the right path.

catch (SQLException e) {
        int sqlCode = e.getErrorCode(); // Get SQLCODE
        String sqlState = e.getSQLState(); // Get SQLSTATE
        
        out.println("sqlCode <In DoGetMethod>: " + sqlCode);
        out.println("sqlState <In DoGet Method> : " + sqlState);
}

Also, thank you everyone for your help.  Perhaps I should get things in
order and post
a complete solution to the FAQ-O-MATIC.

Cheers


--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]

Reply via email to