Ingres Community Blogs

I recently learnt that Ingres 9.2 has introducted the facility to restrict the rows returned from a query by specifying an offset.

Where previously you would only be able to select the first n rows:
SELECT FIRST n col_name FROM table WHERE col_name = 'value';

There is now an "OFFSET" clause:
SELECT FIRST n col_name FROM table WHERE col_name = 'value' OFFSET m;

I went about implementing this in OpenJPA, but found that this dual-location...

A while ago we were approached by a company using OpenJPA for their product wanting us to help them port it to Ingres. It fell to me to do the work and it ended up being really interesting, so I thought I'd share some of the progress that's been made.

JPA is a "Persistence Framework" for Java, meaning a way to store a program's data, usually represented in an application as objects, into a database. [url=http://openjpa.apache.org]OpenJPA[/url] is the Apache Foundation's...