Hi,

i am a little stuck. I hope it is not a PostGresql Issue.

(postgresql 7.3).

I've got an error message, just after my connection. I am supposed to retrieve an user identified by his username, just after that.

Here are some logs :


INFO - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
DEBUG - total checked-out connections: 0
DEBUG - opening new JDBC connection
DEBUG - created connection to: jdbc:postgresql://192.168.94.17:5432/entrepot, Isolation Level: 2
DEBUG - returning connection to pool, pool size: 1
DEBUG - Start expire sessions StandardManager at 1111163458520 sessioncount 1
DEBUG - End expire sessions StandardManager processingTime 1 expired sessions: 0
INFO - cleaning up connection pool: jdbc:postgresql://192.168.94.17:5432/entrepot
DEBUG - Start expire sessions StandardManager at 1111163518968 sessioncount 1
DEBUG - End expire sessions StandardManager processingTime 0 expired sessions: 0
ERROR - "Servlet.service()" pour la servlet default a généré une exception
java.lang.AbstractMethodError: org.postgresql.jdbc1.Jdbc1DatabaseMetaData.supportsResultSetType(I)Z
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:87)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1172)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:803)
at com.adventec.utils.hibernate.ConnectionFactory.<init>(ConnectionFactory.java:65)
at com.adventec.utils.hibernate.ConnectionFactory.getInstance(ConnectionFactory.java:112)
at com.adventec.mvc.modele.dao.DaoUtilisateur.getUtilisateur(DaoUtilisateur.java:58)
at com.adventec.mvc.modele.bo.BoUtilisateur.authenticate(BoUtilisateur.java:42)
at com.adventec.utils.security.DBEntrepotRealm.authenticate(DBEntrepotRealm.java:61)
at org.securityfilter.authenticator.FormAuthenticator.processLogin(FormAuthenticator.java:178)
at org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:138)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)

Here is my hibernate.cfg.xml :


<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>

<session-factory>

<!-- fichiers de mapping -->
<mapping resource="DobUtilisateur.hbm.xml"/>

</session-factory>

</hibernate-configuration>

Here is my hibernate.properties (postgres use the trust method) :

hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://192.168.94.17:5432/entrepot
hibernate.connection.username=antoine
hibernate.connection.pool_size=2
hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect

Just in case, here is my BobUtilisateur.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="com.adventec.mvc.modele.dob.DobUtilisateur" table="utilisateur">

<id name="login" type="string" unsaved-value="null" >
<column name="login" sql-type="char(20)" not-null="true"/>
<generator class="assigned"/>
</id>

<property name="password">
<column name="password" length="20" not-null="true"/>
</property>

<property name="prenom">
<column name="prenom" length="20" not-null="true"/>
</property>

<property name="nom">
<column name="nom" length="20" not-null="true"/>
</property>

</class>

</hibernate-mapping>

Thx in advance.

Regards

Antoine Tissier

thereis a typo in my message : it is obviously DobUtilisateur.hbm.xml