I have an application where I wish to let people type their own 'read-type'
querys (i.e. restrict querys to selects only) but prevent them from doing
any type of updates or table modification.
If I use the Statement.executeQuery(String) method this will throw
exceptions when attempting any type of update e.g delete, alter table, drop
Catching these exceptions and doing Connection.rollback() prevents deletes
and drops taking effect but alter statements still take effect.
My Statement is of type forward-only, concur-read-only. Does this have any
effect on the 'writability' of the executeQuery method ?
Are there any ways to guarantee that a Statement sent to the
executeQuery(String) method will not modify any data ?
thanks in advance,