Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (nike.apache.org: domain of mr.pcwong@gmail.com designates
 209.85.222.171 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=QBBQvuKMW/M5djHUy8S56HkJvaMWv5ajWy879S0o8cB83G8wXtJKPZJvhEDODk4GLm
         hwExapziLZl4YgAVWoQqaAxR3Vy7gTp2GweD1w7svOKSe8XWdzaNhXEIcKCLXSTH7DSe
         zhWFF3FwrBpGg0zXkihqxH4Y7W6YTm+9mVtEw=
Message-ID: <4AC4DBDA.9090003@gmail.com>
Date: Thu, 01 Oct 2009 09:42:02 -0700
From: Paul Wong <mr.pcwong@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: user@geronimo.apache.org
Subject: Re: SSL connection between geronimo and postgresSQL
References: <4AC38DC4.1030108@gmail.com> <4AC39472.7050000@gmail.com>
 <D7CF6F86-D39C-4948-9964-F9127D724081@yahoo.com>
 <slrnhc7g4o.c4o.fredrik@scout.jonson.org>
 <9C99181D-93F4-402A-91E8-723D9D828035@yahoo.com>
 <slrnhc8gia.lb2.fredrik@scout.jonson.org>
In-Reply-To: <slrnhc8gia.lb2.fredrik@scout.jonson.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

David and Fredrik,

Thanks a lot.  Can I specify the implemented class injected is 
org.postgresql.ds.PGSimpleDataSource in my ra.xml file? 
Can you or anyone give me some tips of doing so?  I tried several 
parameters and could not get it to work.

Here is my java code:
    @Resource( name = " MyDbPool ", authenticationType = 
Resource.AuthenticationType.APPLICATION  )
    private PGSimpleDataSource jdbcDataSource;

Here is in the db-resource-adapter.xml
        <outbound-resourceadapter>
            <connection-definition>
                
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>MyDbPool</name>
                    <config-property-setting 
name="DatabaseName">MyDB</config-property-setting>
                    <config-property-setting 
name="ServerName">MyServer</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>

Here are the attributes I can use:
connectionFactory, statisticsProvider, UserName, ServerName, , 
connectionInterface, DatabaseName, Password, objectName, 
configProperties, managedConnectionFactoryClass, PortNumber, 
eventProvider, kernel, PrepareThreshold, resourceAdapterWrapper, 
connectionFactoryInterface, classLoader, abstractName, LoginTimeout, 
implementedInterfaces, connectionManagerContainer, connectionImplClass, 
connectionFactoryImplClass

Thanks a lot for your help.

Paul

Fredrik Jonson wrote:
> In <9C99181D-93F4-402A-91E8-723D9D828035@yahoo.com> David Jencks wrote:
>  
>   
>>  I've had that problem too and recently reorganized it.  Try this:
>>
>>  https://svn.codehaus.org/tranql/ra/trunk
>>     
>
> Thanks, I'll look into it.
>
>