Loading

Tag Archives: pagination

JTable bound to a database with lazy loading

January 13, 2010 – 8:10 pm

I’ve been doing experiments with JTables bound to database tables in the past. But I was not satisfied with the result to be honest. The pagination helps but there is still noticeable pauses each time a database query has to be issued. So I started looking into other possibilities.
I come up with the idea [...]

By ruben.laguna | Posted in java | Also tagged , , , , , , , , | Comments (0)

Derby 10.5 “OFFSET/FETCH” and JPA

September 11, 2009 – 9:44 pm

It seems that no current JPA implementation is able to paginate the result using Apache Derby 10.5 “OFFSET/FETCH” mechanism. So javax.persistence.Query setFirstResult and setMaxResults don’t really translate into proper pagination with “OFFSET/FETCH”

TopLink/EclipseLink org.eclipse.persistence.platform.database.DerbyPlatform
Hibernate org.hibernate.dialect.DerbyDialect
OpenJPA. org.apache.openjpa.jdbc.sql.DerbyDictionary

Bookmark It

Hide Sites

$$(‘div.d852′).each( function(e) { e.visualEffect(’slide_up’,{duration:0.5}) });

By ruben.laguna | Posted in java | Also tagged , , , , , , , , | Comments (1)

JTable, Beans Binding and JPA pagination

August 18, 2009 – 6:00 pm

In my previous post I talk about JTable and JPA pagination through a custom TableModel.
Now working directly with TableModel is not want you want to do, you want to use Beans Bindings because it means less manual coding and a lot of help from the IDE (like Netbeans).
With netbeans you can easily bind [...]

By ruben.laguna | Posted in java, netbeans | Also tagged , , , , , , , , , , , , , | Comments (1)

JTable and JPA Pagination through custom TableModel

August 17, 2009 – 6:00 pm

I really want to talk about JTable, Beans Binding and JPA pagination but I think I need to write about JTable and JPA pagination first. So I will take the Beans binding stuff in another post.
By the way, choose wisely your JPA Provider/DB Provider combination, as some combinations will not give you any real paginations [...]

By ruben.laguna | Posted in java, netbeans | Also tagged , , , , , , , , , , , , , , , , , , , , | Comments Off