Do you have the jtds jar in Tomcat classpath. I think it should in same directory as dbcp.jar which is in CATALINA_HOME\common\lib folder.
Antony Paul ----- Original Message ----- From: "Steve Cheng" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, September 01, 2004 2:15 PM Subject: jndi-datasource > I follow the tomcat document and try to setup JNDI in tomcat. > http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how > to.html > > But I get the following exception. > javax.servlet.ServletException: Cannot create JDBC driver of class '' for > connect URL 'null' > > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI > mpl.java:825) > > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp > l.java:758) > org.apache.jsp.testDB_jsp._jspService(testDB_jsp.java:81) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3 > 24) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > However, If I create the following tag in the Context tag, it works fine. > <ResourceLink global="jdbc/sysdev/workflow" name="jdbc/sysdev/workflow" > type="javax.sql.DataSource"/> > > Anybody know how to solve it? > > Thanks, > steve > > ------------------------------------------------------------ > > Tomcat Version: 5.0.27 > JDBC Driver: jtds > OS: Win2k server > > segment of server.xml > <?xml version='1.0' encoding='utf-8'?> > <Server> > ... > <GlobalNamingResources> > ... > <Resource auth="Container" description="Workflow DB Connection" > name="jdbc/sysdev/workflow" type="javax.sql.DataSource"/> > <ResourceParams name="UserDatabase"> > <parameter> > <name>factory</name> > <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> > </parameter> > <parameter> > <name>pathname</name> > <value>conf/tomcat-users.xml</value> > </parameter> > </ResourceParams> > <ResourceParams name="jdbc/sysdev/workflow"> > <parameter> > <name>validationQuery</name> > <value>select top 1 * from login</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:jtds:sqlserver://sysdev/workflow</value> > </parameter> > <parameter> > <name>password</name> > <value></value> > </parameter> > <parameter> > <name>maxActive</name> > <value>4</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>5000</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>net.sourceforge.jtds.jdbc.Driver</value> > </parameter> > <parameter> > <name>username</name> > <value>sa</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>2</value> > </parameter> > </ResourceParams> > </GlobalNamingResources> > ... > </Server> > > web.xml > <?xml version="1.0" encoding="UTF-8"?> > <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee > http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";> > <display-name>Workflow</display-name> > <description>Workflow</description> > <resource-ref> > <description>Workflow DB Connection</description> > <res-ref-name>jdbc/sysdev/workflow</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > </web-app> > > > > --------------------------------------------------------------------- > 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]
