http://www.laliluna.de/260.html
ALEX HYDE wrote:
Thanks for the help.
I seem to be able to get it working when I have a context file under my web-app in the meta-inf directory. But I am still unable to properly configure a global datasource. Here is my context.xml..... very standard:
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/testdb" auth="SERVLET" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/testdb" username="me" password="me" maxActive="30" maxIdle="2000" maxWait="120"/>
</Context>
If I remove this and instead add this to server.xml
<GlobalNamingResources>
<Resource name="jdbc/testdb" auth="SERVLET" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/testdb" username="me" password="me" maxActive="30" maxIdle="2000" maxWait="120"/>
</GlobalNamingResources>
It no longer finds the datasource. My web.xml looks like this:
<web-app version="2.4">
<display-name>JNDI Test</display-name>
<description>
Welcome to JNDI
</description>
<resource-ref>
<description>hello </description>
<res-ref-name>jdbc/testdb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>SERVLET</res-auth>
</resource-ref>
</web-app>
I tried this, but it is failing to parse:
<web-app version="2.4">
<display-name>JNDI Test</display-name>
<description>
Welcome to JNDI
</description>
<resource-env-ref>
<description>hello </description>
<res-env-ref-name>jdbc/testdb</res-env-ref-name>
<res-env-type>javax.sql.DataSource</res-env-type>
</resource-env-ref>
</web-app>
Any input would be great. Thanks alot.
[EMAIL PROTECTED] wrote: Follows is to do:
extract your Resource section from server.xml and copy to context.xml. I did
the same and my jndi works very fine.
György
"Tomcat Users List" schrieb am 07.03.06 22:58:18:
here are the docs
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
I don't see them declare the "factory" attribute in 5.5, you didn't tell
us what version you were on
Filip
ALEX HYDE wrote:
Hi All,
I've seen this one all over the user group but I seem
to have come to a dead end with this. I have upgraded
from tomcat 4 to 5 and I can't seem to get my app
working again.
The part that has broken is the jndi datasource
look-up. I notice that I'm definitly not the first to
experience this problem. Perhaps things might have
been made a bit clearer. I thought I had set things up
correctly. I have extracted my old context from
server.xml and added it under my web app context.
debug="0" reloadable="true"
crossContext="true">
type="javax.sql.DataSource"
maxActive="10" maxIdle="7" maxWait="50000"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:1521/testdb"
username="user1" password="****"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
/>
I now have this error where it had been working in
version 4.
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of cla
ss '' for connect URL 'null'
Thanks for your help.
___________________________________________________________
Win a BlackBerry device from O2 with Yahoo!. Enter now. http://www.yahoo.co.uk/blackberry
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
