Eclipse Community Forums: BIRT » rptdesign file changes for connection pool

Home » Archived » BIRT » rptdesign file changes for connection pool

rptdesign file changes for connection pool [message #119535]

Mon, 30 January 2006 04:07

Eclipse User

Originally posted by: kerem.ersoy.m2m.com.tr

Hi!
I was following Mr.Jason Weathersby's "using a supplied connection with
BIRT" blog post.
I am getting "java.lang.NoClassDefFoundError:
org/eclipse/birt/report/data/oda/jdbc/OdaJdbcDriver" error.
I suspect I am using the wrong attributes in my design file. What should the
values of <data-sources> tag be?

Re: rptdesign file changes for connection pool [message #119945 is a reply to message #119535]

Mon, 30 January 2006 07:59

Eclipse User

Kerem,

I will upload this example today.

Jason Weathersby
BIRT PMC

"Kerem" <kerem.ersoy@m2m.com.tr> wrote in message
news:drkl80$13g$1@utils.eclipse.org...
> Hi!
> I was following Mr.Jason Weathersby's "using a supplied connection with
> BIRT" blog post.
> I am getting "java.lang.NoClassDefFoundError:
> org/eclipse/birt/report/data/oda/jdbc/OdaJdbcDriver" error.
> I suspect I am using the wrong attributes in my design file. What should
> the values of <data-sources> tag be?
>

Re: rptdesign file changes for connection pool [message #120339 is a reply to message #119535]

Mon, 30 January 2006 12:58

Eclipse User

Kerem,

Here is the example from the Birtworld posting.

Jason

"Kerem" <kerem.ersoy@m2m.com.tr> wrote in message
news:drkl80$13g$1@utils.eclipse.org...
> Hi!
> I was following Mr.Jason Weathersby's "using a supplied connection with
> BIRT" blog post.
> I am getting "java.lang.NoClassDefFoundError:
> org/eclipse/birt/report/data/oda/jdbc/OdaJdbcDriver" error.
> I suspect I am using the wrong attributes in my design file. What should
> the
> values of <data-sources> tag be?
>
>

Attachment: ConnectionPoolExample.zip
(Size: 31.42KB, Downloaded 145 times)

Re: rptdesign file changes for connection pool [message #153548 is a reply to message #120339]

Thu, 13 April 2006 16:13

Eclipse User

Originally posted by: lei.chen.optimalpayments.com

Hi Jason,

I'm trying to get your example working with Weblogic 8.1, but I'm
getting the following error. Note in my report SQL there are IN
parameter defined as '?'s.

When I used the default OdaJdbcDriver, everything seems to work fine.

I wonder whether SubOdaJdbcDriver is doing something weird there.

Lei

There are errors on the report page:
- There are error(s) in report : report

Error0 : odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the
result set metadata.
SQL statement does not return a ResultSet object.
Missing IN or OUT parameter at index:: 1
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:315)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at jsp_servlet._birt.__run._jspService(run.jsp:112)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationA ction.run(ServletStubImpl.java:996)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(Serv letStubImpl.java:419)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(Serv letStubImpl.java:315)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvoca tionAction.run(WebAppServletContext.java:6452)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(Aut henticatedSubject.java:321)
at
weblogic.security.service.SecurityManager.runAs(SecurityMana ger.java:118)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet (WebAppServletContext.java:3661)
at
weblogic.servlet.internal.ServletRequestImpl.execute(Servlet RequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219 )
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL
statement does not return a ResultSet object.
Missing IN or OUT parameter at index:: 1
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:342)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:387)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:355)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
... 28 more
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:125)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:162)
at
oracle.jdbc.driver.OraclePreparedStatement.processCompletedB indRow(OraclePreparedStatement.java:1536)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:2880)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:2926)
at
weblogic.jdbc.wrapper.PreparedStatement.executeQuery(Prepare dStatement.java:124)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:338)
... 32 more

Jason Weathersby wrote:
> Kerem,
>
> Here is the example from the Birtworld posting.
>
> Jason
>
> "Kerem" <kerem.ersoy@m2m.com.tr> wrote in message
> news:drkl80$13g$1@utils.eclipse.org...
>> Hi!
>> I was following Mr.Jason Weathersby's "using a supplied connection with
>> BIRT" blog post.
>> I am getting "java.lang.NoClassDefFoundError:
>> org/eclipse/birt/report/data/oda/jdbc/OdaJdbcDriver" error.
>> I suspect I am using the wrong attributes in my design file. What should
>> the
>> values of <data-sources> tag be?
>>
>>
>
>

Re: rptdesign file changes for connection pool [message #153822 is a reply to message #153548]

Mon, 17 April 2006 10:57

Eclipse User

Lei,

What is the SQL you are passing in? The Sub example doesnt do anything
specific with it. It only sets the connection variable for the JDBC driver.

Jason

"Lei" <lei.chen@optimalpayments.com> wrote in message
news:443EB0CD.2060109@optimalpayments.com...
> Hi Jason,
>
> I'm trying to get your example working with Weblogic 8.1, but I'm getting
> the following error. Note in my report SQL there are IN parameter defined
> as '?'s.
>
> When I used the default OdaJdbcDriver, everything seems to work fine.
>
> I wonder whether SubOdaJdbcDriver is doing something weird there.
>
> Lei
>
>
> There are errors on the report page:
> - There are error(s) in report : report
>
> Error0 : odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the
> result set metadata.
> SQL statement does not return a ResultSet object.
> Missing IN or OUT parameter at index:: 1
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:315)
> at
> org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)
> at
> org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
> at jsp_servlet._birt.__run._jspService(run.jsp:112)
> at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
> at
> weblogic.servlet.internal.ServletStubImpl$ServletInvocationA ction.run(ServletStubImpl.java:996)
> at
> weblogic.servlet.internal.ServletStubImpl.invokeServlet(Serv letStubImpl.java:419)
> at
> weblogic.servlet.internal.ServletStubImpl.invokeServlet(Serv letStubImpl.java:315)
> at
> weblogic.servlet.internal.WebAppServletContext$ServletInvoca tionAction.run(WebAppServletContext.java:6452)
> at
> weblogic.security.acl.internal.AuthenticatedSubject.doAs(Aut henticatedSubject.java:321)
> at
> weblogic.security.service.SecurityManager.runAs(SecurityMana ger.java:118)
> at
> weblogic.servlet.internal.WebAppServletContext.invokeServlet (WebAppServletContext.java:3661)
> at
> weblogic.servlet.internal.ServletRequestImpl.execute(Servlet RequestImpl.java:2630)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219 )
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL
> statement does not return a ResultSet object.
> Missing IN or OUT parameter at index:: 1
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:342)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:387)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:355)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
> ... 28 more
> Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:125)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:162)
> at
> oracle.jdbc.driver.OraclePreparedStatement.processCompletedB indRow(OraclePreparedStatement.java:1536)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:2880)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:2926)
> at
> weblogic.jdbc.wrapper.PreparedStatement.executeQuery(Prepare dStatement.java:124)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:338)
> ... 32 more
>
>
> Jason Weathersby wrote:
>> Kerem,
>>
>> Here is the example from the Birtworld posting.
>>
>> Jason
>>
>> "Kerem" <kerem.ersoy@m2m.com.tr> wrote in message
>> news:drkl80$13g$1@utils.eclipse.org...
>>> Hi!
>>> I was following Mr.Jason Weathersby's "using a supplied connection with
>>> BIRT" blog post.
>>> I am getting "java.lang.NoClassDefFoundError:
>>> org/eclipse/birt/report/data/oda/jdbc/OdaJdbcDriver" error.
>>> I suspect I am using the wrong attributes in my design file. What should
>>> the
>>> values of <data-sources> tag be?
>>>
>>>
>>

Previous Topic:	Problems with load report from stream and report library
Next Topic:	Using run instead of frameset for drill through

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 16:31:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter