Re: [jboss-user] [JDBC] Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar

Στις Wednesday 03 March 2010 10:54:53 ο/η Heikki Linnakangas έγραψε: As loglevel configuration property to org.postgresql.ds.common.BaseDataSource is not supported in the lastest driver, i made this patch (i attach it) against postgresql-jdbc-8.4-701.src, also i set in jboss <datasources> <xa-datasource> <jndi-name>pgsql</jndi-name> <use-java-context>true</use-java-context> <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> <xa-datasource-property name="ServerName">localhost</xa-datasource-property> <xa-datasource-property name="PortNumber">5432</xa-datasource-property> <xa-datasource-property name="DatabaseName">dynacom</xa-datasource-property> <xa-datasource-property name="User">postgres</xa-datasource-property> <xa-datasource-property name="Password">xxxx</xa-datasource-property> <xa-datasource-property name="Compatible">8.2</xa-datasource-property> <xa-datasource-property name="Loglevel">2</xa-datasource-property> <track-connection-by-tx/> <min-pool-size>1</min-pool-size> <max-pool-size>2</max-pool-size> <metadata> <type-mapping>PostgreSQL 8.0</type-mapping> </metadata> </xa-datasource> </datasources> But i dont see anything spectacular comming out of PostgreSQL logs. in postgresql.conf I have set client_min_messages = debug5 log_min_messages = debug5 however playing with <xa-datasource-property name="Loglevel"></xa-datasource-property> does not seem to change a thing. Am i missing something? -- Achilleas Mantzios