I have a comment/question on this issue: 2 databases to be used by Torque. I have DB1 and DB2, both with the same schema, generated by Torque. In the runtime config file (torque.properties) I have them both mapped, one with db1 and another database with db2 entries. Both of the databases are mssql.
The schema file has the <database> element containing a 'name' attribute. If I set the attribute to 'db1', then the generated classes will work properly with the DB1, but will not work with DB2. Am I right??? ( In my case, I have wrote a wrong value for the name attribute and torque has not working. ) AS a result of this, you have to generate two classes, one for DB1 and one for DB2, even though they have exactly the same structure (only one attribute is different, the DATABASe_NAME, I think). Is there any other way? (sorry, I am just a novice). And generalising this situation, I get the following problem: my app wants to connect to several databases (same DBMS), they are configured at runtime. (let's say xml file or some conf file, maybe even torque.properties). I can't use torque for this app. Am I right??? Pls comment on this because I am not shure of what I am talking about.:))) Yet it seems to be quite a nasty problem, if I am right. :((( Sorry for this lenghty message. Best regards, Alex > >I have a requirement to be able to access two or more DBs > simultaneously. For > >whatever reason, our DB designer has put some of the tables > I need to use in one > >Oracle DB and some in another. So, ease of configuration and > coding in that > >area would be useful. > > > I think you will find this is supported now and is quite > straightforward. > > Scott > > -- > Scott Eade > Backstage Technologies Pty. Ltd. > http://www.backstagetech.com.au > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
