Library's jdbc connection weard behaviour

Good day, 
 
I'm sorry its once again a lengthy post to explain a problem I have. (ill add an example (with no real JDBC info later). 
 
We are going live with our reports on the iServer Express the database we use is an Oracle 11 Database . 
 
We have been using the ojdbc.jar (Implementation version 11.2.0.2.0). With just an SID connection 
jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID 
 
Now in production were going to work on service level so that we can fall back to other databases when thing's go wrong (jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE). 
 
Now I think the problem is in the way Library's share between each other. 
 
We have for the sake of ease of editing (and we thought this was the way to go) created several Library's we have the following library's: 
 
<ul class='bbc'><li> Connections.rptlibrary</li><li> Data.rptlibrary</li><li> Masterpages.rptlibrary</li><li> Styles.rptlibrary</li><li> Templates.rptlibrary</li></ul>
 
There are some interaction between the Library's 
 
The Data library inherets the conections from the connection library. And has a data set for the property binding. 
<blockquote class='ipsBlockquote' >On a side note I find it weird that the Property binding is not inherited to the other library's</blockquote>
 
Then we have the Templates library. This inherets evry thing from Data.rptlibrary but creates some elements we use in the coverpages of our reports. (It also uses the Styles library for this of course). 
 
Now the problem is. The our query's work in Data.rptlibrary but when I run the same query in Templates.rptilbrary ( by opening the query and then go to preview resutls) I get the folowing stack trace: 
<blockquote class='ipsBlockquote' >org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report. 
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:135) 
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:97) 
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:49) 
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:58) 
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:333) 
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) 
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details: 
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. 
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error: 
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 
. 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:637) 
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:166) 
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:126) 
... 5 more 
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. 
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error: 
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 
. 
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54) 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177) 
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:222) 
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:210) 
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:208) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316) 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:448) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178) 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145) 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:617) 
... 7 more 
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error: 
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 
. 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:262) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212) 
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:235) 
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:160) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250) 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165) 
... 17 more </blockquote>
 
So the weard thing is, I made sure the connection even works without the property binding (somting that does not inherit so well for some weard reason). The query works in the library it was created in. But not in the library that inherets it and thus it does not work in a real repport/temlate. 
 
What could be the couse of this?

Find more posts tagged with

Comments

There are no comments yet