Hi,

I'm trying to make a batch insert working in SQL Server but I see no way of accomplishing it..

I have a table in SQL Server like



and Hibernate mapping like


....

According to the batch insert tutorial Hibernate disables insert batching at the JDBC level transparently if you use an identity identifier generator.

So, I was thinking about other generator type, but I can't use an increment generator because I have a clustered key and it looks like I can't use an assigned one because I have IDENTITY(1,1) declared in SQL Server...

Could anybody give me some other options I can consider? Thanks a lot!

To do bulk inserts, you have to create the SQL directly. However, Hibernate does allow you to get access to the connection from the Hibernate session using the doWork method. You can see example code of how to do it here.

http://i4hq.com/116-gbulk-inserts-with-hibernate-and-sqlserver