This also sounds like the kind of thing that should be in a finally
block in order to guarantee the close will execute even after an
exception.
org.ofbiz.core.entity.jdbc.SQLProcessor sqlProcessor = null;
try {
sqlProcessor = new org.ofbiz.core.entity.jdbc.SQLProcessor(
/*datasource*/ );
sqlProcessor.prepareStatement( "SELECT whatever FROM wherever ... ");
sqlProcessor.executeQuery();
java.sql.ResultSet rs = sqlProcessor.getResultSet();
// something useful ...
} finally {
if(null != sqlProcessor){
sqlProcessor.close(); // just typical jdbc connection hygiene
}
}
--
James McGill
Able Engineering
