Hello!
I'm using a postgreSQL v8.0 running in an other server.
I'v set a value of 10 as a min pool in my postgre-ds.xml.
Then, running ManageEngine Application Manager 7.
AppManager show 0 pooled connection for my database but 5 for DefaultDS : Hypersonic Database.
Here's a portion of postgre-ds.xml
<min-pool-size>5</min-pool-size> <max-pool-size>150</max-pool-size> <idle-timeout-minutes>20</idle-timeout-minutes> <!-- sql to call when connection is created--> <new-connection-sql>SELECT 1</new-connection-sql> <!-- sql to call on an existing pooled connection when it is obtained from pool --> <check-valid-connection-sql>SELECT 1</check-valid-connection-sql> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata>
09:06:37,687 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=Herimiaina/67, BranchQual=, localId=67] errorCode=XA_UNKNOWN(0) org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported )) at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:901) at org.jboss.tm.TransactionImpl$Resource.startResource(TransactionImpl.java:2043) at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:563)