nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

URGENT - Error when using a supplied JDBC Connection Object in BIRT3.7

Santek

Hi, 
We are currently using BIRT2.3.1. 
We have a J2EE application built that has a JDBC connection object already set up and we pass this connection object to a BIRT report. Please see the following code we wrote on J2EE application: 
Connection theConnection = null; 
String rptDesign = reportUIConfigurationService.getReportDesingFile(reportID); 
try{ 
theConnection = reportingConnectionOperatorDispatcher.getConnectionAndPrepareForExecution(reportID, 
reportCharID, 
userApplicationContext.getGroupId()); 
 
request.getSession(false).setAttribute("theconn",theConnection); 
 
request.getSession(false).setAttribute("r_reportCharacteristicsID",reportCharID != null ? reportCharID :new BigDecimal(-1)); 
request.getSession(false).setAttribute("r_groupID",userApplicationContext.getGroupId()); 
request.getSession(false).setAttribute("r_reportID",userApplicationContext.getCurrentReportID()); 
 
}catch(Exception e){ 
logger.error("Error getting connection or preparing for execution of the report!"); 
if(theConnection != null && !theConnection.isClosed()) 
theConnection.close(); 
e.printStackTrace(); 
throw new Exception(e.getMessage()); 
}finally{ 
//clear the context 
userApplicationContext.removeAllUserPreferences(); 
} 
 
return new ModelAndView(new RedirectView(baseURL+rptDesign)); 
 
I wrote the following code on Birt design file on INITIALIZE event to use connection object that was passed by J2EE application: 
 
if(reportContext.getAppContext().get("birt_engine") == null){ 
var conn = reportContext.getHttpServletRequest().getSession().getAttribute("theconn"); 
reportContext.getAppContext().put("OdaJDBCDriverPassInConnection", conn); 
} 
 
This code was working fine in BIRT2.3.1. But we are getting the following error messages when we upgraded to BIRT3.7. 
 
The following items have errors: 
 
 
ReportDesign (id = 1): 
- There are errors evaluating script "if(reportContext.getAppContext().get("birt_engine") == null){ 
var conn = reportContext.getHttpServletRequest().getSession().getAttribute("theconn"); 
reportContext.getAppContext().put("OdaJDBCDriverPassInConnection", conn); 
} 
": 
javax/transaction/xa/XAResource (Element ID:1) 
birt.core.JavascriptCommonError ( 1 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if(reportContext.getAppContext().get("birt_engine") == null){ 
var conn = reportContext.getHttpServletRequest().getSession().getAttribute("theconn"); 
reportContext.getAppContext().put("OdaJDBCDriverPassInConnection", conn); 
} 
": 
javax/transaction/xa/XAResource (Element ID:1) 
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:158) 
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleBeforeRender(ReportScriptExecutor.java:164) 
at org.eclipse.birt.report.engine.api.impl.EngineTask.startRender(EngineTask.java:1832) 
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:603) 
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294) 
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547) 
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204) 
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238) 
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105) 
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) 
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:597) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) 
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:597) 
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) 
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) 
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) 
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.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:454) 
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) 
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368) 
at aces.spring.security.filter.SSOAuthenticationProcessingFilter.doFilter(SSOAuthenticationProcessingFilter.java:240) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169) 
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) 
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 
at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) 
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) 
at java.lang.Thread.run(Thread.java:662) 
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "if(reportContext.getAppContext().get("birt_engine") == null){ 
var conn = reportContext.getHttpServletRequest().getSession().getAttribute("theconn"); 
reportContext.getAppContext().put("OdaJDBCDriverPassInConnection", conn); 
} 
": 
javax/transaction/xa/XAResource 
at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:295) 
at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:154) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:777) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:706) 
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScriptInternal(ScriptExecutor.java:61) 
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScript(ScriptExecutor.java:48) 
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleBeforeRender(ReportScriptExecutor.java:156) 
... 64 more 
Caused by: java.lang.NoClassDefFoundError: javax/transaction/xa/XAResource 
at java.lang.Class.getDeclaredMethods0(Native Method) 
at java.lang.Class.privateGetDeclaredMethods(Class.java:2427) 
at java.lang.Class.privateGetPublicMethods(Class.java:2547) 
at java.lang.Class.privateGetPublicMethods(Class.java:2557) 
at java.lang.Class.getMethods(Class.java:1410) 
at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:380) 
at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:405) 
at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:405) 
at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:335) 
at org.mozilla.javascript.JavaMembers.reflect(JavaMembers.java:450) 
at org.mozilla.javascript.JavaMembers.<init>(JavaMembers.java:76) 
at org.mozilla.javascript.JavaMembers.lookupClass(JavaMembers.java:838) 
at org.mozilla.javascript.NativeJavaObject.initMembers(NativeJavaObject.java:90) 
at org.mozilla.javascript.NativeJavaObject.<init>(NativeJavaObject.java:80) 
at org.mozilla.javascript.NativeJavaObject.<init>(NativeJavaObject.java:70) 
at org.mozilla.javascript.WrapFactory.wrapAsJavaObject(WrapFactory.java:149) 
at org.mozilla.javascript.WrapFactory.wrap(WrapFactory.java:105) 
at org.eclipse.birt.report.engine.javascript.JavascriptEngine$2.wrap(JavascriptEngine.java:160) 
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:258) 
at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) 
at org.mozilla.javascript.gen.c24._c0(/report/method[@name="beforeRender"]:2) 
at org.mozilla.javascript.gen.c24.call(/report/method[@name="beforeRender"]) 
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398) 
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065) 
at org.mozilla.javascript.gen.c24.call(/report/method[@name="beforeRender"]) 
at org.mozilla.javascript.gen.c24.exec(/report/method[@name="beforeRender"]) 
at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:290) 
... 70 more 
Caused by: java.lang.ClassNotFoundException: javax.transaction.xa.XAResource from [Module "oracle:main" from local module loader @4cee32 (roots: C:\ACES_develop_jboss_as_7\jboss-as-7.0.0.Final\modules)] 
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:191) 
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:358) 
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:330) 
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:307) 
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:101) 
... 97 more 
 
 
 
List DD6334 Parent List: 
+ Can not load the report query: 389. Errors occurred when generating the report document for the report element with ID 389. (Element ID:389) 
Error.ReportQueryLoadingError2 ( 1 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 389. Errors occurred when generating the report document for the report element with ID 389. (Element ID:389) 
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:160) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897) 
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412) 
at org.eclipse.birt.report.engine.internal.document.v4.ListItemExecutor.doExecute(ListItemExecutor.java:41) 
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294) 
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226) 
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86) 
at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:800) 
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62) 
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) 
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:681) 
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294) 
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547) 
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204) 
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238) 
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105) 
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) 
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:597) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) 
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:597) 
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) 
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) 
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) 
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.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:454) 
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) 
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368) 
at aces.spring.security.filter.SSOAuthenticationProcessingFilter.doFilter(SSOAuthenticationProcessingFilter.java:240) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79) 
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380) 
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169) 
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) 
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 
at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) 
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) 
at java.lang.Thread.run(Thread.java:662) 
 
 
 
 
 
 
I thank you in advance for your help.

Find more posts tagged with

Comments

mwilliams

This is with the designer? Or when deployed to your app? If deployed, are you sure you have all of your runtime jars in your classpath?

Santek

I believe all jars are in place correctly. Because when I run a report with scripted Data Source I do see the report output on viewer. But the report fails when I pass a custom build JDBC connection object to BIRT?s application context object like below and run a report to view on viewer. This code works fine in BIRT2.3.1 but not working in BIRT3.7. 
 
var conn = reportContext.getHttpServletRequest().getSession().getAttribute("theconn"); 
reportContext.getAppContext().put("OdaJDBCDriverPassInConnection", conn); 
 
 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="81772" data-time="1314037491" data-date="22 August 2011 - 11:24 AM">
This is with the designer? Or when deployed to your app? If deployed, are you sure you have all of your runtime jars in your classpath? </blockquote>

mwilliams

This part of the error gives the most information:

Caused by: java.lang.ClassNotFoundException: javax.transaction.xa.XAResource from [Module "oracle:main" from local module loader @4cee32 (roots: C:\ACES_develop_jboss_as_7\jboss-as-7.0.0.Final\modules)]

Are you using an oracle database in both situations? Or are you using the oracle connection when you're passing the custom info?

Santek

Yes in both situations we are using Oracle connection.
We are passing a real oracle connection to BIRT.
We do some work on ?theconn? connection in our application (put data in global temp tables) and then have that connection used by BIRT.
This was working fine with in JBOSS4.2.2 and BIRT2.3.1 version. In BIRT2.3.1 version it automatically picks up the connection I passed and overwrites with the connection defined in the report.
But the reports are failing when we upgraded to JBOSS7 and BIRT3.7.
Thanks

mwilliams

Could you try changing the connection information in the property binding section in your dataSource editor instead?

Santek

Hello mwilliams, 
 
I don't see how I can pass a real connection to BIRT through property binding section. I want to pass a real 
connection, do some work on that connection (populate data into global temp tables) and then have BIRT use that connection. I was able to do it in BIRT3.2.1. But the same code is not working in BIRT3.7. Any idea how to do it in BIRT3.7? 
One more question, in BIRT 3.7 java script I do not see the following method/property 
reportContext.getHttpServletRequest().getSession(). Any idea how to get a session in BIRT3.7? 
 
Thanks 
Hari 
 
 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="81817" data-time="1314122694" data-date="23 August 2011 - 11:04 AM">
Could you try changing the connection information in the property binding section in your dataSource editor instead? </blockquote>

mwilliams

I spoke with a co-worker of mine. He says that this should still work. Please run the attached report and post the output. Thanks.