Re: Tables are Locking up !!!

Check the Isolation level. If lots of inserts try using insert cursor, it will help to improve performance. Vinod Bhansali >From: Troy DesBarres <troyd@hfx.andara.com> >Reply-To: troyd@hfx.andara.com >To: informix-list@iiug.org >Subject: Tables are Locking up !!! >Date: Thu, 18 May 2000 20:39:10 GMT > >I am running an Informix database on an IBM SCO Machine. > >My Java Program is connecting through a JDBC Connection which is >working well. > >However my problem is when many users are inserting records into the >database using my program >there appears to be an SQL Exception thrown can not insert into ><table> because it is >locked. > >Does anyone know how I can fix this. If they use Informix in the >banking industry >they must receive hundreds of transactions at any given time. > >Any HELP would be greatly appreciated. > >Please respond to this group as well as the EMail below. > >troyd@hfx.andara.com > >Thanks. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com