Yes, sorry, I was using dummy values and forgot that. Thank you for pointing that out. But my main problem seems to be with the XML parsing of the config file, regardless of the values I use, since the Tomcat error on the console is
org.xml.sax.SAXParseException: Element "resource-ref" does not allow "resource-ref-name" here. I'm surprised nobody else got this following the JNDI howto. Soefara. >From: [EMAIL PROTECTED] >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: jndi versus database connection pooling >Date: Thu, 14 Mar 2002 11:03:07 -0500 > > >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/mydb" 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. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
