jdbc « Batch « JPA Q&A





1. Is it OK to use both JPA (for normal CRUDs) and JDBC (for batch update & call stored proc) in the same project    stackoverflow.com

I am using JPA/Hibernate to call simple CRUD queries (create, update, findByXAndYAndZ...). However, as I know, JPA doesn't support well on calling stored procedures and batch insert/update, so I consider using ...

2. JDBC batch update    forum.hibernate.org

Code: (0 ms) [http-8080-5] WARN : org.hibernate.util.JDBCExceptionReporter#warn : SQL Error: 1054, SQLState: 42S22 (0 ms) [http-8080-5] ERROR: org.hibernate.util.JDBCExceptionReporter#error : Unknown column 'NaN' in 'field list' (16 ms) [http-8080-5] ERROR: org.hibernate.event.def.AbstractFlushingEventListener#error : Could not synchronize database state with session org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ...

3. how can I tell hibernate not to do JDBC Batch Update?    forum.hibernate.org

hi all, I have a setter method of a property like; setEquipments (List equipments) { if ( equipments instanceof net.sf.hibernate.collection.Bag) this.equipments= new ArrayList(equipments); else this.equipments= equipments; } I need to convert to the "bag" to a arrayList because I serialize the data via XStream that cant deserialize the file where list classes are net.sf.hibernate.collection.Bag.( they need to be ArrayList) I cant ...

4. Hibernate JDBC batch update    forum.hibernate.org

Hi there, we are working on an application with about 150 entities and a class hirachie where a certain amount of different "Dokuments" are mapped to a "Table per Class" - DB mapping. In one special case we have to do a batchupdate like the code below. I set the hibernate.jdbc.batch_size to 50 to use the advantage of JDBC batching. My ...

5. JDBC Batching with multiple statements    forum.hibernate.org

Hibernate version: 3.1.2 Name and version of the database you are using: Oracle 10g A little background: We would like to do batching on inserts. We find this works terrific in our app as long as we are processing the same sql statement consecutively. However, if we are trying to use batching while inserting two different objects at the same time, ...

6. StatelessSession and batch JDBC inserts    forum.hibernate.org

I'm using Hibernate 3.2 and StatelessSession interface. I set the jdbc batch size to 50. In a for loop, I insert objects to the Oracle database. My question is, does the StatelessSession interface support JDBC batch processing? I read the documentation about batch processing and the example given there only used the regular Session interface. If I use the StatelessSession, will ...