Two Databases?

[Daniel Graham <da...@videocoding.com>]

Hi All,

I'm in the middle of "upgrading" our tomcat-based video portal .. I need to support
user accounts with "money" involved .. so I obviously want a good and reliable 
database to manage user accounts. However, I also keep a lot of "transient" and
non-critical data in a database on the portal (sessions and logs and so on). 

I've thought that it may be nice to have all of the transient and non-critical data in
a local Hypersonic database or similar - fast, local, performance and I can live with
it if all the data is lost - however, I'd like the User account data to be on a more
reliable machine/database .. 

I'm using Tomcat 4.1x, Velocity and Turbine/Torque to handle DB connectivity - 
using something like:

    _DBC = org.apache.torque.Torque.getConnection();

The question is :

Can I have more than one database specified in the Turbine/Torque properties? If so
how do I reference them? If not, I assume that I'll have to go the (slightly) longer way
around and setup the User Account database connection manually? 

Any pitfalls to be aware of?

Regards,

Danny.
--
Dr Daniel Graham, Senior Development Engineer
Video and Image Coding Specialists
daniel.grahamREMOVELUNCHEON@videocoding.com
http://www.videocoding.com
Tel : [+44|0] 870 241 4618



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org