In hibernate 2 I want to have it send:
{call nextval('foo')}
instead of
select nextval('foo)

The susbstitutions setting seems to do simple things, but I would need something more complex.

Or change the dialect, which looks like a source code change?

Before you ask, I need this for clustering (so this command will get propogated out to all servers as a write instead of read).

rick

This is not possible currently. And besides, this sounds like a really strange clustering strategy to me.

You mean it's not possible with the substitutions setting, but is there any other way to change what a dialect does, or is it get out the source and change it?

It's a pretty normal clustering issue. selects don't get propogated to all nodes, so you need to make it a write which will (in a mirroring setup). I'm working with c-jdbc and making it a call will cause it to be seen as a write.