connection error

[sivle]

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]

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?

[swood]

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

[saravanan]

i am using jdbc connection.

there also same error. Any idea