Oracle queries are going failed
Database Subsetter and Relational Data Browser
Brought to you by:
rwisser
Menu
▾
▴
#39 Oracle queries are going failed
Hello I'm using executing 'SELECT' queries using data browser with some timestamps 'WHERE COL1 >= TIMESTAMP '1947-01-01 00:00:00.000000'
AND COL1 <= TIMESTAMP '1947-01-01 00:00:00.000000'';
- in such case JAILER 8.7.3 looked to be freezed. I had to kill the java process each time.
DB engine - Oracle. Alternative db tools (like dBeaver) work fine.
Discussion
Anonymous
Hi,
Do you find any error messages in the files "sql.log" or "jailer.log"?
Does this happen in the Dektop or in the SQL Console?
Is it possible for you to take a thread dump when the java process appears frozen? That would be helpful.
https://dzone.com/articles/how-to-take-thread-dumps-7-options
Fixed in release 8.7.4. Please have a try.
Fixed, Thank you.