[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [birt-dev] Birt ODA Extension problem
|
Hallo,
i solved my problem. I really have missed something essential in my code.
Thanx anyway,
Jonas
Jonas Bassl wrote:
>
> 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@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/birt-dev
>
>
--
View this message in context: http://www.nabble.com/Birt-ODA-Extension-problem-tp17078276p17086397.html
Sent from the Eclipse BIRT - Dev mailing list archive at Nabble.com.
