SetUpAInformixDatasource

    Local-TX

     

    <?xml version="1.0" encoding="UTF-8"?>
    
    <!-- ===================================================================== -->
    <!--                                                                       -->
    <!--  JBoss Server Configuration                                           -->
    <!--                                                                       -->
    <!-- ===================================================================== -->
    
    <!-- $Id: informix-ds.xml,v 1.3.2.1 2004/12/01 11:44:11 schrouf Exp $ -->
    
    
    <datasources>
      <local-tx-datasource>
        <jndi-name>InformixDS</jndi-name>
        <connection-url>jdbc:informix-sqli://myhost.mydomain.com:1557/mydb:INFORMIXSERVER=myserver</connection-url>
        <driver-class>com.informix.jdbc.IfxDriver</driver-class>
        <user-name>x</user-name>
        <password>y</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
          -->
        <!-- sql to call on an existing pooled connection when it is obtained from pool 
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
          -->
    
        <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
        <metadata>
           <type-mapping>InformixDB</type-mapping>
        </metadata>
      </local-tx-datasource>
    </datasources>
    

     

    XA

     

    <?xml version="1.0" encoding="UTF-8"?>
    
    <!-- ===================================================================== -->
    <!--                                                                       -->
    <!--  JBoss Server Configuration                                           -->
    <!--                                                                       -->
    <!-- ===================================================================== -->
    
    <!-- $Id: informix-xa-ds.xml,v 1.4.2.2 2004/12/01 11:44:40 schrouf Exp $ -->
    
    
    <datasources>
      <xa-datasource>
        <jndi-name>InformixXADS</jndi-name>
        <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
        <!-- Not supported by latter drivers
        <xa-datasource-property name="IfxWAITTIME">10</xa-datasource-property>
        -->
        <xa-datasource-property name="Description">Something Descriptive</xa-datasource-property>
        <xa-datasource-property name="IfxIFXHOST">myhost.mydomain.com</xa-datasource-property>
        <xa-datasource-property name="PortNumber">1557</xa-datasource-property>
        <xa-datasource-property name="DatabaseName">mydb</xa-datasource-property>
        <xa-datasource-property name="ServerName">myserver</xa-datasource-property>
        <xa-datasource-property name="User">username</xa-datasource-property>
        <xa-datasource-property name="Password">password</xa-datasource-property>
        <user-name>x</user-name>
        <password>y</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
          -->
        <!-- sql to call on an existing pooled connection when it is obtained from pool 
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
          -->
        <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
        <metadata>
           <type-mapping>InformixDB</type-mapping>
        </metadata>
      </xa-datasource>
    </datasources>