[jboss-user] [Installation, Configuration & Deployment] - JDBC & MS SQL: different databases

[domyalex]

Hi to all,
I would like to develop an app for both Intersystem's Cache as well as MS SQL Server databases. Cache manages the concept of Namespaces which groups a number of tables, so, once I have my cache-ds.xml defined in /deploy I can access the tables nameSpace1.Table1, nameSpace1.Table2, but it also allows me to use nameSpace2.table1, all with just one datasource.

The question is: is there anything similar in MS SQL? Can I, with one datasource, access different databases in my SQL service? Is there somewhere the concept of namespaces or something similar? Can I connect to 'master' and create for example a table in a different database?

Regards

Alejandro


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4050687#4050687

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4050687