Re: Database synchronization

Article View: borland.public.jbuilder.database

Article #343

Back to borland.public.jbuilder.database Previous Next

#343

From: Michael Aresti
Date: Sat, 02 Sep 2006 13:49

12 lines
1603 bytes

Paul Nichols [TeamB] wrote:
> Kevin's answer is the only one that I know of that will work. In 
> addition, each update, insert, or delete could have a change/auditing 
> table associated with it with a timestamp. That way, you could use a 
> threaded call to see what rows need to be updated in the refresh, if any.

Thanks for help. Your both answers are very good explanation of problem 
I wanted to resolve. But I also think that at present my Java programing 
skills are insufficiently to this alone... so I decided to change the 
"Transaction Isolation" level to TRANSACTION_REPEATABLE_READ. This way 
nobody else can make any changes in database tables and I have always 
the most actual data.

Technical Details

Message-ID: <44f98bd5@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <44ef0d78$1@newsgroups.borland.com> <44f84d94@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,380c435f48cb225
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 02 Sep 2006 15:49:11 +0200
From: Michael Aresti <aresti@vp.pl>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
Newsgroups: borland.public.jbuilder.database
Subject: Re: Database synchronization
References: <44ef0d78$1@newsgroups.borland.com> <44f84d94@newsgroups.borland.com>
In-Reply-To: <44f84d94@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 83.19.63.210
Message-ID: <44f98bd5@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1157204949 83.19.63.210 (2 Sep 2006 06:49:09 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message