Posted Sunday, July 15, 2007 @ 07:59:18  

I use the latest build of QuickTable and try to load data from a Postgres DB.

My problem is, that always all rows where fetched. Even on large tables.
If I ran the same code against a MS SQL Database it loads on demand.
I am also using the lastest Postgres JDBC driver (8.2-505).
I tried the JDBC2 and JDBC4 version, with the same result.

My code looks like this:

quick.dbtable.DBTable dBTable1 = new quick.dbtable.DBTable();
this.add (dBTable1);
dBTable1.setConnection(parentDba.dbCon);
dBTable1.setSelectSql("SELECT * FROM debtable_assignments ORDER BY id");
dBTable1.createControlPanel();
try
{
dBTable1.refresh();
}
catch(SQLException e)
{
e.printStackTrace();
}

Thanks for your time,

Posted Monday, July 16, 2007 @ 13:46:23  

Unfortunately it doesn't helped.
I provided a (manually checked) RowCount clause with no success.

Here is the Debug Output.

QuickTable 2.0.5.27
Executing row count sql=SELECT COUNT (*) FROM caleventtable
Time taken to execute rowcount sql=31ms
Time taken to execute select sql=156ms
Initializing column properties. Any properties set using getColumn(i).setXXXX() will be lost. To retain old column properties use 'DBTable.useOldColumnProperties(boolean val)', if needed.
Database meta data information received from jdbc driver
Column 1: Name: caleventid
ReadOnly: false
Data Type: INTEGER
Precision: 10
Scale: 0
Signed: true

Column 2: Name: summary
ReadOnly: false
Data Type: VARCHAR
Length: 65

The PostgreSQL log shows this:

2007-07-16 20:53:32 LOG: connection received: host=127.0.0.1 port=1764
2007-07-16 20:53:32 LOG: connection authorized: user=crm database=crm_20070713
2007-07-16 20:53:32 LOG: statement: SELECT COUNT (*) FROM caleventtable
2007-07-16 20:53:32 LOG: statement: SELECT caleventid, summary FROM caleventtable ORDER BY caleventid
2007-07-16 20:53:32 LOG: statement: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2007-07-16 20:53:32 LOG: statement: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2

Thanks,

Posted Tuesday, July 17, 2007 @ 10:39:03  

I checked the server log from database.
The PostgreSQL log shows this:

2007-07-16 20:53:32 LOG: connection received: host=127.0.0.1 port=1764
2007-07-16 20:53:32 LOG: connection authorized: user=crm database=crm_20070713
2007-07-16 20:53:32 LOG: statement: SELECT COUNT (*) FROM caleventtable
2007-07-16 20:53:32 LOG: statement: SELECT caleventid, summary FROM caleventtable ORDER BY caleventid
2007-07-16 20:53:32 LOG: statement: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2007-07-16 20:53:32 LOG: statement: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2

Thanks,