Hi Emmanuel,
Emmanuel Cecchet wrote:
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.
I'd suggest the mailinglist page gets updated with some more information
on the purpose of the community en sequoia list. The low traffic on the
community could make it look as if there isn't much activity going on in
the Sequoia community :)
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? 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.
Thanks for your answer. I guess the developers of the application we
host will need to look into having their hibernate connect directly with
Sequoia and use the sequence trick.
Ricardo.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
