Discussion :

[hichem_enis]

when we are using session.createSQLQuery() in multi thread environment. We are getting NullPointerException. Please see the below stack trace.

11:29:31.976 ERROR invoke ApplicationDispatcher.java 704 Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.commons.collections.SequencedHashMap.removeEntry(SequencedHashMap.java:253)
at org.apache.commons.collections.SequencedHashMap.removeImpl(SequencedHashMap.java:511)
at org.apache.commons.collections.SequencedHashMap.remove(SequencedHashMap.java:498)
at org.apache.commons.collections.LRUMap.get(LRUMap.java:131)
at org.hibernate.util.SimpleMRUCache.get(SimpleMRUCache.java:36)
at org.hibernate.engine.query.QueryPlanCache.getSQLParameterMetadata(QueryPlanCache.java:49)
at org.hibernate.impl.AbstractSessionImpl.createSQLQuery(AbstractSessionImpl.java:124)
at org.hibernate.impl.SessionImpl.createSQLQuery(SessionImpl.java:1608)

[tchize_]

Un objet Session hibernate ne dois *pas* être partagé entre plusieurs threads, tu dois faire un objet session par Thread. (au fait, t'es dans le mauvais forum là)