Hello,

I have been searching for approaches to improve inserting performance with Hibernate in the past several days, Here are some suggestions I found:



Since I am pretty new to Hibernate, I would like to ask help on following issues? Examples and direction pointing are highly appreciated.


1) How to configure a connection pool other than the default one?
2) What's the best and easiest approach to generate ID without using those default ID generators? ( I am using Oracle and Hibernate, for each row, it seems that a select statement is generated to get the next id when I use the sequence ID generator)


Thanks so much and have a great day,

Jiao

To configure a connection pool define hibernate.connection.provider_class. For example:

Take a look at http://www.hibernate.org/hib_docs/v3/re ... ernatejdbc for more information.
But note that things can be quite different if you use an application server.

Concerning Id generation: you can use other generators like hilo or seqhilo. Take a look at http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#mapping-declaration-id-generator

Erik