Updating JDBC Datasources

[sankul123]

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 :)

[sankul123]

"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