Re: JDBC: Connection object's Autocommit value for SELECT

From: <davide_speed_at_davidebianchi.net>
Date: 15 Apr 2002 17:46:45 GMT
Message-ID: <a9f3m5$2j2df$6@ID-18487.news.dfncis.de>

In comp.lang.java.databases Andre van Winssen <andrew01_at_xs4all.nl> wrote:
> a lot of commits even when our webapplication does mainly SELECTs.

Well, actually no. Oracle does not hold locks if you perform a select, so the commit is just ignored.

> Anybody seen this before?

Yes, that means that you have to less rollback segments, or they are too small.

> Why not always change the default
> setting for autocommit to false when running against Oracle databases
> and make sure commits are being done explicitely after DML statements?

Why not using Stored Procedure and forget about DML statements at all ? You DO have an Oracle Db ? Then use it!

Davide Received on Mon Apr 15 2002 - 12:46:45 CDT