Bonjour,
OpenConcerto est-il compatible avec la version 10 de PostgreSQL ?
Je n'arrive pas à configurer le client. Lorsque je fais "tester la connexion" il me dit que la connexion n'a pas pu se faire. Pourtant, quand je regarde les connexions ouvertes sur la BDD OpenConcerto, il y en a des dizaines. Si je quitte le client ou le configurateur toutes ces connexion se ferment.
PGAdmin se connecte sans problème sur la BDD. J'ai créé l'utilisateur 'openconcerto' et la BDD 'OpenConcerto' en suivant la doc d'install. J'ai également injecté les tables à l'aide du fichier SQL via psql.
Voici l'erreur affichée qui est explicite :
UncaughtException on thread Thread[main,5,main]
java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:postgresql://******:55432/OpenConcerto
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[main,5,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:129)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:134)
at org.openconcerto.erp.config.Gestion$2.uncaughtException(Gestion.java:201)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.lang.Thread.dispatchUncaughtException(Unknown Source)
Caused by: java.lang.IllegalStateException: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:postgresql://*****:55432/OpenConcerto
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1011)
at org.openconcerto.sql.PropsConfiguration.getDirectory(PropsConfiguration.java:1136)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:314)
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:postgresql://******z:55432/OpenConcerto
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1007)
... 2 more
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:postgresql://*****:55432/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.getRawConnectionThrow(SQLDataSource.java:1376)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1394)
at org.openconcerto.sql.model.SQLDataSource._borrowConnection(SQLDataSource.java:1334)
at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1321)
at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1301)
at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:701)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:610)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:554)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1878)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1860)
at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:632)
at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:628)
at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:142)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:419)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:408)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:467)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:445)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:425)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:626)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:768)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1075)
at org.openconcerto.sql.PropsConfiguration.createRoot(PropsConfiguration.java:408)
at org.openconcerto.sql.PropsConfiguration.getRoot(PropsConfiguration.java:1051)
at org.openconcerto.sql.element.ConfSQLElement.<init>(ConfSQLElement.java:35)
at org.openconcerto.sql.element.ConfSQLElement.<init>(ConfSQLElement.java:30)
at org.openconcerto.task.config.ComptaBasePropsConfiguration.createDirectory(ComptaBasePropsConfiguration.java:183)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createDirectory(ComptaPropsConfiguration.java:788)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:245)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:1)
at org.openconcerto.sql.PropsConfiguration$Addable$1.call(PropsConfiguration.java:987)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1005)
... 2 more
Caused by: org.postgresql.util.PSQLException: Ce ResultSet est fermé.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2839)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1874)
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:37)
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:219)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1812)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:366)
at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:883)
at org.openconcerto.sql.model.SQLDataSource.setTransactionIsolation(SQLDataSource.java:1482)
at org.openconcerto.sql.model.SQLDataSource$4.makeObject(SQLDataSource.java:1589)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.openconcerto.sql.model.SQLDataSource.createPoolableConnectionFactory(SQLDataSource.java:1599)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1386)
... 32 more