Στις Wednesday 03 March 2010 10:54:53 ο/η Heikki Linnakangas έγραψε: > Achilleas Mantzios wrote: > > i'll try to make a test case, but i think now there is enuf material for > > anyone to make his own case, > > please ask whatever i may have missed, and thank you for your attention. > > If you can set logLevel to DEBUG (ie. loglevel=2 in connection string), > run the code, and send over the logs, that would help a lot. From that > we should see what exactly is the sequence of XA commands the JDBC > driver is receiving from JBoss. >
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? > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > -- Achilleas Mantzios
--- org/postgresql/ds/common/BaseDataSource.java.orig 2009-06-20 18:19:40.000000000 +0300 +++ org/postgresql/ds/common/BaseDataSource.java 2010-03-03 11:44:38.000000000 +0200 @@ -55,6 +55,7 @@ private String sslfactory; private boolean tcpKeepAlive = false; private String compatible; + private String loglevel; /** * Gets a connection to the PostgreSQL database. The database is identified by the @@ -168,6 +169,16 @@ this.compatible = compatible; } + public String getLoglevel() + { + return loglevel; + } + + public void setLoglevel(String compatible) + { + this.loglevel = loglevel; + } + /** * Gets the name of the PostgreSQL database, running on the server identified * by the serverName property. @@ -380,6 +391,9 @@ if (compatible != null) { sb.append("&compatible="+compatible); } + if (loglevel != null) { + sb.append("&loglevel="+loglevel); + } return sb.toString(); } @@ -425,6 +439,10 @@ { ref.add(new StringRefAddr("compatible", compatible)); } + if (loglevel != null) + { + ref.add(new StringRefAddr("loglevel", loglevel)); + } return ref; } @@ -444,6 +462,7 @@ out.writeObject(sslfactory); out.writeBoolean(tcpKeepAlive); out.writeObject(compatible); + out.writeObject(loglevel); } protected void readBaseObject(ObjectInputStream in) throws IOException, ClassNotFoundException @@ -461,6 +480,7 @@ sslfactory = (String)in.readObject(); tcpKeepAlive = in.readBoolean(); compatible = (String)in.readObject(); + loglevel = (String)in.readObject(); } }
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user