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




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.