Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Fri, 21 Oct 2005 14:27:50 +0200
From: Roy Lyseng <Roy.Lyseng@Sun.COM>
Subject: Re: Question about setTransactionIsolation in network client driver
To: derby-dev@db.apache.org
Message-id: <4358DEC6.9040103@sun.com>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 8BIT
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.2)
 Gecko/20030208 Netscape/7.02
References: <58ed70f50510201817h1a755a0s6405a36b76f3ebb9@mail.gmail.com>
 <4358DA74.9060406@sun.com>


Andreas Korneliussen wrote:
> Deepa Remesh wrote:
> 
>> When autocommit is set to false, a call to setTransactionIsolation
>> using client driver does not end the transaction when the method
>> exits. When a close() is called on the conection, it throws an
>> exception.
>>
>> Running the code below:
>>
>>     conn.setAutoCommit(false);
>>     conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
>>     try{
>>         conn.close();
>>     }catch(SQLException se){
>>         System.out.println("Got exception when closing the connection");
>>         se.printStackTrace();
>>     }
>>
>> with client driver gives:
>> Got exception when closing the connection
>> org.apache.derby.client.am.SqlException: java.sql.Connection.close()
>> requested while a transaction is in progress on the connection.The
>> transaction remains active, and the connection cannot be closed.
>>     
>> with embedded driver, it works okay and does not throw any exception.
>>
>> This looks like a bug to me. Can someone please confirm? If I don't
>> hear otherwise, I'll open a JIRA issue tommorow.
>>
>> Thanks Kathey for bringing this up.
>>
> Hi,
> Yes, this looks like a bug in the client driver. A call to 
> setTransactionIsolation() should cause the current transaction to commit.

Nope. Det er ikke tillatt � sette transaction isolation inne i en 
transaksjon, men det � sette transaction isolation skal heller ikke �pne 
en transaksjon...

Roy