Cursor « postgresql « Java Database Q&A





1. Why do my JDBC cursors perform so slowly?    stackoverflow.com

I'm following verbatim the code outlined in the following (Example 5.2) http://jdbc.postgresql.org/documentation/81/query.html My query is quite simple

SELECT *  FROM "LSERAW" WHERE "DATETIME">='Sat Jan 01 00:00:00 EST 2011' and "DATETIME"<='Thu Jun ...

2. Is it possible to retrieve an object that is split into three tables with only one query?    stackoverflow.com

EDIT: The answers works, but slow down the query a lot. Is there another solution?


I have the following object in my program. Page haves various TextBlock that haves various Token. The three are ...