SET ISOLATION TO COMMITTED READ LAST COMMITTED JDB
Servio Velasco asked how to use SET ISOLATION TO COMMITTED READ LAST COMMITTED in JDBC. Jonathan Leffler suggested setting it in the connection string if possible, otherwise executing the statement after connecting. Alexandre Marini pointed to the JDBC IFX_ISOLATION_LEVEL parameter, suggesting value 5, and gave an Information Center link. No confirmation from the poster.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello everyone Anybody know how to use "SET ISOLATION TO COMMITTED READ LAST COMMITTED" in jdbc. How is conection string? Thank a lots Servio Velasco
On Fri, Apr 29, 2011 at 08:20, SERVIO VELASCO
<servio_velasco@hotmail.com>wrote:
> Anybody know how to use "SET ISOLATION TO COMMITTED READ LAST COMMITTED" in
> jdbc.
>
> How is connection string?
>
Can you set other isolation levels in the connection string? If so, you may
also be able to set last committed. If not, then you'll have to use the
fallback (which may be necessary even if you can set other isolation levels
in the connection string).
In the absence of information to the contrary, create the connection as
normal, then execute a simple statement:
SET ISOLATION TO COMMITTED READ LAST COMMITTED
--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
--000e0cd48cca5cd50304a210630a
Hello, you should check your Information Center manual, according to your engine version, there´s a specific page detaling all your jdbc parameters. check for the IFX_ISOLATION_LEVEL parameter, I think the value 5 will fit your needs. Hope it helps. Best regards. Em 29/04/2011 11:20, SERVIO VELASCO escreveu: > Hello everyone > > Anybody know how to use "SET ISOLATION TO COMMITTED READ LAST COMMITTED" in > jdbc. > > How is conection string? > > Thank a lots > Servio Velasco > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 See you at <http://www.iiug.org/conf/2011/iiug/>;
This is the link for the 11.5 Information Center: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.jdbc_pg.doc/ ids_jdbc_040.htm Best regards. Em 29/04/2011 11:37, Alexandre Marini escreveu: > Hello, > you should check your Information Center manual, according to your > engine version, > there´s a specific page detaling all your jdbc parameters. > check for the IFX_ISOLATION_LEVEL parameter, I think the value 5 will > fit your needs. > > Hope it helps. > Best regards. > Em 29/04/2011 11:20, SERVIO VELASCO escreveu: >> Hello everyone >> >> Anybody know how to use "SET ISOLATION TO COMMITTED READ LAST COMMITTED" in >> jdbc. >> >> How is conection string? >> >> Thank a lots >> Servio Velasco >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 See you at <http://www.iiug.org/conf/2011/iiug/>;