benchbase
benchbase copied to clipboard
Sqlite missing features for ResourceStresser
sqlite doesn't support
- explicit "lock table"
- sleep operations in its SQL syntax.
The former may possible with a BEGIN EXCLUSIVE TRANSACTION; {stmt}; COMMIT TRANSACTION;
style operation, however the substitution logic for expanding the ??
syntax in setSQL()
in SQLUtil.java
needs fixing.
The sleep logic may be possible by introducing a callback function, but that's specific to the Sqlite driver class which would require some custom code that's only loaded with that profile or reflection to do so dynamically.
See Also: #268 (especially the resourcestresser/ddl-sqlite.sql
file for additional links and details).