Posted Thursday, October 11, 2007 @ 13:51:40
Its a database. Here is the debug info below but I just had another idea. Is it because the column is the product of a db math function instead of just a pure column itself? Here is the sql:
qTable.setSelectSql(
" SELECT chan, AVG(channel_value - reference_value) as AVERAGE, " +
" MAX(channel_value - reference_value) as MAX, " +
" MIN(channel_value - reference_value) as MIN, " +
" MIN(channel_value) as MIN_CHANNEL, " +
" MAX(channel_value) as MAX_CHANNEL, " +
" MIN(reference_value) as MIN_REF, " +
" MAX(reference_value) as MAX_REF " +
" FROM pyronometer_monitor_data " +
" GROUP BY chan ");
Unable to automatically create rowcount sql. Optionally you can provide rowcount sql using DBTable.setRowCountSql(String rowCountSql). Refer api for setRowCountSql() for more info.
Database meta data information received from jdbc driver
Column 1: Name: chan
ReadOnly: false
Data Type: INTEGER
Precision: 10
Scale: 0
Signed: true
Column 2: Name: average
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 3: Name: max
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 4: Name: min
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 5: Name: min_channel
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 6: Name: max_channel
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 7: Name: min_ref
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true
Column 8: Name: max_ref
ReadOnly: false
Data Type: DOUBLE
Precision: 17
Scale: 17
Signed: true