Re: sql in php with paging -- WEB400

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Nathan Andelin skrev:

Do you have any suggestions on how to resolve this issue?

When a few of my Java colleagues were trying to implement paging, I suggested that each user session be given their own DB connection and allow the QZDASOINIT servers to maintain state for each, rather than running a new Select for each page. They rejected that idea initially, over concerns of scalability, but after several attempts with other designs, they came back and implemented it the way I originally suggested.

I have just finished refreshing my Java knowledge and found that the Java Persistance Arcitechture (JPA) defined in EJB3 can run on non-J2EE servers (plain web containers or stand-alone applications) and is very powerful. It allows for simple paging by setting the "start at" and "give me X items" on each query, and then letting the persistence layer deal with asking the database properly.

I have played with the Hibernate implementation in MyEclipse and did some work with AS/400 as the backend. You must have journalled tables as this is always in a transactional setting.

When you get this up and running the JPQL (sql look alike) is extremely powerful and allows for rapid prototyping of new facilities!

/Thorbjørn

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.