java.sql.Statement.setQueryTimeout(int) should do the trick.
On 4/19/22 3:30 AM, Marco Ferretti wrote:
Hi all, I am trying to simulate a query timeout in a stored procedure by simply adding a delay in my (test) jar. I then am launching the stored procedure in my java code via JPA and try to set a timeout hint by adding .setHint("javax.persistence.query.timeout", milliseconds) but I am not able to register a timeout. I am wondering if there is some derby property or jdbc property I should use to activate such behavior. I have tried to google for it but I am having extremely bad results... but according to this (https://docs.oracle.com/cd/E25178_01/apirefs.1111/e13952/pagehelp/J2EEkodojdbcconfdescriptorDerbyDictionaryBeantitle.html) I have to activate it somehow. Does Derby supports query timeout at all? If so, can you please point me to some references ? Thanks in advance for any help, Marco