Hibernate version:hibernate-2.0.3

Mapping documents:
<mapping resource="com/dascom/ssmn/entity/SsmnCancelNum.hbm.xml"/>

My hibernate.properties is :
hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username ssuser
hibernate.connection.password sspassword
hibernate.connection.url jdbc:oracle:thin:@192.168.91.188:1521:ora9



Code between sessionFactory.openSession() and session.close():

Session session = sessionFactory.openSession() ;
if (session == null) {
throw new DBException("fail to connect db");
}

int ilong,i;
Transaction tx = null;
SsmnCancelNum scancelnum = new SsmnCancelNum();
try {
tx = session.beginTransaction();

ilong = lcancelnum.size();
for (i = 0; i < ilong; i++) {
scancelnum = (SsmnCancelNum)lcancelnum.get(i);
session.save(scancelnum);
session.flush();
}

tx.commit();
}
catch (HibernateException he) {
System.out.println(he.toString());
}
finally {
try {
session.close();
}
catch (Exception e) {
throw new DAOException("session close error! " + e.toString());
}
}



Full stack trace of any exception that occurs:
No error,it should have been saved three records,but only saved the last record.


Name and version of the database you are using:
Oracle 9i


The generated SQL (show_sql=true):
only one Insert Sql.


Why? I cann't understand!!!

When you perform batch insert under Oracle it is good idea to read following post:

http://forum.hibernate.org/viewtopic.php?t=935468

I've had big problem with performance in Oracle 9i but I've solved - read post.

Read also:
http://blog.hibernate.org/cgi-bin/blosx ... batch.html

Regards

by the way in normal situation do not use flush and commit it slow down your system. It is enought to use commit (it also perform flush)
Remeber about configuration of ConnectionPool.

Thanks szymic1,I have worked out this question,thanks for your help.