Hi
I've figured it out. After googling and googling and googling on the subject. I finally found a discussion on some forum that pointed me in the right direction. It lead me to organize my code like the following example
The method returns sql based on the sql passed to the database and data in the DB.
private String getGeneratedSql(String sql) throws Exception
{
logger.debug("Enter getGeneratedSql method.");
String result = null;
Connection conn = ds.getConnection();
try
{
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
try
{
stmt.setFetchSize(this.mFetchSize);
ResultSet rs = stmt.executeQuery(sql);
try
{
if (rs.first()) result = rs.getString(1);
else throw new Exception("Could not retrive generated sql.");
}
finally
{
rs.close();
}
}
finally
{
stmt.close();
}
}
finally
{
conn.close();
logger.debug("Exit getGeneratedSql method.");
}
return result;
}
What seems essential to avoid the "HouseKeeping" warning and what I cannot explain is that open/close has to happen within the same scope, i.e same method or compound statement.
Anyway, thanks to the discussion that pushed me in the right direction.
Best regards
Mads M Andersen