1 Reply Latest reply on May 18, 2008 2:18 PM by Sandeep Kulkarni

    Updating JDBC Datasources

    Sandeep Kulkarni Newbie

      Hi ALL,

      I want to add a new datasource[ex- oracle database DS] and rebind to an existing JNDI name.
      I want to do this to achieve the following -
      -If there is any change in database schema password[manuually on database server],
      this should be updated to already existing datasource and rebing with existing JNDI name


      Also I want to persist changes into {JBossHome}/server/default/deploy/oracle-ds.xml.
      Is there anyway I can take this -ds.xml inside my context[.ear]

      Am ?I doing any blunder , please HELP :)

        • 1. Re: Updating JDBC Datasources
          Sandeep Kulkarni Newbie

           

          "sankul123" wrote:
          Hi ALL,

          Also I want to persist changes into {JBossHome}/server/default/deploy/oracle-ds.xml.
          Is there anyway I can take this -ds.xml inside my context[.ear]

          Am ?I doing any blunder , please HELP :)


          This is the solution I am using , experts please comment on this

          To take *-ds.xml file inside ear -
          - Added a new module under services in jboss-app.xml
          <jboss-app>
           <module>
           <service>META-INF/myApp-ds.xml</service>
          </module>
          </jboss-app>


          - copied the myApp-ds.xml file inside META-INF in the build scripts itself.

          And I will be by hook or crook updating the *-ds.xml file which will be inside my context , which requires no file permissions when run under java security.

          Please let me know if anything else can be done ...

          Regards,
          Sandeep Kulkarni