Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Dropping JDBC Classes
Dropping JDBC Classes [message #659821] Tue, 15 March 2011 17:53 Go to next message
Logan  is currently offline Logan
Messages: 10
Registered: March 2011
Junior Member
Scenario:

Tomcat 5.5.31, BIRT 2.6.2, RHEL 5.5, Java 1.6.23

When the server is first started, ALL reports can be generated just fine. However, after "stress testing" the server (a program constantly runs reports for a hour or so), SOME reports start generating errors. Here is an excerpt of the stack trace, though I doubt its very relevant.

Axis Fault
(...etc.)
faultDetail:
{http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.rep ort.service.api.ReportServiceException: Error happened while running the report.
at org.eclipse.birt.report.service.ReportEngineService.throwDum myException(ReportEngineService.java:1104)
(...etc.)

Caused by: java.lang.NoClassDefFoundError: com/ibm/as400/access/AS400EndJobDS
at com.ibm.as400.access.AS400ImplRemote.getConnection(AS400Impl Remote.java:1069)
at com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote .java:402)
at com.ibm.as400.access.AS400.connectService(AS400.java:1135)


Most of these reports take parameters for the database they are to connect to. One report will run for multiple databases, depending on those values we pass. Because of that, we don't use connection pooling (it connects to ~200 different databases, more than I want to maintain in a pool).

Now, once we start getting this error, the reports that are getting this simply won't run. We can run other reports that are similar, (ie, connect to the same type of DB) without error.

Once Tomcat is restarted, the problem goes away.

Any idea what would be causing BIRT to randomly "drop classes" so to speak?
Re: Dropping JDBC Classes [message #660002 is a reply to message #659821] Wed, 16 March 2011 14:11 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Logan

I have never seen this happen. I assume the AS400 driver is only in the
drivers directory of the jdbc plugin within the webapp/tomcat libs?

Jason

On 3/15/2011 1:53 PM, Logan wrote:
> Scenario:
>
> Tomcat 5.5.31, BIRT 2.6.2, RHEL 5.5, Java 1.6.23
>
> When the server is first started, ALL reports can be generated just
> fine. However, after "stress testing" the server (a program constantly
> runs reports for a hour or so), SOME reports start generating errors.
> Here is an excerpt of the stack trace, though I doubt its very relevant.
> Axis Fault
> (...etc.)
> faultDetail:
> {http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.rep ort.service.api.ReportServiceException:
> Error happened while running the report.
> at org.eclipse.birt.report.service.ReportEngineService.throwDum
> myException(ReportEngineService.java:1104)
> (...etc.)
>
> Caused by: java.lang.NoClassDefFoundError:
> com/ibm/as400/access/AS400EndJobDS
> at com.ibm.as400.access.AS400ImplRemote.getConnection(AS400Impl
> Remote.java:1069)
> at com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote .java:402)
> at com.ibm.as400.access.AS400.connectService(AS400.java:1135)
>
>
> Most of these reports take parameters for the database they are to
> connect to. One report will run for multiple databases, depending on
> those values we pass. Because of that, we don't use connection pooling
> (it connects to ~200 different databases, more than I want to maintain
> in a pool).
> Now, once we start getting this error, the reports that are getting this
> simply won't run. We can run other reports that are similar, (ie,
> connect to the same type of DB) without error.
> Once Tomcat is restarted, the problem goes away.
>
> Any idea what would be causing BIRT to randomly "drop classes" so to speak?
Re: Dropping JDBC Classes [message #660044 is a reply to message #660002] Wed, 16 March 2011 16:16 Go to previous messageGo to next message
Logan  is currently offline Logan
Messages: 10
Registered: March 2011
Junior Member
I have been able to replicate it when the jar is only in the BIRT directory for it, as well as when its in the lib directory for the webapp.

It only seems to happen after the server has been under a heavy load, and it always goes away after tomcat is restarted.
Re: Dropping JDBC Classes [message #660265 is a reply to message #660044] Thu, 17 March 2011 15:12 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Logan,

Can you open a bug for this and list the mechanism you are using to put
the engine under load?

Jason

On 3/16/2011 12:16 PM, Logan wrote:
> I have been able to replicate it when the jar is only in the BIRT
> directory for it, as well as when its in the lib directory for the webapp.
>
> It only seems to happen after the server has been under a heavy load,
> and it always goes away after tomcat is restarted.
Re: Dropping JDBC Classes [message #660285 is a reply to message #660265] Thu, 17 March 2011 16:26 Go to previous message
Logan  is currently offline Logan
Messages: 10
Registered: March 2011
Junior Member
Bugzilla 340346

Previous Topic:Supressing PageHeader & Footer (Masterpage) in XLS Output
Next Topic:BIRT RPC error with GWT
Goto Forum:
  


Current Time: Sat Oct 25 17:36:53 GMT 2014

Powered by FUDForum. Page generated in 0.01766 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software