Cursor « postgresql « Java Database Q&A

1. Why do my JDBC cursors perform so slowly?

I'm following verbatim the code outlined in the following (Example 5.2) 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?

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