Forums Register Login

Problem in connection pooling

+Pie Number of slices to send: Send
Hi,

I am trying to implement connection pooling.

When I try to connect to the database get the followeing exception.


exception

javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.Welcome_jsp._jspService(org.apache.jsp.Welcome_jsp:163)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)


root cause

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
org.apache.jsp.Welcome_jsp._jspService(org.apache.jsp.Welcome_jsp:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)




The contents of the server.xml file are


<context docBase=dailycollection path=/dailycollection debug="0" reloadable="true">
<Resource name="jdbc/WroxTC5"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc racle:thin:@192.168.1.101:1521:cmsdb"
username="dcol"
password="dcolmsedcl"
maxIdle="2" maxWait="5000"
maxActive="4"/>

</context>

This tag is written in <host> tag.

The contents of web.xml are

<resource-ref>
<res-ref-name>jdbc/WroxTC5</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Form</res-auth>
</resource-ref>


I am using form based authentication. the realm defined for this is


<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc racle:thin:@192.168.1.101:1521:cmsdb"
connectionName="dcol" connectionPassword="dcolmsedcl"
userTable="users" userNameCol="user_name" userCredCol="user_pass"
userRoleTable="user_roles" roleNameCol="role_name"/>



Kindly help me. Thanks in advance.
+Pie Number of slices to send: Send
The contents of server.xml are corrected as

<context docBase=dailycollection path=/dailycollection debug="0" reloadable="true">
<Resource name="jdbc/WroxTC5"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc racle:thin:@192.168.1.101:1521:cmsdb"
factory = "org.apache.commons.dbcp.BasicDataSourceFactory"
username="dcol"
password="dcolmsedcl"
maxIdle="2" maxWait="5000"
maxActive="4"/>

</context>
+Pie Number of slices to send: Send
I have the following jar file in tomcat/common/lib directory

commons-collections-3.1.jar
commons-dbcp-1.2.1.jar
commons-el.jar
commons-pool-1.2.jar
ojdbc14_g.jar
If I had asked people what they wanted, they would have said faster horses - Ford. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1428 times.
Similar Threads
problem in connection pooling.
problem in connection pooling.
configure SQL Server 2000 DataSource in Tomcat 5.0.28
Problem in connection pooling
SQLNestedException: Cannot create JDBC driver of class ''
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 16:53:17.