Hi all!

I'm a testing one method with multiple threads which is saving simple objetcs.

My session factory is declared final and both session and transaction are gathered in the following class:
[code]
public class SessionOpale {

private static final Log LOG = LogFactory.getLog (SessionOpale.class) ;

private static SessionFactory sessionFactory ;

private Session session ;

private Transaction transaction ;

public SessionOpale() {
}

public void initSession()
throws BaseDeDonneesException {
// Load Configuration and build SessionFactory
sessionFactory = SessionFactoryOpale.getSessionFactory() ;
}

public void openSession()
throws BaseDeDonneesException {
try {
InitialContext ctx=new InitialContext();
DataSource dataSource=(DataSource)ctx.lookup("jdbc/opale");
Connection connection= dataSource.getConnection();
session = sessionFactory.openSession(connection) ;
}
/*catch (HibernateException e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}*/
catch (Exception e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}
}


public void closeSession()
throws BaseDeDonneesException {
try {
session.close() ;
}
catch (HibernateException e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}
catch (Exception e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}
}


public void beginTransaction()
throws BaseDeDonneesException {
try {
transaction = session.beginTransaction() ;
}
catch (HibernateException e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}
catch (Exception e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
// Remonte l'exception
throw new BaseDeDonneesException (ConstantesException.ERREUR_TECHNIQUE,
ConstantesException.TYPE_CRASH) ;
}
}


public void endTransaction (boolean commit)
throws BaseDeDonneesException {
try {
// Commit la transaction si besoin
if (commit) {
session.flush() ;
transaction.commit() ;
}
else {
transaction.rollback() ;
}
}
catch (HibernateException e) {
// Log l'erreur
LOG.error(ConstantesException.ERREUR_HIBERNATE + " : " + e.getMessage()) ;
try {
// On roll-back la transaction pour

can you tell me what is said about the default connection pool in the reference guide?

http://www.hibernate.org/hib_docs/refer ... ernatejdbc

Hello Anthony

Yes you are right, my properties file was not the last one I tried to use.
But with c3p0, the problem is still the same and I can't fix it.

Sorry for this leak of information :)

can you show c3p0 configuration?

No pb.
I give you the file and the stack trace.
I hope this could help.

[code]
java.sql.SQLException: ORA-02391: limite de SESSIONS_PER_USER simultan

change
hibernate.c3p0.idle_test_period=15

to
hibernate.c3p0.idle_test_period=1500 (each opened connection will be checked every 1500 seconds) 15 is dangerous for your "test" about performance.

java.sql.SQLException: ORA-02391: limite de SESSIONS_PER_USER simultan

Thanks a lot for this precision.
My parameter was wrong and the pool was not well managed.