Subject | remote tables |
---|---|
Author | paulruizendaal |
Post date | 2006-10-07T11:21:11Z |
Hi all,
Here is another link for a remote table implementation, iAnywhere this
time:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000595.htm
It is interesting to see that they support transactions on remote
tables, but not savepoints. OK, the odbc and jdbc api's don't support
savepoints directly, but it could have been handled via passthrough
SQL statements. Not sure what implementation trouble they ran into
when creating this limitation.
I am interested in hearing views about how (FB internal) transaction
handling could best be architected for remote tables.
Paul
Here is another link for a remote table implementation, iAnywhere this
time:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000595.htm
It is interesting to see that they support transactions on remote
tables, but not savepoints. OK, the odbc and jdbc api's don't support
savepoints directly, but it could have been handled via passthrough
SQL statements. Not sure what implementation trouble they ran into
when creating this limitation.
I am interested in hearing views about how (FB internal) transaction
handling could best be architected for remote tables.
Paul