-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kiran,
On 6/26/12 7:24 PM, Kiran Badi wrote: > <Resource name="jdbc/mysitedb" auth="Container" > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="10000" 100 active db connections sounds like a lot. Do you really need to support 100 simultaneous connections to your database? Can your database support that many connections with active queries from each? Do you have a cluster? Remember that each member in the cluster will therefore open a maximum of 100 connections to your database. 10 cluster members means 1000 simultaneous connections. > I had a bug in my code and I was not closing connection, I fixed > it and now this is working fine. You should enable "abandoned" detection and logging. >> an architectural comment: it's probably not a great idea to >> obtain a database connection directly from your Servlet. Doing >> so likely ties your business logic directly to both the servlet >> API *and* the JDBC API. >> >> If you want to switch to some other data source (e.g. a >> non-JDBC-supported data source like MongoDB, Cassandra, etc.), >> then you have to re-write your whole app. If you want to support >> Websocket, then you have to completely re-write your webapp. If >> you want to create an Android or Swing-based version, you have to >> completely re-write your app. See the pattern here? >> >> > I know existing design is somewhat a kind of limitation,but again > at this point ,its just to hard to implement this change. > > Let me think over this.It will take sometime. There's no time like the present: this problem will only get worse over time. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk/rISAACgkQ9CaO5/Lv0PC8MwCeMVv+gx6x4ItxZspgJwI0e2km 458An0CPoRxJQBmh/AKRQFo4o64ByJZE =eQp9 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org