[JBoss-dev] Postgres service xml file

[Ignacio Coloma]

Enclosed is the config file for a postgres DataSource. It has been tested.

Regards,

Ignacio Coloma.
<?xml version="1.0" encoding="UTF-8"?>


<!-- ===================================================================== -->
<!--                                                                       -->
<!--  foo App DataSource                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- $Id: foo-postgres-service.xml,v 1.0 2001/09/20 20:00:05 icoloma Exp $ -->

<server>

  <depends>JBOSS-SYSTEM:service=Naming</depends>
  <depends>JBOSS-SYSTEM:service=TransactionManager</depends>

  <classpath archives="
	 jdbc7.0-1.2.jar, 
	 jbosscx.sar"/>

  <!-- ==================================================================== -->
  <!-- JDBC - Initialize the databases                                      -->
  <!-- to ConnectionFactoryLoader                                           -->
  <!-- ==================================================================== -->

  <mbean code="org.jboss.resource.ConnectionFactoryLoader" 
	 name="DefaultDomain:service=ConnectionFactoryLoader,name=FooPostgresDS">
    <attribute name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:postgresql://192.168.0.4:5432/foo
  DriverClass=org.postgresql.Driver
  UserName=postgres
  Password=postgres</attribute>
    <attribute name="JndiName">FooPostgresDS</attribute>
    <attribute name="TransactionManagerName">java:/TransactionManager</attribute>
    <attribute name="ResourceAdapterName">Minerva JDBC LocalTransaction ResourceAdapter</attribute>
    <attribute name="RARDeployerName">JCA:service=RARDeployer</attribute>
    <attribute name="ConnectionManagerFactoryName">MinervaSharedLocalCMFactory</attribute> 
    <attribute name="ConnectionManagerProperties">#
      #Wed Aug 15 16:17:29 EDT 2001
      InvalidateOnError=false
      BlockingTimeoutMillis=500000
      IdleTimeoutMillis=1800000
      MaxSize=10
      TimestampUsed=false
      IdleTimeoutEnabled=false
      CleanupIntervalMillis=120000
      MinSize=0
      GCMinIdleMillis=1200000
      GCEnabled=false
      MaxIdleTimeoutPercent=1.0
    </attribute>
    <attribute name="PrincipalMappingClass">
      org.jboss.resource.security.ManyToOnePrincipalMapping
    </attribute>
    <attribute name="PrincipalMappingProperties">UserName=</attribute>
  </mbean>

</server>