You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-dev@axis.apache.org by Maurizio Marra <mm...@citiwestinc.com> on 2008/01/23 16:54:28 UTC
DBCP in Axis2
Hi,
I'm trying to set up a connection pooling for axis2 1.3 running as a web
application in Tomcat 6.0 service.
I've added a <resource-ref> element to axis2/WEB-INF/web.xml
I've put a context.xml in axis2/META-INF/context.xml
I've have a suitable driver in Tomcat 6.0\lib
Calling my web service I get this error: Cannot create JDBC driver of class
'' for connect URL 'null'
So it seems that the context.xml is not being loaded.
I've already setup successfully connection pooling in other web applications
using the same steps above.
I'm looking for an advice or some docs.
Thanks in advance
RE: DBCP in Axis2
Posted by Maurizio Marra <mm...@citiwestinc.com>.
Here is my context.xml
<Context path="/axis2">
<Resource name="jdbc/testDB"
auth="Container" type="javax.sql.DataSource"
maxActive="100"
maxIdle="30" maxWait="10000"
username="user"
password="pwd"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test?autoReconnect=true"
validationQuery="select 1"/>
</Context>
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 2:10 PM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Can you post the context.xml file?
Azeez
On Jan 23, 2008 10:02 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi azeez,
Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
I think that the context.xml file is not loaded and I don't know why.
Do you know some articles or docs?
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 11:20 AM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Did you try putting it in the web.xml file? We have successfully done this.
See the end of
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
HTH
Azeez
On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi,
I'm trying to set up a connection pooling for axis2 1.3 running as a web
application in Tomcat 6.0 service.
I've added a <resource-ref> element to axis2/WEB-INF/web.xml
I've put a context.xml in axis2/META-INF/context.xml
I've have a suitable driver in Tomcat 6.0\lib
Calling my web service I get this error: Cannot create JDBC driver of class
'' for connect URL 'null'
So it seems that the context.xml is not being loaded.
I've already setup successfully connection pooling in other web applications
using the same steps above.
I'm looking for an advice or some docs.
Thanks in advance
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
Re: DBCP in Axis2
Posted by Afkham Azeez <af...@gmail.com>.
Can you post the context.xml file?
Azeez
On Jan 23, 2008 10:02 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
> Hi azeez,
>
> Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
>
> I think that the context.xml file is not loaded and I don't know why.
>
>
>
> Do you know some articles or docs?
>
>
> ------------------------------
>
> *From:* Afkham Azeez [mailto:afkham@gmail.com]
> *Sent:* Wednesday, January 23, 2008 11:20 AM
> *To:* axis-dev@ws.apache.org
> *Subject:* Re: DBCP in Axis2
>
>
>
> Did you try putting it in the web.xml file? We have successfully done
> this. See the end of
> https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
>
> HTH
> Azeez
>
> On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
>
> Hi,
>
>
>
> I'm trying to set up a connection pooling for axis2 1.3 running as a web
> application in Tomcat 6.0 service.
>
>
>
> I've added a <resource-ref> element to axis2/WEB-INF/web.xml
>
> I've put a context.xml in axis2/META-INF/context.xml
>
> I've have a suitable driver in Tomcat 6.0\lib
>
>
>
> Calling my web service I get this error: Cannot create JDBC driver of
> class '' for connect URL 'null'
>
>
>
> So it seems that the context.xml is not being loaded.
>
>
>
> I've already setup successfully connection pooling in other web
> applications using the same steps above.
>
>
>
> I'm looking for an advice or some docs.
>
>
>
> Thanks in advance
>
>
>
>
> --
> Thanks
> Afkham Azeez
>
> http://www.wso2.org
> GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
>
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
RE: DBCP in Axis2
Posted by Maurizio Marra <mm...@citiwestinc.com>.
I've put a Context entry in the server.xml and it works.
Thank you very much.
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 2:03 PM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Try adding a corresponding entry to the Tomcat's server.xml file.
See
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/lib/appservers/tomc
at/6.x/server.xml. Search for <Context path="/wso2wsas"> in that file. In
WSAS, what we've done is include the resource-ref entry in the web.xml file
as well as adding the following entry to Tomcat's server.xml file:
<Context path="/wso2wsas">
<Resource name="jdbc/wso2wsas_db"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="wso2wsas"
password="wso2wsas"
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:../database/WSO2WSAS_DB"/>
</Context>
--
Azeez
On Jan 23, 2008 10:02 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi azeez,
Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
I think that the context.xml file is not loaded and I don't know why.
Do you know some articles or docs?
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 11:20 AM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Did you try putting it in the web.xml file? We have successfully done this.
See the end of
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
HTH
Azeez
On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi,
I'm trying to set up a connection pooling for axis2 1.3 running as a web
application in Tomcat 6.0 service.
I've added a <resource-ref> element to axis2/WEB-INF/web.xml
I've put a context.xml in axis2/META-INF/context.xml
I've have a suitable driver in Tomcat 6.0\lib
Calling my web service I get this error: Cannot create JDBC driver of class
'' for connect URL 'null'
So it seems that the context.xml is not being loaded.
I've already setup successfully connection pooling in other web applications
using the same steps above.
I'm looking for an advice or some docs.
Thanks in advance
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
RE: DBCP in Axis2
Posted by Maurizio Marra <mm...@citiwestinc.com>.
Hi Afkham
Thanks a lot for your time and your suggestion.
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 2:03 PM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Try adding a corresponding entry to the Tomcat's server.xml file.
See
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/lib/appservers/tomc
at/6.x/server.xml. Search for <Context path="/wso2wsas"> in that file. In
WSAS, what we've done is include the resource-ref entry in the web.xml file
as well as adding the following entry to Tomcat's server.xml file:
<Context path="/wso2wsas">
<Resource name="jdbc/wso2wsas_db"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="wso2wsas"
password="wso2wsas"
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:../database/WSO2WSAS_DB"/>
</Context>
--
Azeez
On Jan 23, 2008 10:02 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi azeez,
Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
I think that the context.xml file is not loaded and I don't know why.
Do you know some articles or docs?
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 11:20 AM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Did you try putting it in the web.xml file? We have successfully done this.
See the end of
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
HTH
Azeez
On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi,
I'm trying to set up a connection pooling for axis2 1.3 running as a web
application in Tomcat 6.0 service.
I've added a <resource-ref> element to axis2/WEB-INF/web.xml
I've put a context.xml in axis2/META-INF/context.xml
I've have a suitable driver in Tomcat 6.0\lib
Calling my web service I get this error: Cannot create JDBC driver of class
'' for connect URL 'null'
So it seems that the context.xml is not being loaded.
I've already setup successfully connection pooling in other web applications
using the same steps above.
I'm looking for an advice or some docs.
Thanks in advance
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
Re: DBCP in Axis2
Posted by Afkham Azeez <af...@gmail.com>.
Try adding a corresponding entry to the Tomcat's server.xml file.
See
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/lib/appservers/tomcat/6.x/server.xml.
Search for <Context path="/wso2wsas"> in that file. In WSAS, what we've done
is include the resource-ref entry in the web.xml file as well as adding the
following entry to Tomcat's server.xml file:
<Context path="/wso2wsas">
<Resource name="jdbc/wso2wsas_db"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="wso2wsas"
password="wso2wsas"
driverClassName="
org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:../database/WSO2WSAS_DB"/>
</Context>
--
Azeez
On Jan 23, 2008 10:02 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
> Hi azeez,
>
> Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
>
> I think that the context.xml file is not loaded and I don't know why.
>
>
>
> Do you know some articles or docs?
>
>
> ------------------------------
>
> *From:* Afkham Azeez [mailto:afkham@gmail.com]
> *Sent:* Wednesday, January 23, 2008 11:20 AM
> *To:* axis-dev@ws.apache.org
> *Subject:* Re: DBCP in Axis2
>
>
>
> Did you try putting it in the web.xml file? We have successfully done
> this. See the end of
> https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
>
> HTH
> Azeez
>
> On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
>
> Hi,
>
>
>
> I'm trying to set up a connection pooling for axis2 1.3 running as a web
> application in Tomcat 6.0 service.
>
>
>
> I've added a <resource-ref> element to axis2/WEB-INF/web.xml
>
> I've put a context.xml in axis2/META-INF/context.xml
>
> I've have a suitable driver in Tomcat 6.0\lib
>
>
>
> Calling my web service I get this error: Cannot create JDBC driver of
> class '' for connect URL 'null'
>
>
>
> So it seems that the context.xml is not being loaded.
>
>
>
> I've already setup successfully connection pooling in other web
> applications using the same steps above.
>
>
>
> I'm looking for an advice or some docs.
>
>
>
> Thanks in advance
>
>
>
>
> --
> Thanks
> Afkham Azeez
>
> http://www.wso2.org
> GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
>
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
RE: DBCP in Axis2
Posted by Maurizio Marra <mm...@citiwestinc.com>.
Hi azeez,
Yes I've already put the <resource-ref> element to axis2/WEB-INF/web.xml.
I think that the context.xml file is not loaded and I don't know why.
Do you know some articles or docs?
_____
From: Afkham Azeez [mailto:afkham@gmail.com]
Sent: Wednesday, January 23, 2008 11:20 AM
To: axis-dev@ws.apache.org
Subject: Re: DBCP in Axis2
Did you try putting it in the web.xml file? We have successfully done this.
See the end of
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
HTH
Azeez
On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
Hi,
I'm trying to set up a connection pooling for axis2 1.3 running as a web
application in Tomcat 6.0 service.
I've added a <resource-ref> element to axis2/WEB-INF/web.xml
I've put a context.xml in axis2/META-INF/context.xml
I've have a suitable driver in Tomcat 6.0\lib
Calling my web service I get this error: Cannot create JDBC driver of class
'' for connect URL 'null'
So it seems that the context.xml is not being loaded.
I've already setup successfully connection pooling in other web applications
using the same steps above.
I'm looking for an advice or some docs.
Thanks in advance
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760
Re: DBCP in Axis2
Posted by Afkham Azeez <af...@gmail.com>.
Did you try putting it in the web.xml file? We have successfully done this.
See the end of
https://wso2.org/repos/wso2/trunk/wsas/java/modules/core/conf/web.xml
HTH
Azeez
On Jan 23, 2008 9:24 PM, Maurizio Marra <mm...@citiwestinc.com> wrote:
> Hi,
>
>
>
> I'm trying to set up a connection pooling for axis2 1.3 running as a web
> application in Tomcat 6.0 service.
>
>
>
> I've added a <resource-ref> element to axis2/WEB-INF/web.xml
>
> I've put a context.xml in axis2/META-INF/context.xml
>
> I've have a suitable driver in Tomcat 6.0\lib
>
>
>
> Calling my web service I get this error: Cannot create JDBC driver of
> class '' for connect URL 'null'
>
>
>
> So it seems that the context.xml is not being loaded.
>
>
>
> I've already setup successfully connection pooling in other web
> applications using the same steps above.
>
>
>
> I'm looking for an advice or some docs.
>
>
>
> Thanks in advance
>
--
Thanks
Afkham Azeez
http://www.wso2.org
GPG Fingerprint: 643F C2AF EB78 F886 40C9 B2A2 4AE2 C887 665E 0760