Hi Ricardo,
(I wrote this to the community list earlier, but I guess that's the wrong
place?)
The community list is not read as widely as the Sequoia list. So for
Sequoia related questions, please use the Sequoia mailing list.
We are using a Sequoia cluster with a hibernate based application in tomcat.
One thing which confuses me, is what the best way is to have the
application communicate with Sequoia:
A) let hibernate use the tomcat jdbc resource.. or...
B) have hibernate connect directly to Sequoia through jdbc?
In both cases, you just have to define your JDBC datasource to point to
Sequoia.
The reason I'm asking is that the sequoia docs talks about special tricks
to be used for using sequences properly
(http://sequoia.continuent.org/doc/2.10/userGuide/ar01s06.html, 6.6 and
6.7)
Would that work properly in situation (A) ?
The special tricks with sequences are related to PostgreSQL and they
apply to all cases if the application uses sequences. If you use
Hibernate to generate the database queries, it will use sequences with
PostgreSQL. Thus, you will need the trick mentioned in the doc. If you
are writing all SQL by hand and don't use PostgreSQL sequences then you
don't need the trick.
Hope this helps,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
