Can I execute SQL statements directly in a JDO environment?
Posted
by Carl Rosenberger
on Stack Overflow
See other posts from Stack Overflow
or by Carl Rosenberger
Published on 2010-06-13T12:44:24Z
Indexed on
2010/06/13
12:52 UTC
Read the original article
Hit count: 314
I am using Datanucleus JDO on top of HSqlDb.
I would like to execute the following SQL statement to tell HsqlDb to set the write delay to 0:
"SET WRITE_DELAY 0"
Is there a way I can do this from a JDO PersistenceManager or a PersistenceManagerFactory?
On a sidenote: I have tried to modify write_delay by using the following connection URL: jdbc:hsqldb:file:data/hsqldb/dbbench;write_delay=false
It didn't work. I debugged the HsqlDb sources and I could still see the write delay being set to 10 seconds.
© Stack Overflow or respective owner