Re: [eclipselink-dev] batch writing, Statement vs PreparedStatement batc

[Gordon Yorke <gordon.yorke@xxxxxxxxxx>]

No, currently there is no way to prevent the 'Dynamic SQL' / heterogeneous batching if batching is enabled.  Although in general, binding is enabled for the entire persistence unit and it would be difficult for users to turn binding off on a per query basis through the JPA APIs.
--Gordon

Goerler, Adrian wrote:

Hi,

 

the property

 

<property name="eclipselink.jdbc.batch-writing" value="JDBC"/>

 

 

seems to enable the parameterized prepared-statement batching as well heterogeneous statement-batching.

 

I am a bit reluctant to allow heterogeneous batching (on MaxDB) as the behaviour is a bit strange.

 

Is there a way to enable parameterized prepared-statement batching but to disable heterogeneous statement batching? E.g. could I switch off the heterogeneous batching in a database platform?

 

-Adrian

 

 

 

 

SAP AG

Dietmar-Hopp-Allee 16, 69190 Walldorf, Germany

 

Sitz der Gesellschaft/Registered Office: Walldorf, Germany

Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, John Schwarz, Peter Zencke

Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner

Registergericht/Commercial Register Mannheim No HRB 350269

 

 

_______________________________________________
eclipselink-dev mailing list
eclipselink-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-dev