Java – batch insert using native SQL in Hibernate
•
Java
I want to use hibernate native SQL to insert records into the database The code is shown below
Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); String sqlInsert = "insert into sampletbl (name) values (?) "; for(String name : list){ session.createsqlQuery( sqlInsert ) .setParameter(1,name) .executeUpdate(); } tx.commit(); session.close();
The above code works normally I don't think this is the best way If so, please give me another possible way thank you
Solution
Hibernate has a batch processing function However, in the above example, I use native SQL. According to my observation, hibernate batch processing is not very effective for native SQL Yes, it does avoid out of memory errors, but it does not improve performance
Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); //get Connction from Session session.doWork(new Work() { @Override public void execute(Connection conn) throws sqlException { PreparedStatement pstmt = null; try{ String sqlInsert = "insert into sampletbl (name) values (?) "; pstmt = conn.prepareStatement(sqlInsert ); int i=0; for(String name : list){ pstmt .setString(1,name); pstmt .addBatch(); //20 : JDBC batch size if ( i % 20 == 0 ) { pstmt .executeBatch(); } i++; } pstmt .executeBatch(); } finally{ pstmt .close(); } } }); tx.commit(); session.close();
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
二维码