-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
Hmm, I got a private msg not marked with Cc to the list, so I responded in
private. Here is my response for those following this, now that I see that
the list got the same msg ...
I guess procmail got confused by the different Message-IDs or something,
or did you send it twice? Does the list processing sw change the
Message-ID? Nah, that would be stupid, wouldn't it?
---------- Forwarded message ----------
Date: Sat, 4 Sep 1999 22:05:05 +0200 (CEST)
From: Urban Widmark <[EMAIL PROTECTED]>
To: Raimee Stevens <[EMAIL PROTECTED]>
Subject: Re: DB2 Connection Problem
On Sat, 4 Sep 1999, Raimee Stevens wrote:
> > The dll has to be in whatever search path NT uses for dlls (the PATH
> > variable? I think the db2 installation sets that).
> Not which path NT uses, but which path the vm uses. The DriverManager
The vm process tells NT to load the dll for it, right? So where does NT go
looking for that dll? (and I think it uses the PATH variable of the
calling process).
> setting wrapper.path=java.library.path=h:\sqllib\bin in my
> jserv.properties has the following effect:
>
> //DriverManager.setLogStream(outFile) output
>
> DriverManager.initialize: jdbc.drivers = null
> JDBC DriverManager initialized
> registerDriver:
>
>driver[className=COM.ibm.db2.jdbc.app.DB2Driver,COM.ibm.db2.jdbc.app.DB2Driver@e39d4957]
> registerDriver:
>
>driver[className=COM.ibm.db2.jdbc.net.DB2Driver,COM.ibm.db2.jdbc.net.DB2Driver@3d54957]
> DriverManager.getConnection("jdbc:db2://elderlyone:6790/DBTTR")
> trying
>
>driver[className=COM.ibm.db2.jdbc.app.DB2Driver,COM.ibm.db2.jdbc.app.DB2Driver@e39d4957]
> trying
>
>driver[className=COM.ibm.db2.jdbc.net.DB2Driver,COM.ibm.db2.jdbc.net.DB2Driver@3d54957]
> Server elderlyone port 6790 source DBTTR
> getConnection returning
>
>driver[className=COM.ibm.db2.jdbc.net.DB2Driver,COM.ibm.db2.jdbc.net.DB2Driver@3d54957]
>
> //Notice that both ...jdbc.net and ...jdbc.app drivers are tried. This
> is documented in an IBM Quick Book as
> //required for trusted applets. The connection to the app driver
> _alone_ fails for some reason but waorks when
> //drivers both are registered.
Eh, required? I assume that a trusted applet could use the app driver, but
if the app driver requires the net driver then IBM has a very funny design
(the whole point of the app driver, as I see it, is to avoid going through
the "applet server"). A trusted applet could use either (or both, if
connecting twice), but required sounds wrong.
The app driver does require that the client machine (the one the applet &
webbbrowser is running on) has a working, native db2 client setup (eg has
installed the client application enabler or is the same as the server).
As I read the above it does not connect using the app driver, it connects
using the net driver. Try without the app driver, that should work too.
The driver used is controlled by the url used in the getConnection call.
If you use an url like this you will always use the net driver:
jdbc:db2://elderlyone:6790/DBTTR
an app url looks like this:
jdbc:db2:DBTTR
I'm confused by your talk about trusted applets, I thought it was the
servlet that couldn't connect to the database.
> This is a step forward, but actually things don't work yet. I am
> working on trace outputa from DB2 to isolate
> the problem. It looks as though I am making a connection, but I still
> don't get any output to my ResultSet.
> The trace files are a little cryptic.
>
> mod_jserv.log:
> ajp11: Servlet Error: GET is not supported by this URL
>
> now what does this mean?
What url have you used? The jserv process listens to some port (8007), if
you connect with your browser to http://machine.net:8007/... you will get
this error message. You contact the servlet by going through the normal
webserver, http://machine.net/name-of-the-servlet-mount-point/FooServlet
The setup is something like this (using :xxx to denote port numbers)
browser --> :80 apache/mod_jserv --> :8007 JServ java process
ajp11 is the protocol between mod_jserv and the java process.
/Urban
--
--------------------------------------------------------------
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]
