private String determineDialectSpecificQueryText(String dialect){
  if (isPostgres()) {
    return "select dbid, BIT_LENGTH(filedata) from note";
  }
 else   if (isOracle()) {
    return "create table " + ORACLE_TEMP_TABLE_NAME + " as select dbid, to_lob(filedata) obj from note";
  }
 else   if (isDerby()) {
    return "select dbid, length(filedata) from note";
  }
 else {
    return "";
  }
}

private String determineDialectSpecificQueryText ( String dialect ) { if ( isPostgres ( ) ) { return "select dbid, BIT_LENGTH(filedata) from note" ; } else if ( isOracle ( ) ) { return "create table " + ORACLE_TEMP_TABLE_NAME + " as select dbid, to_lob(filedata) obj from note" ; } else if ( isDerby ( ) ) { return "select dbid, length(filedata) from note" ; } else { return "" ; } }
gets filesize of filedata selecting query dependent on used database dialect
