Running an report hitting oracle

Posted on August 15, 2006 at 11:06pm

Can someone please educate me on where to define the jdbc driver.

I have updated the context.xml and web.xml file to have my datasources and the url is tested fine in the ireport tool.

I have tried locally defined and repository based oracle data source and still get the java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver.

Let me know where else do i need to configure the jdbc driver.

org.springframework.webflow.ActionExecutionException:
    Exception thrown executing [AnnotatedAction@1c82208 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@324b85,
                                attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow';
    nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper:
        java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver com.jaspersoft.jasperserver.api.JSExceptionWrapper:
            java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
JasperReports® Server
aramachandra's picture
aramachandra
72
Joined: Jul 26 2006 - 5:32am
Last seen: 16 years 8 months ago

1 Answer:

Posted on August 31, 2006 at 3:56pm
You need to place your oracle driver within the lib directory of the web app. Example.
jasperintelligence-1.0\apache-tomcat\webapps\jasperserver\WEB-INF\lib

From there the app server will automatically pick it up and load the driver.
cmoudy's picture
cmoudy
61
Joined: Aug 29 2006 - 7:16am
Last seen: 16 years 6 months ago
Feedback