1) I think MAX_INT (or MAX_LONG). :-) 2) You probably will not want to use MAX_INT because each pooled resource uses memory (space in the Java heap) and you only have so much available. How many you should set really depends on how many concurrent users you think that your application will have, and how many connections each user needs (I have seen apps that required 2 connections per user). However, you do not need a connection for every user logged in (unless your application is not well written - the app should hold a connection for as little a time as possible). See http://wiki.jboss.org/wiki/Wiki.jsp?page=SPECjAppServer2002TuningComponentsASDataSource for suggested settings (you will need to know that for each IR there are 8 concurrent users, for example, an IR of 50 means 400 concurrent users, and each user needs a connection) 3) The only issue is total memory usage. There is no "maximum connections among all pooled databases" value.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3955663#3955663 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3955663 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
