Birt ODA Extension problem
|
View:
New views
2 Messages
—
Rating Filter:
Alert me
|
 |
Birt ODA Extension problem
by Jonas Bassl
::
Rate this Message:
Hallo,
since quite a few weeks i am developing an ODA Extension for the Eclipse-Plugin Birt to connect to a database called Tamino from the company Software AG by handling and presenting response data from xqueries. Because of this being my first time to develop a project in that dimension, it cost me quite an effort to realize it, but i think, things are working well after solving some exceptions concerning the problem of creating plug ins and their dependencies in eclipse. Until now: I open a new Birt Project in my eclipse environment and choose as new data source the database "Tamino" as i was implementing this. Than i create my new Data set by inserting the xquery, choosing the XPath expression and defining the tables, i want to use for my report. After defining the tables i also can see the small preview of the data out of the database. But when I want to see the whole preview, Eclipse throws me the following lines: [CODE]05.05.2008 18:42:26 org.eclipse.birt.data.engine.odaconsumer.ResultSet fetch SCHWERWIEGEND: Cannot fetch the next data row. The established connection to the data source is not active. org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: The established connection to the data source is not active. at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaObject.newOdaException(OdaObject.java:522) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.next(OdaResultSet.java:169) at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:115) at org.eclipse.birt.data.engine.executor.dscache.DataSetResultCache.cacheDataSet(DataSetResultCache.java:184) at org.eclipse.birt.data.engine.executor.dscache.DataSetResultCache.fetch(DataSetResultCache.java:159) at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:146) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:91) at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:62) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:268) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:241) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:204) at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:68) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:135) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:66) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:185) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:90) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:72) at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:208) at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:112) at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:524) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:761) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:216) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:152) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.populateRecords(ResultSetPreviewPage.java:458) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.access$2(ResultSetPreviewPage.java:451) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:407) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) [/CODE] Now, when I click okay anyway, my new Data set seams to be created and I can define the layout from my report as usual. Just when i want to see the preview of the now layouted report, the console gives me few lines as follows: [CODE]05.05.2008 18:45:44 org.eclipse.birt.report.engine.data.dte.DteDataEngine doExecuteQuery SCHWERWIEGEND: Cannot fetch the next data row. The established connection to the data source is not active. [/CODE] Well, one the one side, i am quite content for having at least any failure output as things haven't always been like that. But I am sitting on this exception for 2 days now and i still don't know what to do to avoid this problem and get the things working properly. When I look for the connection establishing by debugging, things seam to be quite okay. As i still told, i am really new to develop projects of that dimension, so i only can imagine, that i either have missed some point in my implementation or i still don't understand what i am doing here, or both! I would be glad, if someone can help me in this problem and maybe already has seen that exception. I also do not know, if this is the right place to ask my question. Please give me at least some hints to work on this problem. Regards, Jonas _______________________________________________ birt-dev mailing list birt-dev@... https://dev.eclipse.org/mailman/listinfo/birt-dev |
|
|
Re: Birt ODA Extension problem
by JB4You
::
Rate this Message:
Hallo,
i solved my problem. I really have missed something essential in my code. Thanx anyway, Jonas
|
| Free embeddable forum powered by Nabble | Forum Help |
