Hi,
Looks like you are using the Tomcat Connection pool.
Refer to the attached file and verify that you have done these steps.
I think it should solve your problem.
-----Original Message-----
From: deepak suldhal [mailto:[EMAIL PROTECTED]
Sent: Monday, February 21, 2005 11:43 AM
To: tomcat users
Subject: JDBC connection errors
Hi
I am getting the following errors while trying to make a JDBC connection.
Please help.
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI
mpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:758)
org.apache.jsp.test_jsp._jspService(test_jsp.java:82)
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:3
24)
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)
root cause
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unk
nown Source)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknow
n Source)
org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:101)
org.apache.jsp.test_jsp._jspService(test_jsp.java:58)
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:3
24)
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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
http://www.patni.com
World-Wide Partnerships. World-Class Solutions.
_____________________________________________________________________
This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at [EMAIL PROTECTED] and delete this mail.
_____________________________________________________________________
Settings for Tomcat Connection Pool
***************************************
1) Put classes12.jar file in path => CATALINA_HOME\common\lib
2) Add the Tag given below into server.xml file
<DefaultContext>
<Resource name="jdbc/myOracle" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myOracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:[EMAIL PROTECTED]:1521:PKGSFT</value>
</parameter>
<parameter>
<name>username</name>
<value>pswtoshiba</value>
</parameter>
<parameter>
<name>password</name>
<value>pswtoshiba</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>30000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</DefaultContext>
3) Change the values of url, username, password as per the environment setup at
Toshiba side.
4) Significance of following tags:
maxActive : Maximum number of dB connections in pool. Make sure the
max_connections of DB are large enough to handle
this limit. Set to 0 for no limit.
maxIdle : Maximum number of idle dB connections to retain in pool. Set to 0 for
no limit.
maxWait : Maximum time to wait for a dB connection to become available in ms,
in this example 10 seconds. An Exception is thrown if this timeout is exceeded.
Set to -1 to wait indefinitely.
removeAbandoned : Abandoned dB connections are removed and recycled based on
this paramater to the ResourceParams configuration for the DBCP DataSource
Resource.
removeAbandonedTimeout : Sets the number of seconds a dB connection is left
idle before it is considered abandoned.
logAbandoned : The logAbandoned parameter can be set to true if you want DBCP
to log a stack trace of the code which abandoned the dB connection resources.
5) Add the following tag in web.xml to ensure default session timeout.
<session-config>
<session-timeout>5</session-timeout>
</session-config>
Value specified is the minutes after which session timeout would occur.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
