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.

Syncrhonizing calls to jConnect

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 17:51:05.0Z
Don Blair Posted on 1997-07-15 19:18:37.0Z
Message-ID: <33CBCD0D.466@sybase.com>
Date: Tue, 15 Jul 1997 15:18:37 -0400
From: Don Blair <dblair@sybase.com>
Reply-To: dblair@sybase.com
Organization: Powersoft
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
CC: dblair
Subject: Syncrhonizing calls to jConnect
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 10
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:545
Article PK: 252297

Suppose you have multiple threads accessing a single
java.sql.Connection object. Will jConnect synchronize
itself automatically, or do I have to do this?

In other words, can I issue prepared statements from 2 threads
and process the result sets simultaneously?

Or do I have to execute the queries and process the
result sets one at a time?

Don


David Clegg Posted on 1997-07-30 17:51:05.0Z
Message-ID: <33DF7F09.35B6EEA8@sybase.com>
Date: Wed, 30 Jul 1997 10:51:05 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
Subject: Re: Syncrhonizing calls to jConnect
References: <33CBCD0D.466@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:449
Article PK: 252201

jConnect will take care of synchronization for you. The JDBC
standard does address this issue, and requires drivers to be
thread-safe in this regard.

dave

>
> Suppose you have multiple threads accessing a single
> java.sql.Connection object. Will jConnect synchronize
> itself automatically, or do I have to do this?
>
> In other words, can I issue prepared statements from 2 threads
> and process the result sets simultaneously?
>
> Or do I have to execute the queries and process the
> result sets one at a time?
>
> Don