I'm trying to access a Progress 9.1E database using the Progress-supplied jdbc driver in a Java application. I would like to execute simple queries without starting a transaction or locking any records. Is this possible?
I see the following in PROMON when I run queries: A simple query like 'SELECT * from table_name' starts a transaction and locks records. To avoid locking, I have to BOTH make a call to the JDBC API to set the isolation level to READ UNCOMMITTED for the session AND add the 'NOLOCK' phrase to my 'from' clause ('SELECT * from table_name NOLOCK'). But even this starts a transaction, which I would like to avoid.
Finally, I cannot get the 'NOLOCK' phrase to work with more than one table, using all kinds of explicit and implicit joins in my SQL. All help or suggestions gratefully appreciated.
Tim
I see the following in PROMON when I run queries: A simple query like 'SELECT * from table_name' starts a transaction and locks records. To avoid locking, I have to BOTH make a call to the JDBC API to set the isolation level to READ UNCOMMITTED for the session AND add the 'NOLOCK' phrase to my 'from' clause ('SELECT * from table_name NOLOCK'). But even this starts a transaction, which I would like to avoid.
Finally, I cannot get the 'NOLOCK' phrase to work with more than one table, using all kinds of explicit and implicit joins in my SQL. All help or suggestions gratefully appreciated.
Tim