costafari
Posts: 1
|
Posted: 11/16/2010, 10:48 PM |
|
I'm trying to connnecting a test Oracle XE 10g database. I selected jsp. I'm using CodeCharge 4.2 and I followed a typical way to create a new proyect: File->New Project.
Then, I constructed my app but when I tried to published, I got this:
type Informe de Excepción
mensaje
descripción El servidor encontró un error interno () que hizo que no pudiera rellenar este requerimiento.
excepción
org.apache.jasper.JasperException: Unable to create connection 'Clinica' to the database.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:498)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
causa raíz
java.lang.RuntimeException: Unable to create connection 'Clinica' to the database.
com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:23)
com.codecharge.db.JDBCConnection.<init>(JDBCConnection.java:85)
com.codecharge.db.PoolJDBCConnection.<init>(PoolJDBCConnection.java:15)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:36)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:27)
com.codecharge.MenuProcessor.select(MenuProcessor.java:65)
com.codecharge.MenuProcessor.process(MenuProcessor.java:38)
com.codecharge.PageProcessor.process(PageProcessor.java:42)
com.codecharge.PageController.process(PageController.java:181)
org.apache.jsp.index_jsp._jspService(index_jsp.java:244)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
nota La traza completa de la causa de este error se encuentra en los archivos de diario de Apache Tomcat/5.5.31.
I know the problem is in Tomcat server. I'm using Tomcat 5.5 and Java 1.5. My datasources is correct (I think this because I followed the How-to in the Apache Tomcat 5.5 page) but I can't find what is the mistake.
Please, I need a "ray a light" to solve this problem. I have a lot of time with this problem and I feel crazy!!!
|
|
|
mansb2002
Posts: 1
|
Posted: 01/12/2011, 6:10 PM |
|
I had a similar problem. I tried these things and it worked:
1) make sure to have these files in the "ClassPath" setting
c:\apache-tomcat-6.0.29\lib\servlet-api.jar
c:\apache-tomcat-6.0.29\lib\jsp-api.jar
c:\apache-tomcat-6.0.29\lib\ojdbc14.jar
c:\apache-tomcat-6.0.29\lib\jakarta-oro-2.0.8.jar
c:\apache-tomcat-6.0.29\lib\jakarta-regexp-1.5.jar
2) In CodeCharge change the Connection -> Server -> Database Driver to oracle.jdbc.driver.OracleDriver
|
|
|
saamondino
Posts: 33
|
Posted: 01/13/2011, 9:35 AM |
|
Hi,
I use Oracle XE 2 years ago with CCS 4.3, java 1.6 and Tomcat 6, y I have never had problems.
mansb2002
What I can see, is that you are using ojdbc14.jar, I also have these 4 files
ojdbc5.jar
ojdbc14dms.jar
classes12.jar
classes12dms.jar
Test you please.
Regards.
Sergio.
|
|
|
|