PDA

View Full Version : Oracle Connection Error



coolguy982
06-06-2003, 10:31 AM
I'm trying to connect to an Oracle 8.1 database using the jsp web app version of mondrian/jpivot and the thin driver. I cannot seem to get it to work. Each time I receive the error below.
It seems that the oracle library is not being included when I build the war file. I have entered it in the build.bat file, mondrian.properties, and it is in the path on my pc. Can someone please give me a short but detailed explanation on how to set up a connection with mondrian to an Oracle database?
Thanks!
org.apache.jasper.JasperException: com.tonbeller.jpivot.olap.model.OlapException: Could not load Jdbc Driver oracle.jdbc.driver.OracleDriver
org.apache.jasper.JasperException: com.tonbeller.jpivot.olap.model.OlapException: Could not load Jdbc Driver oracle.jdbc.driver.OracleDriver at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) 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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:71) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:62) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536)

jhyde
06-07-2003, 12:54 PM
The oracle driver -- I think it is called classes12.jar -- needs to be in the WEB-INF\lib directory in mondrian.war. It won't work if it is in a different directory.
Alternatively, you could copy it into to TOMCAT_HOME/common/lib.

coolguy982
06-09-2003, 02:12 AM
I've copied classes12.zip to both folder locations, but i'm still getting the same error. Any other ideas? Thanks.

coolguy982
06-09-2003, 03:19 AM
I was able to correct the database error by using the newest Oracle drivers for java1.4. But now I get this error when trying to perform my query and construct the pivot table:
org.apache.jasper.JasperException: Internal error: while counting members of level '[Grade].[Grade]'; sql=[select count(*) as "c0" from (select distinct "master.vw_adj_prml_wk1"."FACILITY_ID" as "c0" from "master.vw_adj_prml_wk1" "master.vw_adj_prml_wk1") "init"]
It seems as though it is not recognizing the master view in Oracle even though it is connected to the dataset. Any suggestions?
Thanks.

jhyde
06-09-2003, 05:08 AM
Looks like you've supplied the table name as "master.vw_adj_prml_wk1" in your schema.xml. Table names must be in the same case as they are in Oracle -- generally upper-case -- and you need to separate the schema from the table name. So:
<table schema="MASTER" name="VW_ADJ_PRML_WK1"/>

coolguy982
06-09-2003, 08:04 AM
THANKS!!! You saved us a day of debugging.