Loading

Tag Archives: persistence

OpenJPA, HSQLDB and proper shutdown

I’m starting to get tired of OpenJPA/HSQLDB setup that I’ve trying: it seems to give more problems than it solves. Now I discovered that the HSQL db wasn’t been properly shutdown and for reasons that I’m investigating, if the HSQL db is not propertly closed (SHUTDOWN command) it’s impossible to reopen it again. It [...]

Netbeans refuses to recognize persistence.xml (no visual editor)

If you create the persistence.xml manually in Windows the file will be created with CRLF line endings (windows style line endings) ,that will prevent Netbeans for recognizing Netbeans will not recognize it as the special file it is and won’t be able to to open it with the special/custom visual editor.
I opened an bug [...]

Derby 10.5 “OFFSET/FETCH” and JPA

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}) });

JTable, Beans Binding and JPA pagination

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 [...]

JTable and JPA Pagination through custom TableModel

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 [...]