Loading

Tag Archives: derby

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 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

How to get information on UNIQUE keys on Apache Derby

October 16, 2007 – 11:04 am

It´s not easy to get information on derby keys once you created them. I was looking for a command like “SHOW CREATE TABLE <tablename>” but no luck. I realized that the answer should lay in SYS tables. After googling a while I found the following bit of wisdom:

The following query will give [...]

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

Two web applications sharing the same Derby database

October 15, 2007 – 11:04 am

I just realized that to be able to open/share the same Derby database from two different web applications running in the same Tomcat instance (same JVM) you´ll need to put derby.jar in the $TOMCAT_HOME/common/lib and remove it from your applications WEB-INF/lib. I got the clue from this RIFE web page
the jarfiles you need are derby.jar [...]

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