File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect two database in BMP?

 
gopal kishan
Ranch Hand
Posts: 99
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

can i connect two databases to BMP??

like i am using Oracle and DB2, when i add a record i want to store it to two database.

how to do??

thanks in advance

Gopal
 
Masoud Kalali
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
it semm to be depended on at least following cnditions ,
-if you siply want to store data in both database independently
then you can use ordinary sql stuff.
-but if you need to commit in both databse transactionally
then you should use some XA capable driver and XA interfaces to make an actvity containing both of your commits.

if you need more comment then tell me which section you need
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic