Jump to content
Changes to the Jaspersoft community edition download ×

connection error


sivle

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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?

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...