File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Multiple database instances and types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Multiple database instances and types" Watch "Multiple database instances and types" New topic
Author

Multiple database instances and types

Padmaja Prasad
Ranch Hand

Joined: Nov 14, 2001
Posts: 76
Hi,
I need to access and update multiple instances of database and different types of databases(Sybase and Oracle) with in single tranaction. The DB access should be highly secured(i.e, the password of the DB schema shouldn't be accessible to anyone else). The number of database connections are really high(nearly 100 connections or schema per transaction). When a user gives an instruction to change a value, the application should update the value in all the database schemas. What is the most scalable way to do this? using DataSource(as in J2EE) or regular JDBC connections??
Thanks in advance
Padmaja
[ January 19, 2004: Message edited by: Padmaja Prasad ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multiple database instances and types
 
Similar Threads
Project
Schema and Database
Record Locking
recNo in Bodgitt and Scarper
Suggested Locking Solution