HY seems the same error with me :-)))
You must define the Resource beound GlobalName(blah) and connect it in Context with the Application. Search in the Mailarchive to Subject: --- cut --- Access zu an jdbc Datasource --- cut --- Greetings \Robby Antony Paul schrieb: > 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]
