It is highly advisable to use the native OCI drivers .. that simply provide a native connection pooling ... and can work perfectly with RAC setting .. and because it native, you have superior performance.
http://www.rakeshv.org/docs/oracle/jdbc3.0/oracle/jdbc/pool/OracleOCIConnectionPool.html Regards, Youssef On Mon, Nov 24, 2008 at 6:01 PM, Ahmed Abbas <[EMAIL PROTECTED]> wrote: > Dear, > > I didn't create a connection pool of one connection. The configuration of > the datasource in the first case was as follows: > <Context path="/FamilyHandlerOpt"> > <Resource name="jdbc/VAS_FAF" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > driverClassName="oracle.jdbc.OracleDriver" > factory="oracle.jdbc.pool.OracleDataSourceFactory" > url="jdbc:oracle:thin:@172.21.201.60:1521:FMLYPRD1" username="family2" > password="family2" maxActive="100" maxIdle="10" maxWait="-1" /> > </Context> > > In the second case, I opened the connections using the same configuration > of the datasource above, kept the connections alive and pooled the threads > on these connections. > The response time of the second case was improved dramatically and the > system scalability was achieved. > > Best regards, > Ahmed Abbas > > -----Original Message----- > From: Christopher Schultz [mailto:[EMAIL PROTECTED] > Sent: Friday, November 14, 2008 6:40 PM > To: Tomcat Users List > Subject: Re: failure notice > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > To whom it may concern, > > aelgamal , wrote: > > The above scenario resulted in very poor scalability during the stress > > testing. When the average response time for 1 thread was x msec, the > average > > response time for 2 threads was 2x and 3 threads was 3x and so on. > > How did you configure your data source? > > > When I created a pool of connections (15 connections) in the Servlet and > > kept the connections of this pool alive the scalability improved. The > > average response time for a 150 concurrent threads was slightly higher > than > > the average response time for 1 thread. > > How did you configure your data source, here? > > > Please advice why the poor performance when I used tomcat data source. > > Tomcat can be configured to use a data source with a connection pool > size of 1. It's silly, but possible. If this is what you did, then you > simply weren't pooling connections and you should expect that pooling > would certainly improve performance. > > If you're interested in playing with connection pools, help out Filip by > using his new Tomcat connection pool he's testing. I'm sure he'd love > the feedback. > > - -chris > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkkdqfwACgkQ9CaO5/Lv0PBXdACgjq/4JJZKJ+DgNn64szioNSZl > mvgAoMN8Qb9oPjizMzzeXyGJQn6IPQmO > =7ATP > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
