Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

content changed

3 posts in JConnect version 3.0 Last posting was on 1999-01-12 22:14:46.0Z
Jim Posted on 1999-01-11 19:32:20.0Z
From: "Jim" <cyangatwork@hotmail.com>
Subject: content changed
Date: Mon, 11 Jan 1999 14:32:20 -0500
Lines: 10
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <SWZxFmZP#GA.100@forums.powersoft.com>
Newsgroups: sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jconnect30:337
Article PK: 254613

Hi there,
Is there a way that I can know the content of a query has been changed?
I have a query that select from a table. Other users may update this table
at anytime.
Is it possible for me to know the table has been changed since my last
select query?

Thanks


David Wolf Posted on 1999-01-12 01:55:13.0Z
Message-ID: <369AAB81.13999290@sybase.com>
Date: Mon, 11 Jan 1999 20:55:13 -0500
From: David Wolf <dwolf@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: content changed
References: <SWZxFmZP#GA.100@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 23
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jconnect30:336
Article PK: 254612

What you are looking for is called "Optimistic Locking" where rather than
forcing database locks, you want to just "Hope" that no rows have changed, and
when an update occurs, you will reject it if the row changed. Many tools,
including Sybase's PowerJ and the DataWindow Component for Java can do
automatic Optimistic Locking. There is no facility for this in jConnect.
There is a datatype in ASE called timestamp which is a varbinary(8), and can be
compared by using the tsequal() function, but you'd need to do this by hand.

Dave Wolf
Internet Applications Division

Jim wrote:

> Hi there,
> Is there a way that I can know the content of a query has been changed?
> I have a query that select from a table. Other users may update this table
> at anytime.
> Is it possible for me to know the table has been changed since my last
> select query?
>
> Thanks


Jim Posted on 1999-01-12 22:14:46.0Z
From: "Jim" <cyangatwork@hotmail.com>
References: <SWZxFmZP#GA.100@forums.powersoft.com> <369AAB81.13999290@sybase.com>
Subject: Re: content changed
Date: Tue, 12 Jan 1999 17:14:46 -0500
Lines: 34
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <UsDRglnP#GA.70@forums.powersoft.com>
Newsgroups: sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jconnect30:335
Article PK: 255733

Thanks Dave,
Is this because of JDBC? I do not think jdbc support this.

David Wolf wrote in message <369AAB81.13999290@sybase.com>...
>What you are looking for is called "Optimistic Locking" where rather than
>forcing database locks, you want to just "Hope" that no rows have changed,
and
>when an update occurs, you will reject it if the row changed. Many tools,
>including Sybase's PowerJ and the DataWindow Component for Java can do
>automatic Optimistic Locking. There is no facility for this in jConnect.
>There is a datatype in ASE called timestamp which is a varbinary(8), and
can be
>compared by using the tsequal() function, but you'd need to do this by
hand.
>
>Dave Wolf
>Internet Applications Division
>
>Jim wrote:
>
>> Hi there,
>> Is there a way that I can know the content of a query has been
changed?
>> I have a query that select from a table. Other users may update this
table
>> at anytime.
>> Is it possible for me to know the table has been changed since my last
>> select query?
>>
>> Thanks
>