Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: execution contexts
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
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
![]() |
![]() |