Hi, I have a static table that should be read only. In order for this table never to be locked, I coded: myConnection.prepareStatement(thePreparedSQLStmt, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); Is this the correct way to prevent the table ever be locked? Thanks in advance.
Where do you want your table to read only? Database level or application level?
Joined: Oct 15, 2002
It would be useful to know both - at database level and application level. I noticed that you can do setReadOnly with a connection. But I am using the same connection to write to other tables. I am using Microsoft SQL server. I can't find any property in the database in which I can make the table read-only. Thanks!
do not give update/insert/delete access for that table to IDs used to access the datebase obviously it would be best to seperate the read only tables into a seperate tablespace from the tables which are being updated. Dan