XA Transactions

<drivers>
    <driver name="postgresqlXA" module="org.postgresql">
        <xa-datasource-class>org.postgresql.Driver</xa-datasource-class>
    </driver>
</drivers>

<datasources>
***

<xa-datasource jndi-name="java:jboss/PostgresXADS" pool-name="PostgresXADS" enabled="true" use-ccm="false">
      <xa-datasource-property name="ServerName">
          localhost
      </xa-datasource-property>
      <xa-datasource-property name="PortNumber">
          5432
      </xa-datasource-property>
      <xa-datasource-property name="DatabaseName">
          mydatabase
      </xa-datasource-property>
      <driver>postgresqlXA</driver>
      <xa-pool>
          <min-pool-size>5</min-pool-size>
          <max-pool-size>200</max-pool-size>
          <is-same-rm-override>false</is-same-rm-override>
          <interleaving>false</interleaving>
          <pad-xid>false</pad-xid>
          <wrap-xa-resource>false</wrap-xa-resource>
      </xa-pool>
      <security>
          <user-name>scott</user-name>
          <password>tiger</password>
      </security>
      <validation>
          <validate-on-match>false</validate-on-match>
          <background-validation>false</background-validation>
      </validation>
      <statement>
          <share-prepared-statements>false</share-prepared-statements>
      </statement>
  </xa-datasource>





  ***

  <drivers>

    ***
      <driver name="postgresqlXA" module="org.postgresql">
         <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
      </driver>
    ***

  </drivers>

</datasources>

Oracle:

<drivers>
    <driver name="oraXA" module="com.oracle">
       <xa-datasource-class>
            oracle.jdbc.xa.client.OracleXADataSource
       </xa-datasource-class>
    </driver>
</drivers>

http://localhost/view/s1

f.execSQL("commit");  
f.execSQL("create table t (q numeric)");  
f.execSQL("begin; insert into t values (1); commit; end;");  