[Springframework-developer] use of FOR UPDATE

[Kopylenko, D. <dko...@ac...>]

Rod and co.,

would you please advise me on how to use Oracle's "FOR UPDATE" clause using
current JDBC framework? The thing is that by default the autoCommit property
of the Connection object is set to true and it causes the Oracle to raise:
"ORA-01002: fetch out of sequence" when trying to issue a "FOR UPDATE"
query. Since only the DataSource is passed all the way to JdbcTemplate,
there is now way to control it like this conn.setAutoCommit(false) outside
JdbcTemplate. Is there any way to configure the autoCommint attribute to
false in JBoss' xxx-service.xml for the particular connection pool or any
other suggestions.
I would appreciate some help.
Dmitriy.