What are you trying to do? Have a single connection that is thread safe,
and manages multiple threads through a single connection maintaining
different contexts for each thread? I don't believe it does that, which is
one reason so many people use dbconnection pools. Last I looked, there was
no support from any JDBC driver for multiple concurrent transaction area
contexts over a single connection. Oracle supports this at the OCI layer,
but not many databases have that functionality.
Thor HW
----- Original Message -----
From: Kwan, Kenneth Y <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 02, 1999 2:02 AM
Subject: Re: Two simultaneous statements in the same connection.
So, does anyone know that Oracle 8i JDBC OCI driver can support concurrent
statements on the same connection, e.g. connection which is shared by many
servlets ?
Kenneth
-----Original Message-----
From: Ted Neward [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 02, 1999 4:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Two simultaneous statements in the same
connection.
Um.... you should append "provided your JDBC driver is
working correctly
*and* supports that sort of functionality...." Nothing I've
seen in the JDBC
spec says that a driver *must* support concurrent statements
on the same
connection. Granted, it's a pretty wimpy driver if it
doesn't, but if it's
not in the spec, it's not in the spec.....
Ted Neward
Java Instructor, DevelopMentor ( http://www.develop.com )
http://www.javageeks.com/~tneward
-----Original Message-----
From: Yan Yu <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Wednesday, December 01, 1999 8:18 PM
Subject: Re: Two simultaneous statements in the same
connection.
>Shouldn't be any problem. You should be able to run as
many statements as
>you needed, provided your JDBC driver is working correctly.
>
>
>----- Original Message -----
>From: MIGUEL ANGEL MATA JAIME LOPEZ <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, December 01, 1999 11:27 AM
>Subject: Two simultaneous statements in the same
connection.
>
>
>> Hi
>>
>> I am making a connection via JDBC. from a servlet. I have
run two
>> statements simultaneously in the same connection. This
haven��t caused
>> any problem. Can it cause a problem?.
>>
>> Thanks in advance.
>>
>> Miguel Angel
>>
>>
>___________________________________________________________________________
>> To unsubscribe, send email to [EMAIL PROTECTED] and
include in the
>body
>> of the message "signoff SERVLET-INTEREST".
>>
>> Archives:
http://archives.java.sun.com/archives/servlet-interest.html
>> Resources:
http://java.sun.com/products/servlet/external-resources.html
>> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
>>
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives:
http://archives.java.sun.com/archives/servlet-interest.html
>Resources:
http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body
of the message "signoff SERVLET-INTEREST".
Archives:
http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
