JSP pagnation issue

Posted on 2006-11-10
Medium Priority
Last Modified: 2008-01-09

I have used JSP paganation but never run into this issue before. I'm reading thousands of records and creating paganation in few sec/min. on our test server, but when it goes to production server same paganation taking half hour to create ? Any idea why is so ??

Question by:princehyderabad
  • 4
  • 2
LVL 10

Expert Comment

ID: 17917135
see whats the difference between dev and production environments. are you using same  database in both the envoronments?

Author Comment

ID: 17917316
U got correct.

Dev env. is diff. then Prod.

Dev: Application server and DB are at one place

Prod: Application and DB server are at 2 diff. place.

Author Comment

ID: 17917318
But what should be solutions........
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 10

Accepted Solution

jaggernat earned 500 total points
ID: 17917518
ok, i believe when you deployed your applicaiton in production server , its not able to get some references.

can you post the code which is giving erors in production environment?


Author Comment

ID: 17918181
Error are related only to DB connection and time out but nothing like ref. other object or code problem.

#1 java.sql.SQLException: ERROR: JagConnProxy: Connection already Closed
#2 The maximum number of rows permitted on a worksheet been exceeded

Other has time out issue. Page not Found. And for few its taking a while to display pagnation...

Author Comment

ID: 17919277
Also is there a way: let say I have 8500 records in my DB. Based on 85k its taking a while to generated paganation. Is there a way where paganation be done based on 100 records or number we provided..

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Starting a business requires forethought, planning and preparation. As eager as you are to get started with business activities, you need to walk through a few important steps to ensure that your business gets off on the right foot.
Healthcare has made massive developments over the past decade, thanks largely to technological advancement. Yet despite that these advancements are saving our lives, few truly understand how much healthcare has changed, and where it is headed.
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question