Hello experts,

how can I set a time-out for persisting an object ?

In my example object "reqInvoice" shall be persisted into database. If table is locked in DB insert/update will wait until table is unlocked. Unfortunately I don't want to wait years. How can I set a time-out ?



Br,

Dennis

Simply use: yourObject.setQueryTimeout(300);

---------
Info:

void java.sql.Statement.setQueryTimeout(int seconds) throws SQLException

setQueryTimeout
public void setQueryTimeout(int seconds)
throws SQLException
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds. If the limit is exceeded, an SQLException is thrown.

Parameters:
seconds - the new query timeout limit in seconds; zero means there is no limit
Throws:
SQLException - if a database access error occurs or the condition seconds >= 0 is not satisfied
See Also:
getQueryTimeout()

Simply use: yourObject.setQueryTimeout(300);

---------
Info:

void java.sql.Statement.setQueryTimeout(int seconds) throws SQLException

setQueryTimeout
public void setQueryTimeout(int seconds)
throws SQLException
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds. If the limit is exceeded, an SQLException is thrown.

Parameters:
seconds - the new query timeout limit in seconds; zero means there is no limit
Throws:
SQLException - if a database access error occurs or the condition seconds >= 0 is not satisfied
See Also:
getQueryTimeout()

Hi,

for using void java.sql.Statement.setQueryTimeout(int seconds) throws SQLException I would have need to
create a statement. Actually I don't want to do that, but work with my persisting java object using hibernate.

Any idea about that ?

Br,

Dennis

Alright, you can try setTimeOut() method, it's all in Hibernate documentation. You need to dip or search a little more. Below is the sample code, hope it help.

Session sess = factory.openSession();
try {
//set transaction timeout to 3 seconds
sess.getTransaction().setTimeout(3);
sess.getTransaction().begin();

// do some work
...

sess.getTransaction().commit()
}
catch (RuntimeException e) {
sess.getTransaction().rollback();
throw e; // or display error message
}
finally {
sess.close();
}