Consultor Eletrônico



Kbase P76033: Hibernate WARN BatcherImpl:147 - exception clearing maxRows/queryTimeout
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   14/04/2004
Status: Unverified

FACT(s) (Environment):

Progress 9.1D

FACT(s) (Environment):

OpenEdge 10.0A

SYMPTOM(s):

Hibernate WARN BatcherImpl:147 - exception clearing maxRows/queryTimeout

java.sql.SQLException: [JDBC Progress Driver]:251

at com.progress.sql.jdbc.JdbcProgressStatement.getQueryTimeout

CAUSE:

Statement.getQueryTimeout optional feature is not implemented within the JDBC Progress Driver

FIX:

Remove the Statement.getQueryTimeout from the code or run it inside a try catch
block to catch the exception.
Example code:
String stemp = "SELECT * FROM customer";
Statement statement = null;
try {
statement = con.createStatement();
System.out.println("QueryTimeOut: " + statement.getQueryTimeout());
} catch (Exception e) {e.printStackTrace();}
if (statement != null)
{
try
{

ResultSet rs = statement.executeQuery(stemp);
stemp = null;
while (rs.next())
{
stemp = rs.getString(2);
System.out.println(stemp);
} // end while
}
catch (Exception e) {e.printStackTrace();}
} //end if