Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 2F12E632B8A
	for <pgsql-jdbc-postgresql.org@mail.postgresql.org>;
	Wed,  3 Mar 2010 06:30:57 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 86815-06 for
	<pgsql-jdbc-postgresql.org@mail.postgresql.org>;
	Wed,  3 Mar 2010 10:30:46 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from exprod7og114.obsmtp.com (exprod7og114.obsmtp.com [64.18.2.215])
	by mail.postgresql.org (Postfix) with SMTP id F1ACD632B31
	for <pgsql-jdbc@postgresql.org>; Wed,  3 Mar 2010 06:30:45 -0400 (AST)
Received: from source ([74.125.78.24]) by exprod7ob114.postini.com
	([64.18.6.12]) with SMTP
	ID DSNKS446VNHmeWLa3EpOx5rfOpr4At0ar9U2@postini.com;
	Wed, 03 Mar 2010 02:30:45 PST
Received: by ey-out-2122.google.com with SMTP id 4so208589eyf.41
	for <pgsql-jdbc@postgresql.org>; Wed, 03 Mar 2010 02:30:43 -0800 (PST)
Received: by 10.213.104.88 with SMTP id n24mr2092013ebo.22.1267612241793;
	Wed, 03 Mar 2010 02:30:41 -0800 (PST)
Received: from ?192.168.1.117? ([88.195.103.165])
	by mx.google.com with ESMTPS id 7sm16361500eyb.33.2010.03.03.02.30.38
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Wed, 03 Mar 2010 02:30:40 -0800 (PST)
Message-ID: <4B8E3A4D.9000809@enterprisedb.com>
Date: Wed, 03 Mar 2010 12:30:37 +0200
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Organization: EnterpriseDB
User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706)
MIME-Version: 1.0
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
CC: pgsql-jdbc@postgresql.org, jboss-user@lists.jboss.org
Subject: Re: Very Dangerous bug in XA connection pooling and SL EJBs
	with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar
References: <201003011731.15724.achill@matrix.gatewaynet.com>
	<201003031034.44077.achill@matrix.gatewaynet.com>
	<4B8E23DD.6040101@enterprisedb.com>
	<201003031209.41358.achill@matrix.gatewaynet.com>
In-Reply-To: <201003031209.41358.achill@matrix.gatewaynet.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/10
X-Sequence-Number: 20350

Achilleas Mantzios wrote:
> Στις 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

The extra logs should go somewhere in the client side, in one of the
jboss log files. If you can't find it, you can do something like this in
the application to redirect it to a file:

        java.io.Writer output = new
java.io.FileWriter("/tmp/postgresql-jdbc.debug.txt", true);
        java.sql.DriverManager.setLogWriter(new
java.io.PrintWriter(output,true));


> however playing with <xa-datasource-property name="Loglevel"></xa-datasource-property> does not seem to change a thing.
> Am i missing something?

Not sure why that's not working, but here's one way of setting loglevel:

1. Create file "org/postgresql/driverconfig.properties" with line
"loglevel=2" in it:
   echo "loglevel=2" > org/postgresql/driverconfig.properties
2. Add file to the driver jar:
   jar uvf postgresql.jar org/postgresql/driverconfig.properties

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com