Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using 2 databases

 
Renata fonseca
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all
I have to update 2 databases at same time... how can I persist an entity bean into two different databases (ie: Db2 and SQL Server)?
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Some options:
1) Use a BMP entity bean
2) Use your EJB container's proprietary features (not likely to exist)
3) Use a special JDBC driver, which can do the update on two databases (don't know if such drivers exist)
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How about use two different beans?
Kyle
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic