Hi, I am using Tomcat 5.0.
I have one application "test".
In "test" i created "META-INF" folder and put "context.xml" file.Here is the
content
<context>
<resource name="jdbc/PDBDataSource" scope="Shareable"
type="javax.sql.DataSource">
<resourceparams name="jdbc/PDBDataSource">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter
<name>url</name>
<value>jdbc:sqlserver://localhost;DatabaseName=test;SelectMethod=cursor;</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
</resourceparams>
</resource>
</context>
in WEB-INF\web.xml" file i have the entires
<web-app .... >
<resource-ref>
<res-ref-name>jdbc/PDBDataSource
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
</web-app>
in my jsp code i have the code
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/PDBDataSource");
Connection conn = ds.getConnection();
conn.close();
I am getting the follwoing error when accessing my page
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:69)
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:324)
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)
Help me to resolve this :confused:
--
View this message in context:
http://www.nabble.com/Datasource-configuration-issue-tp25868686p25868686.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
