Sorry about my previous posting. Now, I have got
better trace of my JDBC connection problem.
I am using the Tomcat 5.0.27, j2sdk1.4.2, Oracle 10i,
Windows XP.
The error message is:
==============================================
root cause
org.dhsinfo.content.exceptions.PageDAOSysException:
SQLException: Cannot create JDBC driver of class ''
for connect URL 'null'
org.dhsinfo.content.dao.OraclePageDAO.findPages(OraclePageDAO.java:51)
org.dhsinfo.content.PageService.getPages(PageService.java:18)
org.dhsinfo.content.SelectPage.execute(SelectPage.java:29)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
============================================
When I configured the Tomcat 5.0.27, I did put the
driver and URL in the
C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
location is below the <Logger
className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log."
suffix=".txt" timestamp="true"/> and before the
closing </Host> tag). Please help me to see the
problem:
[code]
<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true"
crossContext="true">
<Logger
className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log."
suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/OracleDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>password</name>
<value>cmis001</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@172.19.47.22:1521:devora2</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>cmis</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
[/code]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
