dinamic <datasource> in jbosscmp-jdbc.xml

[nacho2004]

hi everybody,

I have a jbosscmp-jdbc.xml file with this piece of code
<jbosscmp-jdbc>

java:/skyline
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>

.
.
</jbosscmp-jdbc>

This xml is on EJBs.jar file.

And mssql-ds.xml (on jboss_home/server/default/deploy) has these lines

<local-tx-datasource>
<jndi-name>skyline</jndi-name>
<connection- url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=skyline3</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>skyline</user-name>
skyline
</local-tx-datasource>

So, my client need to change dynamically the datasource for use a diferent database.
The question is :
Can I change dynamically the java:/skyline into the EJBs.jar file to work with other database ?
Anybody give me some ideas to do that.
Thank in advance !!!

[gorano]

I don't think you can do that. Maybe some one else have done it,
I don't know.

What I have done once is two different DBs with the same tables.
Created a super bean and inherited two beans connecting to
the different schemas. The client could choose what bean to use.

/G

[nacho2004]

I think that is that I'm looking for.
I've 2 DB with the same tables and I need to choose one of them in every moment depends of the client choose

[priyankajajala]

can i know what is the possible way to habdle this scenario,we are also facing similar kind of isuue