Connection pooling problem

[Deepthi Mudidani]

Hi Iam using tomcat 5.5.7 and oracle 9i and struts 1.2.8.
I have configured a connection pool jdbc/myoracle in server.xml and web.xml.
When i try to access the jsp which calls UserRegAction it throws this exception.

javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 

contents of server.xml includes..

<Context path="/struts-sample2" reloadable="true" docBase="C:\struts-sample2" workDir="C:\struts-sample2\work" crossContext="true">
     <Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource"/>
 
  <ResourceParams name="jdbc/myoracle">
    <parameter>
      <name>factory</name>      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
 
    <!-- Class name for the ojdbc14 driver-->
    <parameter>
       <name>driverClassName</name>
       <value>oracle.jdbc.OracleDriver</value>
    </parameter>
 
    <!-- jdbc url to connect to oracle -->
    <parameter>
      <name>url</name>
      <value>jdbc :-o	 racle:thin:@hostname:1521 :-o	 racle</value>
    </parameter>
 
    <!-- oracle dB username and password for dB connections  -->
    <parameter>
     <name>username</name>
     <value>scott</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>tiger</value>
    </parameter>
 
   <parameter>
      <name>maxActive</name>
      <value>10</value>
    </parameter>
 
     <parameter>
      <name>maxIdle</name>
      <value>5</value>
    </parameter>
 
   <parameter>
     <name>maxWait</name>
      <value>-1</value>
    </parameter>
        
  </ResourceParams>
</Context>
...

in web.xml

<resource-ref>
 <description>Oracle datasource details</description>
 <res-ref-name>jdbc/myoracle</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>
  

and the UserRegAction contains

Context initContext = new InitialContext();
DataSource ds = (DataSource)initContext.lookup("java:comp/env/jdbc/myoracle");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
try{
 int i = stmt.executeUpdate("INSERT INTO UserInfoTable(" +userRegForm.getUserId() + "," +userRegForm.getPassword()+")" );
 System.out.println("user created successfully and inserted into DB");
}catch(SQLException e){ }

Iam not sure if this is a struts specific problem or not.
Thanks!!

[amit bhadre]

Hi Deepti

Be confirm on what u r doing...Be confident on ur side...then ask questions on corresponding forums...OK



OK I try to solve ur problem....

Well if u r doing in JSP den write one another jsp page and make it as isErrorpage. Then u r getting Servlet exception means is JSP or Server error dont get too knock head cool. Den make page which is throwing error redirect to that new created page.

Try it....

How the gc() come to know that the objects are no longer usable ? There may be case of objects later may be used....then big dragging back of JVM...is int it...? :-)





["If C & C++ are sea and Java is Ocean/Galaxies/ whole Universe"]


cheers
amit bhadre

[Deepthi Mudidani]

Thanks for ur suggestion
The problem is with the configuration element in server.xml
With tomcat 5.5 we should use
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc racle:thin:@localhost:1521 racle"
username="scott" password="tiger" maxActive="4" maxIdle="2"
maxWait="10"/>