problem in connection pooling.

[toukhir mujawar]

Friends,

I am facing a problem while connection pooling.

The contents f web.cml file 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>  

the contents of server.xml file are

  <Server port="8005" shutdown="SHUTDOWN">     <Listener className="org.apache.catalina.core.AprLifecycleListener" />  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" />  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />  <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>   <GlobalNamingResources>     <Environment name="simpleValue" type="java.lang.Integer" value="30"/>   </GlobalNamingResources>    <Service name="Catalina">   <Connector port="8000"               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"               enableLookups="false" redirectPort="8443" acceptCount="100"               connectionTimeout="20000" disableUploadTimeout="true" /> <Connector port="8009"               enableLookups="false" redirectPort="8443" protocol="AJP/1.3" />  <Engine name="Catalina" defaultHost="localhost">  <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"              driverName="oracle.jdbc.driver.OracleDriver"             connectionURL="jdbc:oracle: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"/> <Host name="localhost" appBase="webapps"        unpackWARs="true" autoDeploy="true"        xmlValidation="false" xmlNamespaceAware="false">   <context docBase=dailycollection  path=/dailycollection debug="0" reloadable="true"> <Resource name="jdbc/WroxTC5"         type="javax.sql.DataSource"         driverClassName="oracle.jdbc.driver.OracleDriver"         url="jdbc:oracle:thin:@192.168.1.101:1521:cmsdb"         factory="org.apache.commons.dbcp.BasicDataSourceFactory"         username="dcol"         password="dcolmsedcl"         maxIdle="2" maxWait="5000"                 maxActive="20"/>   </context> </Host>     </Engine>   </Service> </Server>   

The connection is created as below.

  Context initContext = new InitialContext();    Context envContext  = (Context)initContext.lookup("java:comp/env");    DataSource ds = (DataSource)envContext.lookup("jdbc/WroxTC5");    conn = ds.getConnection();    

when the jsp is trying to create the connection i am getting the following exception.



exception

org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370)
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

java.lang.NullPointerException
org.apache.jsp.DisplayZoneWiseCollection_jsp._jspService(org.apache.jsp.DisplayZoneWiseCollection_jsp:52)
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)


I am not able to resolve the problem. kindly help me.

I am using form based authentication.


Thanks in advance


Regards
Toukhir Mujawar

[Bear Bibeault]

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.