Hi, No matter is Linux or Window, JNDi should be same. You can use the way I wrote for your first reply. It works fine with 5.5.x both at Linux/Unix/Windows.
Good luck On 9/27/06, David Smith <[EMAIL PROTECTED]> wrote:
On JNDI connection problems: We'll need to see more. Specifically the jsp code calling for the sql connection and the web.xml. A full stack trace of the error you get would be excellent as well. Lastly, confirm the mysql jdbc driver is in common/lib of the tomcat directory, not WEB-INF/lib of your webapp. On configuring in server.xml, this is fast becoming a file that should be left alone for all but general server configuration. JNDI resources should be defined either in your [webapp_name].xml file in conf/Catalina/localhost or a context.xml file placed in the META-INF directory of a .war file unless you really want the resource available to all web applications in tomcat. On the admin webapp problems: I don't use it, so I can't help. Maybe someone else could comment? --David prakash shanmugam wrote: > 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] >> >> > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- When we invent time, we invent death.