| Subject | Re: [firebird-support] connecting 2 database |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-05-31T08:57:37Z |
At 07:39 AM 31/05/2005 +0000, you wrote:
single-statement requests that read from one database and write to
another; or that refer in any way to objects in multiple databases.
What you can do is read from and write to multiple databases from within a
single transaction in your client application. For example, you can query
one database, passing the output to a client structure; read that output
and pass a write request, using that data, to the other database; and do
the same thing in the opposite direction. The data writes are posted to
both databases.
Then, if COMMIT is called on that transactions, both databases are
permanently updated. If ROLLBACK is called, neither database is updated.
Some of the datapump utilities work with cross-database transactions like this.
./heLen
>hi. im trying to find a solutions for connecting two database.Firebird does not support "database namespaces" -- so it is not possible to
>
>Im trying to get/post data from DB1 to DB2 by using procedures but im
>not sure how to do it in firebird. In oracle i can use DBLink but for
>firebird ??
single-statement requests that read from one database and write to
another; or that refer in any way to objects in multiple databases.
What you can do is read from and write to multiple databases from within a
single transaction in your client application. For example, you can query
one database, passing the output to a client structure; read that output
and pass a write request, using that data, to the other database; and do
the same thing in the opposite direction. The data writes are posted to
both databases.
Then, if COMMIT is called on that transactions, both databases are
permanently updated. If ROLLBACK is called, neither database is updated.
Some of the datapump utilities work with cross-database transactions like this.
./heLen