This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in connection pooling

 
toukhir mujawar
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
toukhir mujawar
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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>
 
toukhir mujawar
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic