Problems with isolation levels in Java

[Jos� R�mulo El�as Contreras]

Hello:

       I have questions about sapdb transactions and isolation levels?

       I have an application running in Apache Tomcat over Linux and 
SAPDB. I open 100 connections when I run my application, and each 
connection has this Java code:

      return DriverManager.getConnection(databaseUrl + databaseName + 
"?user=" + databaseUser + "&password=" + databasePassword + 
"&timeout=0&isolation=" + java.sql.Connection.TRANSACTION_READ_COMMITTED);

      the problem is that when a transacion is in proccess 
(UNCOMMITTED), I can not read the table in which the first transaction 
is modified ONLY one row. What type of isolation level I can use to read 
and modify the table in which the transaction is modified the row?, I 
know that I can modify the row in which the transaction is modified.

       SAPDB locks the table when I modified only one row of this table?
       How Can I read and modify the rows that the transaction is NOT 
modified?
  
Thanks

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]