Logo 
Search:

Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Jasper Report - Running For Hours

  Asked By: Kes    Date: Dec 12    Category: Java    Views: 1491
  

Hi Everyone,

When I run my report through Ireport (Desinger) the report takes about 7 minutes. The report uses an oracle stored procedure to create a temporary table.

When the same report is deployed in Jboss and runs the compiled jasper report the called stored procedure runs for about 5 hours. Why is there such a huge difference in the oracle stored procedure time.

The same stored procedure on an sqlPlus command line takes about 2 minutes.

Any pointers as to where the problem lies will be appreciated

Rgds
Kes

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Jasper Report - Running For Hours Or get search suggestion and latest updates.




Tagged: