RE: JDBC datasource from Web Service

[christopher justin]

Thanks alot Richard... you cleared up my confusion.  Regarding the 
application specific WEB-INF/web.xml, what I mean by that is that I was 
assuming each deployed Web Service could have its own web.xml file... but 
this appears not to be the case... This is probably true because Axis itself 
is seen as a webapp and the web services that Axis manages are not seen as 
separate web apps to Tomcat.  In other words, all Web Services in Axis use 
Axis's web.xml (webapps/axis/WEB-INF/web.xml) not their own (i.e. 
webapps/axis/classes/myService/WEB-INF/web.xml) .  This is correct right ?



From: "Richard Martin" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: RE: JDBC datasource from Web Service
Date: Thu, 29 Jan 2004 21:57:15 -0000
Hi Christopher,

Comments inline below:

>I have this working in a function called getDB() within the Web Service 
but

>I don't understand how it recognizes the Context it is in because I do 
not
>have a WEB-INF/web.xml file that would normally define the resource such 
as

You must have a web.xml file to map the AxisServlet to the Servlet
container? It's as simple as adding your xml to that file. For reference, a
simple web.xml file for a project I'm working on is attached. As you can
see, all I've done is added the resource-ref element and children to it.
Once that's done you can lookup the JDBC pool as usual.
>Does Axis know of the application specific WEB-INF/web.xml ?  I have set 
up

>Data Sources correcty when useing the JWS SDK and within that I needed a
>resource identified correctly in my application specific WEB-INF/web.xml 
,
>but Axis seems to not even care about that file.

Axis might not care but the Servlet container does take note of that xml
file, and that's what provides the InitialContext implementation.
One thing of note - DataSources with Axis has given me no end of hassle. It
seems that no matter what I do, how often I call Connection.close() to
return it to the pool, the server runs out of connections and then throws 
an
Exception (db pool could not get idle connection).

Anyone else on the list had similar experiences?

Hope this helps!

Richard
<< web.xml >>
_________________________________________________________________
There are now three new levels of MSN Hotmail Extra Storage!  Learn more. 
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1