Efren Lugo
|
| Posted: 06/12/2002, 1:23 PM |
|
I have an Oracle Database and a Tomcat/4.0.3, with codecharge 2.0 y sucessful conect to oracle8i using scott/tiger acount and making a grid of EMP table...
when i do this in CCS 1.0 the grid returns this:
Apache Tomcat/4.0.3 - HTTP Status 500 - Internal Server Error
--------------------------------------------------------------------------------
type Exception report
message Internal Server Error
description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
at com.codecharge.db.JDBCConnection.createPreparedStatement(JDBCConnection.java:728)
at com.codecharge.db.SqlCommand.prepareCommand(SqlCommand.java:155)
at com.codecharge.db.SqlCommand.count(SqlCommand.java:102)
at com.codecharge.PageController.processGrid(PageController.java:822)
at com.codecharge.PageController.process(PageController.java:229)
at org.apache.jsp.EMP$jsp._jspService(EMP$jsp.java:86)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:536)
Whats wrong with CCS 1.0
|
|
|
 |
Efren Lugo
|
| Posted: 06/12/2002, 4:36 PM |
|
For those how have this problem about filling up the database variables for server this is the answer:
CCS 1.0 will ask you for driver and url database location.
the driver will use on oracle is: oracle.jdbc.driver.OracleDriver
but as you know you will need to fill the database url:
ok... this the tick!
you need your JDBC connection string: would look like this:
jdbc:oracle:thin:@<host>:<port>:<service>
jdbc:oracle:thin:@localhost:1521:sintec
then u need to conver to URL!!
this will look like this:
jdbc:odbc:localhost/sintec
look that you need to define:
jdbc:odbc:<host>/<service>
this will make you connect success to oracle enterprise database...
good luck!!
|
|
|
|
|
