You'll probably have more joy interfacing to your custom CMS using java
functions, and exposing those java functions to the H2 engine as fake
tables using stored procedures.
http://www.h2database.com/html/features.html#user_defined_functions
See the section marked "Using a function as a table".
On 2012-08-06 16:49, Atul Chowdhury wrote:
Hi Thomas -
I'm querying a proprietary database which stores its data in an
object-tree (fields and collections make up its content). There's no
way to "query" this data structure other than use the Java APIs that
come with the database (the best way to explain the database is a
"content management system" type repository).
My intention is to use H2 as a JDBC driver and NOT a database. The
database is the repository I just mentioned, I just want to pass-thru
the results from repository->H2 driver -> client. This is why I'm
building transient tables via TableEngine and creating/disposing
results immediately (I could cache later on, but that complexity is
not something I need to address right now).
The alternative is to implement the JDBC specification for my purpose
but H2 already accomplishes this so well.
Let me know if this makes sense -
Atul
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
