2 Replies Latest reply on Jul 1, 2015 8:30 PM by Anil Nair

    datasource deployment using ds.cli and ds.properties files

    Anil Nair Newbie

      Hi All,

      I have been trying to deploy the custom datasource using jboss cli after installing the jdbc driver.

      The deployment is successfull but the values that I am reading from properties files does seem to propagating to my datasource

      Cli file

      
      /profile=ha/subsystem=datasources/jdbc-driver=sqlserver:add(driver-n
      ame=sqlserver,driver-module-name=net.sourceforge.jtds,driver-class-n
      ame="${db.driver}")
      
      /profile=ha/subsystem=datasources/data-source=sqlserverDS45:add(jndi
      -name="${db.jndi_name}",  driver-name=sqlserver,  connection-url=${d
      b.url}, user-name="${db.user}", password="${db.password}", enabled=t
      rue, use-java-context=true )
      
      

       

       

       

      Properties file

      db.driver=net.sourceforge.jtds.jdbc.Driver
      db.jndi_name=java:jboss/datasources/CompanysDS2
      db.url=jdbc:jtds:sqlserver://172.31.30.17:1433/Companys;instance=MSSQLSERVER
      db.user=sa
      db.password=XXX
      

       

      When I run the above file using

      ./teiid/teiid-8.11.0.Final/bin/jboss-cli.sh  --connect controller=10.95.107.55 --file=sqlserverds/create-jtds-ds.cli  --properties=sqlserverds/create-jtds-ds.properties
      

       

      I was getting error could not create instance for class ${db.driver}.

      The once I hardcoded the driver name in the cli file(which is net.sourceforge.jtds.jdbc.Driver )I was able to see that datasource got created(in the admin console) with JNDI name as ${db.jndi_name} and connection url ${db.url}. So for some reasons the values from the properties files are not getting used during the datasource creation.

      Request you let me know If I am missing any steps as part of this deployment

      Thanks

      Anil

      $driver}