Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple database instances and types

 
Padmaja Prasad
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic