connection error

0
I'm trying to run a simple report I created using I-Report in the JasperIntelligence web tool. This report queries an Oracle DB. I installed Oracle JDBC driver. Just not sure if there's something I missed in the configuration somewhere or a PATH issue or what. Here's the error message I receive when I run the report:

Error Message:
org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14e2c9c targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@152d950, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Error creating connection.

Error Trace:
org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14e2c9c targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@152d950, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Error creating connection.
org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14e2c9c targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@152d950, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Error creating connection.
com.jaspersoft.jasperserver.api.JSException: Error creating connection.
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:53)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:47)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:492)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:254)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:601)
at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:58)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:234)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231)


I'm at a total loss. Any help would be sooo greatly appreciated. Thanks.
sivle's picture
2
Joined: Jul 28 2006 - 3:58am
Last seen: 13 years 1 month ago

3 Answers:

0
looks like it has something to do with my Oracle URL..i didn't realize there was more to the error message. Essentially this is the error:
Caused by: java.sql.SQLException: Invalid Oracle URL specified

Here's the url i'm using...i can't figure out where i'm going wrong.
jdbc:oracle:thin:@is-can-d3.ads.is.edu:1521:CA03

Any ideas?
sivle's picture
2
Joined: Jul 28 2006 - 3:58am
Last seen: 13 years 1 month ago
0
Does that Oracle URL work outside the server?

How have you set up the report unit using the Oracle connection? As a JDBC or a JNDI connection?


Sherman
JasperSoft
swood's picture
2447
Joined: Jun 21 2006 - 12:48pm
Last seen: 6 years 11 months ago
0
i am using jdbc connection.
there also same error. Any idea
saravanan's picture
Joined: Nov 6 2007 - 9:45pm
Last seen: 11 years 10 months ago
Feedback
randomness