Eclipse Community Forums: BIRT » Need help on setting up to use Weblogic Connection Pool

Home » Archived » BIRT » Need help on setting up to use Weblogic Connection Pool

Need help on setting up to use Weblogic Connection Pool [message #338135]

Wed, 23 January 2008 19:00

Eclipse User

Originally posted by: selene.lo.infor.com

I try to use the connection pool named "dataPool" I defined on Weblogic
9.2 as the data source of the report. Here is what I have done:

I updated the .rptdesign file as follow:
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="43">
<property
name="odaDriverClass">weblogic.jdbc.pool.Driver</property >
<property name="odaURL">jdbc:weblogic:pool:dataPool</property>
<property name="odaUser"></property>
<encrypted-property name="odaPassword"></encrypted-property>
</oda-data-source>
</data-sources>

I copied the weblogic.jar and xbean.jar from weblogic package into
WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jd bc_2.2.1.r22x_v20070919\drivers
folder. When I tried to run the report, I ran into this error:

SEVERE: Error happened while running the report.
java.lang.NoClassDefFoundError
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Nativ e
Method)

at
sun.reflect.NativeConstructorAccessorImpl.newInstance(Native Construct
orAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De legatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:4 94)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JD
BCDriverManager.java:631)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegist
erDriver(JDBCDriverManager.java:731)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDB
CDriverManager.java:192)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection
(JDBCDriverManager.java:158)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connect
ion.java:158)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java
:115)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.
open(OdaConnection.java:235)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnec
tion(ConnectionManager.java:145)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSo
urce.java:134)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java
:121)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource
(DataSourceRuntime.java:214)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryE
xecutor.java:265)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(Quer
yExecutor.java:210)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQue
ry.java:500)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(Pre
paredDataSourceQuery.java:161)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (Prepared
OdaDSQuery.java:142)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(Pre
paredDataSourceQuery.java:141)
at
org.eclipse.birt.report.data.adapter.impl.DataSetIterator.ex ecuteQuer
y(DataSetIterator.java:175)
at
org.eclipse.birt.report.data.adapter.impl.DataSetIterator.<init >(Data
SetIterator.java:127)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.popu
lateDimension(DataRequestSessionImpl.java:833)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.popu
lateDimensions(DataRequestSessionImpl.java:766)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.crea
teCube(DataRequestSessionImpl.java:594)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.mate
rializeCube(DataRequestSessionImpl.java:526)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prep
are(DataRequestSessionImpl.java:888)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prep
are(DataRequestSessionImpl.java:467)
at
org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doPrepar
eQuery(DataGenerationEngine.java:94)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.p repare(Ab
stractDataEngine.java:138)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(Report
Executor.java:94)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportEx
ecutor.execute(WrappedReportExecutor.java:59)
at
org.eclipse.birt.report.engine.internal.executor.emitter.Rep ortEmitte
rExecutor.execute(ReportEmitterExecutor.java:76)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportEx
ecutor.execute(WrappedReportExecutor.java:59)
at
org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplciat
eReportExecutor.execute(SuppressDuplciateReportExecutor.java :51)
at
org.eclipse.birt.report.engine.presentation.ReportDocumentBu ilder.bui
ld(ReportDocumentBuilder.java:187)
at
org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:22
4)
at
org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:89)
at
org.eclipse.birt.report.service.ReportEngineService.runRepor t(Unknown
Source)
at
org.eclipse.birt.report.service.BirtViewerReportService.runR eport(Unk
nown Source)
at
org.eclipse.birt.report.service.actionhandler.BirtRunReportA ctionHand
ler.__execute(Unknown Source)
at
org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActi
onHandler.runReport(Unknown Source)
at
org.eclipse.birt.report.service.actionhandler.AbstractChange Parameter
ActionHandler.__execute(Unknown Source)
at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandl
er.execute(Unknown Source)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProc
essor.__executeAction(Unknown Source)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentPro
cessor.executeAction(Unknown Source)
at
org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.ha
ndleChangeParameter(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentPro
cessor.process(Unknown Source)
at
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUp
datedObjects(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.j
ava:397)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider
java:186)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:
323)
at
org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrateg
y.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at
org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453
)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 )
at
org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:69
9)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPo
st(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBas
e.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
weblogic.servlet.internal.StubSecurityHelper$ServletServiceA ction.run
(StubSecurityHelper.java:223)
at
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(S tubSecuri
tyHelper.java:125)
at
weblogic.servlet.internal.ServletStubImpl.execute(ServletStu bImpl.jav
a:283)
at
weblogic.servlet.internal.TailFilter.doFilter(TailFilter.jav a:26)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterCha inImpl.ja
va:42)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown
Source)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterCha inImpl.ja
va:42)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvoca tionActio
n.run(WebAppServletContext.java:3243)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(Aut henticate
dSubject.java:321)
at
weblogic.security.service.SecurityManager.runAs(SecurityMana ger.java:
121)
at
weblogic.servlet.internal.WebAppServletContext.securedExecut e(WebAppS
ervletContext.java:2003)
at
weblogic.servlet.internal.WebAppServletContext.execute(WebAp pServletC
ontext.java:1909)
at
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequ estImpl.j
ava:1359)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

What am I missing? Can someone help?

Thanks,
Selene

Previous Topic:	Need help on setting up to use Weblogic Connection Pool
Next Topic:	Need help on setting up to use Weblogic Connection Pool

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Apr 22 19:09:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter