Hi Francesco,
[EMAIL PROTECTED] wrote:
Dear all,
I have just come to OJB, and it was my intention to use ODMG.
Is there any tutorial?
A simple odmg tutorial can be found in 'tutorial'-section
http://db.apache.org/ojb/docu/tutorials/odmg-tutorial.html
I would like to retrieve a collection of objects from a relational
database (Postgres), making a selection using non standard database
functions (postgis extension).
I was wondering:
1) if this is possible with ODMG?
No, this is not supported. To use specific sql-extension or functions
you have to use plain SQL. It's possible to use plain SQL within the
odmg-api using the underlying PB-api
http://db.apache.org/ojb/docu/guides/odmg-guide.html#Access+the+PB-api+within+ODMG
http://db.apache.org/ojb/docu/faq.html#performSQL
But why do you want to use OJB to read the data? It seems that the
PostGIS jdbc extension can return java geometry objects
http://postgis.refractions.net/docs/ch04.html#id2453247
regards,
Armin
2) if the above is possible, then what is the configuration I should make
up, and what the query should look like?
Thank you,
Francesco.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
