----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Be careful of open cursor SQL errors, though, if you put too many prepared
statements into each connection in the pool and and the pool expands...
--
Michael Winton
eMarketing Team
Oracle Corporation
(650) 506-4337
----- Original Message -----
From: "Chris Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 12:22 AM
Subject: Re: It's not recommended to use SingleThreadedMode Servlets inJSSI
> ----------------------------------------------------------------
> BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> WHEN YOU POST, include all relevant version numbers, log files,
> and configuration files. Don't make us guess your problem!!!
> ----------------------------------------------------------------
>
> The way I've set up my Connection pool, each connection prepares
statements
> as it gets requests. ie: hash of PreparedStatements, which are "prepared"
on
> first request. Seems to do the job.
>
>
> >From: "Alexey Maksakov" <[EMAIL PROTECTED]>
> >Reply-To: "Java Apache Users" <[EMAIL PROTECTED]>
> >To: "Java Apache Users" <[EMAIL PROTECTED]>
> >Subject: Re: It's not recommended to use SingleThreadedMode Servlets
inJSSI
> >Date: Mon, 28 Aug 2000 19:27:12 +0400
> >
> >----------------------------------------------------------------
> >BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> >WHEN YOU POST, include all relevant version numbers, log files,
> >and configuration files. Don't make us guess your problem!!!
> >----------------------------------------------------------------
> >
> > Nope. I won't agree. SingleThreadModel is Thread-Safe - or at
least
> >considered to be so (I've checked with this FAQ and API), however it's
> >very
> >resource consuming (STMServlet Pools, etc.).
> > Anyway, does the Connection Pool allow the concurrent use of
Prepared
> >Statements? (I just wish to have Sevlets to initialize connection &
> >PreparedStatements in init() method and then use 'em in doGet() &
doPost()
> >)
> >
> > Sorry for slightly off-topic.
> >
> >----- Original Message -----
> >From: Brevsville Administrator <[EMAIL PROTECTED]>
> >To: Java Apache Users <[EMAIL PROTECTED]>
> >Sent: Monday, August 28, 2000 5:27 PM
> >Subject: Re: It's not recommended to use SingleThreadedMode Servlets
inJSSI
> >
> >
> > > ----------------------------------------------------------------
> > > BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> > > WHEN YOU POST, include all relevant version numbers, log files,
> > > and configuration files. Don't make us guess your problem!!!
> > > ----------------------------------------------------------------
> > >
> > > Alexey
> > >
> > > I think you are misunderstanding SingleThreaded Model (STM). STM does
> >not
> > > guaranteee thread safety, it relates only to the loading of servlet
> > > classes. Check the FAQ or java.sun.com for a detailed discussion on
this
> > > topic.
> > >
> > > Chris
> > >
> > >
> > > On Mon, 28 Aug 2000 17:33:48 +0400, Alexey Maksakov wrote:
> > >
> > > >----------------------------------------------------------------
> > > >BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> > > >WHEN YOU POST, include all relevant version numbers, log files,
> > > >and configuration files. Don't make us guess your problem!!!
> > > >----------------------------------------------------------------
> > > >
> > > > Is subj. still takes place in ApacheJSSI?
> > > >
> > > >If it so, can anybody advice how to organize correct work with
database
> > > >connections
> > > >(using JDBC2.1) when you plan to have heavy request load on your
> >servlets.
> > > >With general servlets I found SingleThreadModel convinient to run
> >concurrent
> > > >database queries
> > > >(from different servlets) (By the way - is this approach correct? or
I
> >will
> > > >have perfomance/stability problems?), however, I fear that such a way
> >is
> > > >impossible in JSSI.
> > > >
> > > > Any ideas?
> > > >
> > > >
> > > >
> > > >--
> > > >--------------------------------------------------------------
> > > >Please read the FAQ! <http://java.apache.org/faq/>
> > > >To subscribe: [EMAIL PROTECTED]
> > > >To unsubscribe: [EMAIL PROTECTED]
> > > >Search Archives:
> > >
> >
><http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
> > > >Problems?: [EMAIL PROTECTED]
> > > >
> > >
> > >
> > >
> > >
> > > --
> > > --------------------------------------------------------------
> > > Please read the FAQ! <http://java.apache.org/faq/>
> > > To subscribe: [EMAIL PROTECTED]
> > > To unsubscribe: [EMAIL PROTECTED]
> > > Search Archives:
> > >
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
> > > Problems?: [EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> >
> >
> >
> >--
> >--------------------------------------------------------------
> >Please read the FAQ! <http://java.apache.org/faq/>
> >To subscribe: [EMAIL PROTECTED]
> >To unsubscribe: [EMAIL PROTECTED]
> >Search Archives:
> ><http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
> >Problems?: [EMAIL PROTECTED]
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search Archives:
> <http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
