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.