1 Reply Latest reply on Jan 21, 2014 9:22 AM by rareddy

    Deploying Resources

    tom9729

      This perhaps may be better suited for another forum, but I thought I'd try here first.

       

      JBoss allows me to deploy datasources with "*-ds.xml" files.

       

      eg.

       

      <?xml version="1.0" encoding="UTF-8"?>
      <datasources>
        <datasource jta="true"
                jndi-name="java:/jdbc/FooDS"
                pool-name="FooDS"
                enabled="true"
                use-java-context="false"
                use-ccm="true">
          <connection-url>jdbc:teiid:Foo@mm://foo:31000;</connection-url>
          <driver>teiid</driver>
          <validation>
            <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
          </validation>
          <pool>
            <min-pool-size>20</min-pool-size>
            <max-pool-size>20</max-pool-size>
            <prefill>true</prefill>
          </pool>
          <security>
            <user-name>user</user-name>
            <password>user</password>
          </security>
        </datasource>
      </datasources>

       

      I'm starting to get my hands dirty with the webservice connector and haven't had any luck with a similar strategy. Google suggests that "-ra.xml" files should work, but I've had no luck. Is there any way to do this? I am using JBoss EAP 6.1.0.

       

      Thanks!

      Tom

        • 1. Re: Deploying Resources
          rareddy

          Tom,

           

          Yes, we know of the support for -ds.xml files, this was added to JBoss AS 7.x after the many community members complained about  similar support from JBoss 5, 6 days. The disconnect is, in JBoss AS 5 & 6, user could configure both JDBC data sources and JCA sources using a -ds.xml file. However, in JBoss AS 7, the JDBC data source subsystem is different from that of the resource adapter. I do not think I saw similar support for -ra.xml for resource adapters. It could be done, but it needs AS level code changes for it. You can certainly open up dialog with WildFly team and log a feature request.

           

          These individual -ds.xml files files work best in standalone environment, so currently I recommend using the CLI scripting or Admin API for adding a data source for Teiid.

           

          Thanks.

           

          Ramesh..