JDBCODBC - MS_ACESS Table LOCK. - Article 18152 - go-pugleaf

Article View: borland.public.jbuilder.java.language

Article #18152

Back to borland.public.jbuilder.java.language Previous Next

JDBCODBC - MS_ACESS Table LOCK.

#18152

From: R.Prabhakar
Date: Fri, 31 Jul 1998 00:00

14 lines
1204 bytes

Hi!
I am developing a clinnt/Server Application using JDBC-ODBC Driver 
on MS_Acess . If one client say inserts some 75 records into a table X
and if another client tries to query on the same table he gets incomplete 
information. So , if table lock is provided then such a problem will not
arise.
i would like to how do I perform Table Lock from my java application ,
Though I tried setting  the TransactionIsoaltion from the java code the 
ODBC- MS_ACCESS is not capable of handling the change in
transactionIsolation. 
I would be gald if some could give some views on it...

regards,
prabhakar

Technical Details

Message-ID: <01bdbc51$09d68af0$7b519e96@madws10>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,355e307638bc4613,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10cc0d,355e307638bc4613,start
X-Google-Attributes: gid10cc0d,public
X-Google-Thread: f74b3,355e307638bc4613,start
X-Google-Attributes: gidf74b3,public
From: "R.Prabhakar" <r.prabhakar@barco.com>
Subject: JDBCODBC - MS_ACESS Table LOCK.
Date: 1998/07/31
Message-ID: <01bdbc51$09d68af0$7b519e96@madws10>
X-Deja-AN: 376602174
Newsgroups: borland.public.jbuilder.java.language,comp.databases.ms-access,microsoft.public.access.odbcclientserver