And here's the postgres-service.xml file.
Cheers,
Simon
--
"Those are pretty strong words coming from a guy who's been mistaken
for a plush toy" --- Get Fuzzy
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: postgres-service.xml,v 1.3 2002/03/01 00:02:00 d_jencks Exp $ -->
<!-- ===================================================================== -->
<!-- -->
<!-- Example configuration for the postgres database. -->
<!-- Put the driver jar jdbc7.0-1.2.jar in lib/ext -->
<!-- Contributed by Ignacio Coloma [EMAIL PROTECTED] -->
<!-- ===================================================================== -->
<server>
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="jboss.jca:service=ConnectionFactoryLoader,name=FooPostgresDS">
<attribute name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:postgresql://localhost/ejb
DriverClass=org.postgresql.Driver
UserName=sms
Password=password</attribute>
<attribute name="JndiName">FooPostgresDS</attribute>
<attribute name="TransactionManagerName">java:/TransactionManager</attribute>
<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</depends>
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends>
<attribute name="ConnectionManagerProperties">#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=500000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0
</attribute>
<attribute name="PrincipalMappingClass">
org.jboss.resource.security.ManyToOnePrincipalMapping
</attribute>
<attribute name="PrincipalMappingProperties">UserName=</attribute>
</mbean>
</server>
