Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "OJB Developers List" <ojb-dev@db.apache.org>
Message-ID: <415BEB73.2070705@apache.org>
Date: Thu, 30 Sep 2004 13:18:11 +0200
From: Armin Waibel <arminw@apache.org>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: OJB Developers List <ojb-dev@db.apache.org>
Subject: Re: [OJB1.1] New Batch handling and Oracle
References: <414FF153.4000505@apache.org> <415BE780.1000107@apache.org>
In-Reply-To: <415BE780.1000107@apache.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

 > Since it is impossible to mix JDBC-batching and "Oracle-style batching"
 > I think OJB 1.1 should go for the JDBC-method to enable a consistent
 > batching-model across all platforms. It's also nice to keep the platform
 > interface small and clean.

ok, thanks Martin!
Agree with you.
Could you cleanup the Oracle platform classes and remove the 
superfluously three methods in Platform class?
I don't have the heart to modify the oracle specific classes ;-)

regards,
Armin

Martin Kal�n wrote:

> Armin Waibel wrote:
> 
>> currently the new OJB1.1 batch handling completely ignore the three 
>> methods introduced in Platform interface
>>
>>     public void beforeBatch(PreparedStatement stmt) throws 
>> PlatformException;
>>     public void addBatch(PreparedStatement stmt) throws 
>> PlatformException;
>>     public int[] executeBatch(PreparedStatement stmt) throws 
>> PlatformException;
>>
>> to support an Oracle specific batch handling. Do we need these 
>> specific callback methods for Oracle with new OJB batch package too, 
>> does Oracle not support the standard batch behavior for >=JDBC2.0?
> 
> 
> Quotes from Oracle's technet on these issues (snippets from 
> http://www.oracle.com/technology//products/oracle9i/daily/jun07.html):
> 
> * Standard Update Batching (explicit model)
> Recommended when code portability across different database and JDBC 
> drivers is a higher priority than performance.
> 
> * Oracle Update Batching (implicit and faster model)
> Oracle update batching is usually faster than the standard update 
> batching but only supports PreparedStatement.
> 
> 
> Since it is impossible to mix JDBC-batching and "Oracle-style batching" 
> I think OJB 1.1 should go for the JDBC-method to enable a consistent 
> batching-model across all platforms. It's also nice to keep the platform 
> interface small and clean.
> 
> Regards,
>  Martin
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org