Return-Path: 
 <user-return-11746-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 70902 invoked from network); 15 Oct 2008 18:39:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 15 Oct 2008 18:39:25 -0000
Received: (qmail 2713 invoked by uid 500); 15 Oct 2008 18:39:25 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 2675 invoked by uid 500); 15 Oct 2008 18:39:25 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 2663 invoked by uid 99); 15 Oct 2008 18:39:25 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Oct 2008 11:39:25 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of mrgrimba@gmail.com designates
 72.14.220.159 as permitted sender)
Received: from [72.14.220.159] (HELO fg-out-1718.google.com) (72.14.220.159)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Oct 2008 18:38:18 +0000
Received: by fg-out-1718.google.com with SMTP id l27so2109484fgb.27
        for <user@geronimo.apache.org>; Wed, 15 Oct 2008 11:38:45 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type:references;
        bh=m4eX+pgAQWDF24r4YDBEycAlt0/Z3WsdM83IXwin7TA=;
        b=UU95pdIbzdnFvhEapk3uiTcHhJiU46FEqNMr41wKPwZPLokethl44Si80NIjL16eE5
         GgpJyuuAOsOAvwZEyx2jFzKJQru57zu+vj/lAG8I+mtTk9Q3/CpLGMW8H25W5FMv2xk2
         lTdUs5XNVFISs9u7/uozXDMFVBfTv50HrS1zY=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=eaI4r4sL71n9RlHzP5IqRxM0cl9Rr1BZNkRTb4HAUsG8YvBQc8TbY7Dj8Zq14UAI6N
         YUAu50KsCJL6ba+C0Jq8lbdRYowcuQjAIflmU1cXiKDkgmoYkYd43dhwXTA5HD+66V3o
         j3+GfoOcnKmt63TAnkMNhbxXEnFa5zPAiFTYk=
Received: by 10.187.190.6 with SMTP id s6mr150157fap.51.1224095925340;
        Wed, 15 Oct 2008 11:38:45 -0700 (PDT)
Received: by 10.187.177.9 with HTTP; Wed, 15 Oct 2008 11:38:45 -0700 (PDT)
Message-ID: <aac8e7e40810151138t5b0f91fo374e0bdf39f8573e@mail.gmail.com>
Date: Wed, 15 Oct 2008 15:38:45 -0300
From: "Rodrigo Baeza O" <mrgrimba@gmail.com>
To: user@geronimo.apache.org
Subject: Re: NO inserted BBDD openJPA
In-Reply-To: <E8E76C21-D9FE-4B19-A082-63AC09ADAAAE@yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_38031_16806368.1224095925324"
References: <aac8e7e40810150638i2711a6e1tb8f137f7757b9fb3@mail.gmail.com>
	 <E8E76C21-D9FE-4B19-A082-63AC09ADAAAE@yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_38031_16806368.1224095925324
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

David,
   Thank you very much for help, the problem in this pool of connections,
add the configuration file in the pool and deployer in the console. and
everything ok.
the file is so ...

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
    <dep:environment xmlns:dep="
http://geronimo.apache.org/xml/ns/deployment-1.2">
        <dep:moduleId>
            <dep:groupId>console.dbpool</dep:groupId>
            <dep:artifactId>actividades</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>rar</dep:type>
        </dep:moduleId>
        <dep:dependencies>
            <dep:dependency>
                <dep:groupId>oracle</dep:groupId>
                <dep:artifactId>oracle</dep:artifactId>
                <dep:version>1.4</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>

<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>actividades</name>
             <config-property-setting
name="CommitBeforeAutocommit">true</config-property-setting>
                    <config-property-setting
name="Password">mvi</config-property-setting>
                    <config-property-setting
name="Driver">oracle.jdbc.OracleDriver</config-property-setting>
                    <config-property-setting
name="UserName">salfa</config-property-setting>
                    <config-property-setting
name="ConnectionURL">jdbc:oracle:thin:@127.0.0.1:1521
:XE</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>2</max-size>
                            <min-size>1</min-size>

<blocking-timeout-milliseconds>100</blocking-timeout-milliseconds>
                            <idle-timeout-minutes>1</idle-timeout-minutes>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
</connector>
I'm in chile. it seems that I am the only one who occupy geronimo .... :-)
thanks.

2008/10/15 David Jencks <david_jencks@yahoo.com>

> I think you are using a non-jdbc-spec-compliant driver such as (IIRC)
> oracle that does not commit automatically when setAutocommit(true) is
> called.  There's a commitOnAutocommit config-property you can set in the
> datasource plan for the generic tranql adapter to have tranql call commit()
> before setAutocommit(true).
>
> If you need more information please tell us which database you are using,
> which tranql adapter you are using, and show the datasource plan.
>
> thanks
> david jencks
>
>
> On Oct 15, 2008, at 6:38 AM, Rodrigo Baeza O wrote:
>
>  Hello,
>>   I have a problem, when you insert a record in Geronimo 2.1.2, occupying
>> pool of connections and openJPA for persistence.
>> NO inserted into the databases at the time but when the server is down.
>> DO NOT send error, not only records in the databases.
>>
>> --
>> Saludos
>> Rodrigo Baeza O.
>>
>
>


-- 
Saludos
Rodrigo Baeza O.

------=_Part_38031_16806368.1224095925324
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">David, <br>&nbsp;&nbsp; Thank you very much for help, the problem in this pool of
connections, add the configuration file in the pool and deployer in the
console. and everything ok. <br> the file is so ... <br><br>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;<br>&lt;connector xmlns=&quot;<a href="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">http://geronimo.apache.org/xml/ns/j2ee/connector-1.2</a>&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &lt;dep:environment xmlns:dep=&quot;<a href="http://geronimo.apache.org/xml/ns/deployment-1.2">http://geronimo.apache.org/xml/ns/deployment-1.2</a>&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:moduleId&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:groupId&gt;console.dbpool&lt;/dep:groupId&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:artifactId&gt;actividades&lt;/dep:artifactId&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:version&gt;1.0&lt;/dep:version&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:type&gt;rar&lt;/dep:type&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dep:moduleId&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:dependencies&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:dependency&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:groupId&gt;oracle&lt;/dep:groupId&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:artifactId&gt;oracle&lt;/dep:artifactId&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:version&gt;1.4&lt;/dep:version&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dep:type&gt;jar&lt;/dep:type&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dep:dependency&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dep:dependencies&gt;<br>&nbsp;&nbsp;&nbsp; &lt;/dep:environment&gt;<br>&nbsp;&nbsp;&nbsp; &lt;resourceadapter&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;outbound-resourceadapter&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connection-definition&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connectionfactory-interface&gt;javax.sql.DataSource&lt;/connectionfactory-interface&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connectiondefinition-instance&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;name&gt;actividades&lt;/name&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;config-property-setting name=&quot;CommitBeforeAutocommit&quot;&gt;true&lt;/config-property-setting&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;config-property-setting name=&quot;Password&quot;&gt;mvi&lt;/config-property-setting&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;config-property-setting name=&quot;Driver&quot;&gt;oracle.jdbc.OracleDriver&lt;/config-property-setting&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;config-property-setting name=&quot;UserName&quot;&gt;salfa&lt;/config-property-setting&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;config-property-setting name=&quot;ConnectionURL&quot;&gt;jdbc:oracle:thin:@127.0.0.1:1521:XE&lt;/config-property-setting&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connectionmanager&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;local-transaction/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;single-pool&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;max-size&gt;2&lt;/max-size&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;min-size&gt;1&lt;/min-size&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;blocking-timeout-milliseconds&gt;100&lt;/blocking-timeout-milliseconds&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;idle-timeout-minutes&gt;1&lt;/idle-timeout-minutes&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;match-one/&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/single-pool&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/connectionmanager&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/connectiondefinition-instance&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/connection-definition&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/outbound-resourceadapter&gt;<br>&nbsp;&nbsp;&nbsp; &lt;/resourceadapter&gt;<br>&lt;/connector&gt;<br> I&#39;m in chile. it seems that I am the only one who occupy geronimo .... :-) <br>
 thanks.<br><br><div class="gmail_quote">2008/10/15 David Jencks <span dir="ltr">&lt;<a href="mailto:david_jencks@yahoo.com">david_jencks@yahoo.com</a>&gt;</span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I think you are using a non-jdbc-spec-compliant driver such as (IIRC) oracle that does not commit automatically when setAutocommit(true) is called. &nbsp;There&#39;s a commitOnAutocommit config-property you can set in the datasource plan for the generic tranql adapter to have tranql call commit() before setAutocommit(true).<br>

<br>
If you need more information please tell us which database you are using, which tranql adapter you are using, and show the datasource plan.<br>
<br>
thanks<br><font color="#888888">
david jencks</font><div><div></div><div class="Wj3C7c"><br>
<br>
On Oct 15, 2008, at 6:38 AM, Rodrigo Baeza O wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
 &nbsp; I have a problem, when you insert a record in Geronimo 2.1.2, occupying pool of connections and openJPA for persistence.<br>
NO inserted into the databases at the time but when the server is down.<br>
DO NOT send error, not only records in the databases.<br>
<br>
-- <br>
Saludos<br>
Rodrigo Baeza O.<br>
</blockquote>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Saludos<br>Rodrigo Baeza O.<br>
</div>

------=_Part_38031_16806368.1224095925324--