-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
Hold it !! Not sure if you're using the right product, Raimee !!!
As far as I know : DB2 Personal Edition does *not* have support for network
connections -- just named pipes. That was how it was with DB2 v5 through
5.2. Not sure about ver 6.x. I tried to confirm that very thing yesterday
when I went to IBM Towers here, in SIngapore. Unfortunately, nobody could
tell me. They said that they will ship the Personal and Enterprise edition
to me as soon as the CDs arrive in Singapore (which will be in a week or
two). I'll be in a much better position to advise you then ...
Regards,
Pascal Chong
-----Original Message-----
From: Raimee Stevens <[EMAIL PROTECTED]>
To: Java Apache Users <[EMAIL PROTECTED]>
Date: Tuesday, September 07, 1999 10:53 AM
Subject: Re: DB2 Connection Problem
>-----------------------------
>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]
>
--
--------------------------------------------------------------
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]
