Re: Feature to capture SQL Query?

[arun philip]

How do I capture all the transactions occuring in a particular database in SQL form?

On Thursday, August 9, 2012 6:02:06 PM UTC+5:30, arun philip wrote:

Hello Sir,

I am working on a heterogeneous database synchronization project.
I am planning to use SQL Query based synchronization.
Is there any way in H2 database to capture the SQL queries similar to Oracle audit?

Regards
Philip

[Thomas Mueller]

Hi,

I think you would have to use triggers to capture the changes. This is also how the built-in fulltext search works.

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.

To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/eMbGA8YKq-oJ.

To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[arun philip]

Thank You.

But how do you get the sql transactions?
I mean the SQL transaction history of a table or entire schema.

Regards,
Philip

[Thomas Mueller]

Hi,

But how do you get the sql transactions?

See http://h2database.com/html/functions.html#transaction_id

I mean the SQL transaction history of a table or entire schema.

H2 currently doesn't allow you to read the transaction log, but you can use triggers to create your own transaction log.

Regards,

Thomas