DEBUG [SQL.log 324]
    select tblorgbase0_.SYSLINKFIELD as col_0_0_,
             tblorgbase0_.ORGANIZATION as col_1_0_,
             count(tblchemica1_.SYSLINKFIELD) as col_2_0_
    from EIS_DBA.TBLORGBASE tblorgbase0_, EIS_DBA.TBLCHEMICAL tblchemica1_
    where tblorgbase0_.SYSLINKFIELD=tblchemica1_.SYSFACCODE(+) and
              tblorgbase0_.ORGTYPE='Waste Generator' and
              tblorgbase0_.DEPARTMENT_SYSMASTER=?
    group by tblorgbase0_.SYSLINKFIELD , tblorgbase0_.ORGANIZATION

DEBUG [SQL.log 324]
    select tbldepartm0_.SYSLINKFIELD as SYSLINKF1_0_,
             tbldepartm0_.SYSRECNO as SYSRECNO82_0_,
             tbldepartm0_.NAME as NAME82_0_, tbldepartm0_.UPDATED as UPDATED82_0_
    from EIS_DBA.TBLDEPARTMENT tbldepartm0_
    where tbldepartm0_.SYSLINKFIELD=?

WARN  [JDBCExceptionReporter.logWarnings 48] SQL Warning: 17110, SQLState: null