Subject | Re: rdb$db_key in either XSQLDA or XSQLVAR |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-04-30T15:02:41Z |
> If you want the dbkey, ask for the dbkey. That doesn't require magicOk, maybe I explain the background for the problem.
> SQLVARs, flags, ESP, new calls, or anything.
JDBC 2.0 introduces the concept of updatable result set. You can go
through the result set, and for some records you can say "update
column A with value B". Then you continue. At the end you say "apply
updates", and automagically your updates are in database.
As I already described, I do not want to rewrite SQL in the JDBC
driver to ask for dbkey explicitly - it is not job of the JDBC driver.
I asked if it is possible to become dbkey implicitly _and_ without
making incompatible changes in the XSQLDA and remote protocol. If this
is not possible, the we do not provide this feature in JDBC - "server
does not support it". Period.
My suggestion to pack dbkey into unused field in XSQLDA and Nickolay's
idea of new call are compatible changes. The question to answer here
is, does it makes sense? Do we want this in Firebird? That's how I
understand Firebird-Architect group.
Roman