hai david, thank for sending those help files.now we are using tomcat 5.0.x. our database is mysql and the Driver is com.sql.jdbc.Driver.
when i am calling the jsp pages in my project its working fine,if i am trying to communicate with database errorpage is thrown. ****************** i had tried to create new *jndi* name through tomcat admin page.but the changes are not reflecting in the usr/j-tomcat5.0/config/server.xml instead linux is creating a new xml file named as server.xml(plus date and time of creation) inthe same directory Even in that xml file also i cont see the jndi name and other changes, which i had done through admin page. i want to know how to configure the jndi name in the server.xml file since i am new to linux with tomcat i cont proceed with things, please guide me in the right direction bye with regards prakash s On 9/26/06, David Smith <[EMAIL PROTECTED]> wrote:
This is well documented on the tomcat site. What you've included below works on tomcat 5.0, but not 5.5. See the online docs: Tomcat 5.5 -- http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html Tomcat 5.0 -- http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html What version of tomcat are you working with? --David prakash shanmugam wrote: > hai Li, > ur gussing is correct, i am using JNDI DS, here by i had pasted the > code > which is appended in the *server.xml. * > > *server.xml* > > <Context className="org.apache.catalina.core.StandardContext" > cachingAllowed="true" charsetMapperClass=" > org.apache.catalina.util.CharsetMapper" cookies="true" > crossContext="false" > debug="0" displayName="Project Tracking System" docBase="opts7" > mapperClass="org.apache.catalina.core.StandardContextMapper" > path="/opts7" > privileged="false" reloadable="true" swallowOutput="false" > useNaming="true" > wrapperClass="org.apache.catalina.core.StandardWrapper"> > > <Resource name="mine" scope="Shareable" > type="javax.sql.DataSource > "/> > <ResourceParams name="mine"> > <parameter> > <name>maxWait</name> > <value>5000</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>200</value> > </parameter> > <parameter> > <name>password</name> > <value></value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:mysql://100.100.100.6:3306/opts</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10</value> > </parameter> > <parameter> > <name>username</name> > <value>dav</value> > </parameter> > </ResourceParams> > </Context> > > > </Host> > > </Engine> > *web.xml* > > <resource-ref> > <description> DB Connection Pooling</description> > <res-ref-name>mine</res-ref-name> > <res-type> javax.sql.DataSource</res-type> > <res-auth> Container</res-auth> > </resource-ref> > > The above pasted code is working fine in windows, but our server in > linux. > we cont able to communicate to the database. please, check where i had > went > wrong... > > bye > with regrds > prakash > > On 9/26/06, Li <[EMAIL PROTECTED]> wrote: > >> >> depends on what pool you use ... >> >> If use JNDI DS, you have to create a resource section in your >> server.xml: >> >> .... >> <engin ...> >> <host ...> >> <context ...> >> <Resource >> name="..." >> auth="Container" >> type="javax.sql.DataSource" >> username="..." >> password="..." >> driverClassName="..." >> url="..." >> maxActive="..." >> maxIdle="..." >> maxWait="..." >> ... /> >> </context> >> </host> >> </engine> >> ... >> >> if you use other data source like hibernate's ... see their manual >> >> good luck >> >> >> On 9/26/06, prakash shanmugam <[EMAIL PROTECTED]> wrote: >> > >> > hai all, >> > >> > can u do one help ... >> > i need details about how to configure Connection Pooling in >> > Tomcat with MySQL in Linux platform... >> > i have done in windows platform..its working well.. >> > i followed the same concepts in linux server also.. >> > but it is not working... can u u hepl me in this regard.. >> > it will be very much helpful for me if u do this.. >> > >> > with regards >> > prakash >> > >> > >> >> >> -- >> When we invent time, we invent death. >> >> > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Thanks and Regards S.Prakash