Re: execution contexts

From: JEFFKISH <ait_at_concentric.net>
Date: Mon, 01 Feb 1999 13:47:30 GMT
Message-ID: <36b5ad1f.255396320@news.iserv.net>

Did you have to do anything special?
Were your threads actually executing simultaneously? (maybe a dumb question)
Did you have any situations where you had nested queries, i.e. when going through a cursor, or result set (are they kind of the same thing under the covers?) did you ever fire up a new query based on results you had from the current row? like:

while (next row)
get data
if data has a certain quality

	execute a nested query using data from this data
	while (next row2)
		do some work with this data
	end while

end while

Thanks for your comments..
Jeff

On 31 Jan 1999 00:36:35 GMT, gjlinker_at_aol.com (Gjlinker) wrote:

>
>Hi,
>
>I have had some experience with executing SQL via ODBC commands from different
>threads using the same connection. Curiously enough it works fine.
>
>Gerrit-Jan Linker
>Developer of Oraxcel and OraDebug
>http://members.aol.com/gjlinker
>
>In article <36b41371.19446983_at_news.iserv.net>, ait_at_concentric.net (JEFFKISH)
>writes:
>
>>Subject: execution contexts
>>From: ait_at_concentric.net (JEFFKISH)
>>Date: Fri, 29 Jan 1999 20:03:55 GMT
>>
>> I recently downloaded SQLJ From Oracle, and noticed that they
>>said threads could share a connection as long as they had separate
>>execution contexts. Can someone explain what this means and how you
>>achieve it in a non SQLJ situation, such as one where you are using
>>such as JDBC.
>>
>>I don't think that much of SQLJ (probably because of my inexperience)
>>because of it's lack to discover meta-data information, and was
>>disappointed to find out that it hides so much stuff from me (of
>>course it's probably just encapsulating stuff) that I could not use it
>>as a learning tool.
>>
>>Otherwise it seemed pretty easy to use it for quick and dirty work.
>>
>>Also, anyone else have Oracle SQLJ comments?
>>
>>Thanks
>>Jeff Kish
>>jeff.kish_at_ait-mmii.com
>
>
Received on Mon Feb 01 1999 - 07:47:30 CST