Hi Soefara,
Your <res-ref-name> in web.xml should have same name with <Resource name="
jdbc/creditel" auth="Container" type="javax.sql.DataSource"/> in
server.xml.
Good luck,
"Soefara Redzuan" <[EMAIL PROTECTED]> on 03/14/2002 10:47:51 AM
Please respond to "Tomcat Users List" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Fax to:
Subject: Re: jndi versus database connection pooling
>>"Mark Muffett" <[EMAIL PROTECTED]> on 03/14/2002 04:18:13 AM
>>The coding side seems to be well documented, and there have been
>>several instances posted here, but (as far as I can see) we're all
>>working in the dark with server.xml. I've spent a lot of time trying
>>to get database pooling to work with Postgresql, but I've failed and
>>given up. I'd be interested to know what database/tomcat configurations
>>anyone has got to work - with some sample server.xml fragments if
>>possible.
Thank goodness it's not just me. I was starting to feel very stupid.
>From: [EMAIL PROTECTED]
>Hi, here is an example.
>
>Server.xml
>
><Context path="/creditel" docBase="creditel" debug="0"
> reloadable="true" crossContext="true">
> <Resource name="jdbc/creditel" auth="Container" type
>="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/creditel">
> <parameter><name>driverClassName</name>
> <value>COM.ibm.db2.jdbc.net.DB2Driver</value></parameter>
> <parameter><name>driverName</name>
> <value>jdbc:db2://URL/DATABASENAME</value></parameter>
> <parameter><name>user</name><value>USERNAME</value></parameter>
> <parameter><name>password</name><value>PASSWORD</value></parameter>
> <parameter><name>maxPoolSize</name><value>2</value></parameter>
> <parameter><name>loginTimeout</name><value>10</value></parameter>
>
> </ResourceParams>
></Context>
I did something similar in server.xml and Tomcat has not complained yet.
This is mine for mysql
<Context path="/myapp" docBase="myapp" debug="0" reloadable="true">
<Resource name="jdbc/ibs" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<parameter>
<name>user</name>
<value></value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:mysql://url/databasename</value>
</parameter>
</ResourceParams>
</Context>
>web.xml
>
><resource-ref>
> <res-ref-name>jdbc/creditel</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
></resource-ref>
My web.xml has more in it.
<web-app>
<servlet>
<servlet-name>myServlet</servlet-name>
<servlet-class>myServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>myServlet</servlet-name>
<url-pattern>/myServlet</url-pattern>
</servlet-mapping>
<resource-ref>
<description>
Resource reference to a factory for java.sql.Connection
instances that may be used for talking to a particular
database that is configured in the server.xml file.
</description>
<resource-ref-name>
jdbc/mydb
</resource-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
But when I start Tomcat it gives me this error
Apache Tomcat/4.0
PARSE error at line 29 column -1
org.xml.sax.SAXParseException: Element "resource-ref" does not allow
"resource-ref-name" here.
Which is very strange because I just followed the examples in the JNDI
howto.
Soefara.
_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
