| Subject | Re: [Firebird-Java] How can I tell what row has been inserted into Firebird db via JSP |
|---|---|
| Author | unordained |
| Post date | 2012-03-08T17:53:48Z |
---------- Original Message -----------
From: Mark Rotteveel <mark@...>
Tangent: what about support for something like what FlameRobin does at the end of
a statement: show how many inserts/updates/deletes took place across all tables
(incl. via triggers) -- is there anything pre-built for that? From casual poking
around, I can't even tell what system tables they're getting that from -- or is
it from the TRACE api?
-Philip
From: Mark Rotteveel <mark@...>
> Jaybird 2.2 will add support for retrieval of the generated key using------- End of Original Message -------
> getGeneratedKeys() (in combination with the specific execute methods that
> are defined in JDBC to support this functionality).
>
> That functionality is however not available in Jaybird 2.1.6 IIRC, but
> - with Firebird 2.0 or higher - you can use 'INSERT ... RETURNING
> <your-primary-key-field>' and execute that as a query (eg executeQuery)
> instead of an update. The returned resultset will then include the primary
> key that was generated (which is almost identical to what Jaybird 2.2 will
> do for the getGeneratedKeys() functionality).
Tangent: what about support for something like what FlameRobin does at the end of
a statement: show how many inserts/updates/deletes took place across all tables
(incl. via triggers) -- is there anything pre-built for that? From casual poking
around, I can't even tell what system tables they're getting that from -- or is
it from the TRACE api?
-Philip