indicate the data source over the instances

[htetnyi]

Hi all,

     I am trying to test JBoss 5.1.0 multi-instance and data source configuration.

1) I would like to know could I reference the data source file(**-ds.xml) in other instance(profile) which is not running.

2) I would like to know could I reference the data source file(**-ds.xml) in other instance(profile) which is running.

For example 1,

     I am running node1 profile with port 8091.

     Then, I would like to take data source configuration of node2(not running) from node1(running).

     Could I do that in JBoss 5.1.0.

For example 2,

     I am running node1 and node2 profiles with ports 8091 and 8092.

     Then, I would like to take data source configuration of node2 from node1.

     Could I do that in JBoss 5.1.0.

May I request your suggestions, references and ideas. Thanks.

Note: If I cannot do this, where could I reference such thing cannot do in JBoss 5.1.0.

[peterj]

The answer is no in both cases. A *-ds.xml file is not something that you load, rather it is a data source configuration file that JBoss AS deploys; your application only looks up this deployed resource in JNDI. Is there a reason why you don't want to copy the *-ds.xml file to both profiles? That is the simplest solution, especially since the file is so small.

[htetnyi]

Thank you Peter.

Why I want to do that is just testing for security control of database.

What I already done is I used datasource password encryption in *-ds.xml file and I write encrypted password in login-config.xml file as you know.

I will have more than one application in node2.

So, I would like to separate those application by JBoss multi-instance features for performance.

But they used the same schema in same database.I don't want to create *-ds.xml in every instances.

So, I consider about one ds file from multi-instances.

Thanks for everything.