Oninit cdi / Archive
Talk to an expert →

SET ISOLATION TO COMMITTED READ LAST COMMITTED JDB

Posted in 2011

Topics: Connectivity: ODBC / JDBC / .NET

SERVIO — — source: IIUG Forums & Mailing Lists

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

↪ replying to SERVIO
Jonathan — — source: IIUG Forums & Mailing Lists

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

↪ replying to SERVIO
Alexandre — — source: IIUG Forums & Mailing Lists

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/>;

↪ replying to Alexandre
Alexandre — — source: IIUG Forums & Mailing Lists

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/>;