-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
On Sat, 4 Sep 1999, Raimee Stevens wrote:
> ---
> getConnection returning
>
>driver[className=COM.ibm.db2.jdbc.net.DB2Driver,COM.ibm.db2.jdbc.net.DB2Driver@3d54957]
> This line suggests that a connection was tried but I can't say that a
> conn. object was created.
> And more importantly, I can't say which driver made the connection.
It is the net driver. You've cut a little too much (and I've cut even more
:), but I'm sure it is the net driver.
> > Eh, required?
>
>
>http://www.software.ibm.com/cgi-bin/db2www/library/document.d2w/report?uid=UNKNOWN&pwd=&search_type=SIMPLE&r_host=&last_page=list.d2w&fn=JMER-3PCRZX
>
> STRANGE!!
Here is what they are talking about, as I understand it. A trusted applet
is a set of classes, signed to detect modification. If the db2 jdbc driver
is not in that set of signed classes they will not be part of the trusted
applet, and will have normal applet restrictions. If you load the driver
explicitly it will become a part of the trusted applet.
This is not relevant to a servlet since a servlet does not run in the
browser. Also they do not mention that you would need both net and app
driver, they simply say that you have to load the net driver explicitly.
> > 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.
> But it is the app driver that I need, right?
What for?
Yes, you may want it. It should give better performance talking directly
to db2. But need it? No. Get it to work with the net driver first, that is
much easier.
> IBM side, and little DB2 talk on the JServ side. So, I constructed my
> url for the wrong driver.
> Now, since rewriting url, my db2trace file is repleat with driver
> connection, Application Init and other
> statements that verify that I am getting a connection. I don't know
> where the ouput is going! BUT COME HELL OR HIGH WATER!!!
What output? No ResultSet in response to your query ... that I don't know.
> I do know that until I explicitley register the net Driver, I can't
> connect. And when I do connect, (evidence in
> the db2 trace output), I'm not even running the db2jstr applet server.
The applet server is a "service", check your control panel. db2jstrt is a
program that starts the applet server, the actual server is called db2jd.
(Actually, I have to point out that I have never seen a v6.1 Personal
Edition on NT "in action", so this may be different from v5. But I do
have the CD on my desk :)
> > > 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
[snip]
> Sorry, I still don't see your point. I use the JServ default
My point was that I thought you were using the wrong url. You claim you
are not, then I don't know.
> config.(ajpll:8007), and connect
> to the servlet as with any other html form based GET request:
> ACTION="http://192.168.1.1/name-of-the-servlet-mount-point/testDB2"
> METHOD=GET
> I perform driver registration in my init() and connections from
> doGet().
Do you connect to db2 in init() ?
Could it be that there is something wrong with your servlet. doGet only
works if you have subclassed HttpServlet, the GenericServlet passes
everything to service() and knows nothing about doGet. But if you connect
to db2 in doGet then that explanation doesn't hold.
/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]
