CCJava
|
Posted: 06/21/2004, 3:09 PM |
|
Hi,
Getting cannot connect to database(oracle)------>
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to create connection 'Connection1' to the database.
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:346)
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:810)
root cause
java.lang.RuntimeException: Unable to create connection 'Connection1' to the database.
com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:19)
com.codecharge.db.JDBCConnection.<init>(JDBCConnection.java:63)
com.codecharge.db.PoolJDBCConnection.<init>(PoolJDBCConnection.java:11)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:36)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:27)
com.codecharge.GridProcessor.select(GridProcessor.java:73)
com.codecharge.GridProcessor.process(GridProcessor.java:51)
com.codecharge.PageProcessor.process(PageProcessor.java:28)
com.codecharge.PageController.process(PageController.java:149)
org.apache.jsp.CO_005fMASTER_005flist_jsp._jspService(CO_005fMASTER_005flist_jsp.java:162)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
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:810)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.25 logs.
|
|
|
ignat
Posts: 55
|
Posted: 06/22/2004, 2:00 AM |
|
Check these settings:
1. JDBC Driver class name
2. Database URL: host name, port, database name, database parameters
3. Database User name and password
4. Database driver is in server classpath (in common/lib folder for Tomcat)
Regards,
Ignat.
|
|
|
CCJava
|
Posted: 06/22/2004, 12:33 PM |
|
Thanks Ignat.
The test connection at datalink properties while editing connection suceeds. I have copied the Oracle jar files to Tomcat/common/lib folder but still getting the same error message.
The connection is tested through CodeCharge so it means the driver,URL, Port and other details are correct but after publishing the project it fails to connect to database.
CCJava
|
|
|
ignat
Posts: 55
|
Posted: 06/22/2004, 11:55 PM |
|
CodeCharge Studio doesn't test the server-side connections. It only can test your design-time connections. So you should test the connection settings yourself very carefully.
Regards,
Ignat.
|
|
|
|