Eclipse Community Forums: BIRT » Error to use weblogic pooled connection

Home » Archived » BIRT » Error to use weblogic pooled connection

Error to use weblogic pooled connection [message #146276]

Tue, 21 March 2006 00:36

Eclipse User

Originally posted by: seno.cnlab.net

We deploy BIRT 2.0.1 on Weblogic 8.1.4 using a oracle(9.2.0.1) JDBC connection
from weblogic connection pool (weblogic.jdbc.wrapper.PoolConnection), Attempting
to use bind arguments in a select query result in the following error
severe: Cannot get resultset metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: A JDBC Exception occured:
ORA-01008: not all variables bound
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)
....
but it is working on tomcat 5.0 + dbcp(org.apache.commons.dbcp.PoolableConnection)

Any help would be appreciated.

Thanks,
tseng

Re: Error to use weblogic pooled connection [message #151195 is a reply to message #146276]

Wed, 05 April 2006 15:38

Eclipse User

Originally posted by: lei.chen.optimalpayments.com

Hi,

I'm insterested in this topic too.

Also I wonder how you got it set up in weblogic. I was getting the
following after deploying the viewer war to Weblogic:

java.lang.AssertionError
at
org.eclipse.birt.report.viewer.aggregation.parameter.ScalarP arameterFragment.doService(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
Source)
at
jsp_servlet._pages._control._dialog.__parameterdialogfragmen t._jspService(__parameterdialogfragment.java:177)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)

Another question - how to specify JNDI DataSource in the report or library?

Lei

seno wrote:
> We deploy BIRT 2.0.1 on Weblogic 8.1.4 using a oracle(9.2.0.1) JDBC
> connection from weblogic connection pool
> (weblogic.jdbc.wrapper.PoolConnection), Attempting to use bind arguments
> in a select query result in the following error
> severe: Cannot get resultset metadata.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: A JDBC Exception
> occured: ORA-01008: not all variables bound
> 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)
>
> ....
> but it is working on tomcat 5.0 +
> dbcp(org.apache.commons.dbcp.PoolableConnection)
>
> Any help would be appreciated.
>
> Thanks,
> tseng
>
>

Previous Topic:	multiple parameter passing problem
Next Topic:	NullPointer Error in Running SalesReport of org.eclipse.birt.chart.examples

Goto Forum:

-=] Back to Top [=-

Current Time: Sat May 10 00:38:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter