Thanks i already readed. Maybe what is happen is that my webapps are not
returning to the pool the database connection.
I have a question:
If i have a stateles bean using an entitymanager and doing any kind of
operation in the database, when my method returns the connections is the
connections is closed and returned to the pool?? do i missing something?
//All my ejbs are like this
@Stateless
@TransactionManagement(TransactionManagementType.CONTAINER)
public class ConektaComprasOnlineGeneradasFacade{
@PersistenceContext(unitName = "anyName")
private EntityManager em;
@TransactionAttribute(TransactionAttributeType.REQUIRED)
public void doSomeStuff(){
MyObject x = new MyObject();
em.persist(x);
//when this method is finished and the commit its done the database
connection is returned to the pool? do i have to close it?
}
}
Thanks
2014-02-13 9:51 GMT-06:00 Howard W. Smith, Jr. <[email protected]>:
> also, this one, and you can reach out to tomcat user list, too...
>
>
> http://blog.christopherschultz.net/index.php/2009/03/16/properly-handling-pooled-jdbc-connections/
>
>
>
> On Thu, Feb 13, 2014 at 10:34 AM, José Luis Cetina <[email protected]
> >wrote:
>
> > Then if tomee use tomcat-pool is this where the info really is?
> >
> > https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html not here
> > http://commons.apache.org/proper/commons-dbcp/configuration.html
> >
> >
> > 2014-02-13 9:32 GMT-06:00 José Luis Cetina <[email protected]>:
> >
> > > What about this info in tomee web page
> > >
> > > "Internally, from TomEE 1.5.0, JDBC pools are managed via Tomcat-pool.
> > You
> > > can still switch back to Apache Commons DBCP by adding the following
> > > property: DataSourceCreator dbcp. To get the full list of available
> > > configuration properties, have a look to Apache Commons DBCP
> > configuration<http://commons.apache.org/dbcp/configuration.html>
> > > ."
> > >
> > > What is the difference between tomcat pool and dbcp, they share the
> same
> > > properties?
> > >
> > >
> > > 2014-02-13 9:23 GMT-06:00 Romain Manni-Bucau <[email protected]>:
> > >
> > > Hi,
> > >>
> > >> some read
> > >> http://commons.apache.org/proper/commons-dbcp/configuration.html ;)
> > >> Romain Manni-Bucau
> > >> Twitter: @rmannibucau
> > >> Blog: http://rmannibucau.wordpress.com/
> > >> LinkedIn: http://fr.linkedin.com/in/rmannibucau
> > >> Github: https://github.com/rmannibucau
> > >>
> > >>
> > >>
> > >> 2014-02-13 16:21 GMT+01:00 José Luis Cetina <[email protected]>:
> > >> > Hi, im having about 180 users at the same time connected to my
> webapp,
> > >> > yesterday i got an mysql exception saying "Ton many connections"
> then
> > i
> > >> > read in blogs and update the property max_connections in my.cnf to
> 500
> > >> > connections (i have a stand alone server for database only that has
> > >> 16gb of
> > >> > ram just for the OS and the DB) then in that post recommend to
> adjust
> > >> that
> > >> > value (max_connections) accord to my pool connection. I use a
> > datasource
> > >> > resource configured in tomee.xml and i have this
> > >> >
> > >> > <Resource id="any" type="DataSource">
> > >> > JdbcDriver com.mysql.jdbc.Driver
> > >> > JdbcUrl ...
> > >> > UserName xxx
> > >> > Password xxx
> > >> > jtaManaged true
> > >> > initialSize=30
> > >> > MaxActive=500 (my old value was 250)
> > >> > MaxIdle=50
> > >> > MaxWait=90000
> > >> > MaxWaitTime=90000
> > >> > validationQuery=SELECT 1
> > >> > testOnBorrow=true
> > >> > </Resource>
> > >> >
> > >> > Then i have this questions:
> > >> >
> > >> > 1.What advice can you give me for handle around 180 users that use
> my
> > >> app
> > >> > an hit the database with each action.
> > >> > I use JSF (@NamedBeans) + EJB (All my EJBS are statless) + 1
> > SessionBean
> > >> > (@Named) for each users.
> > >> >
> > >> > 2. Which is the difference between MaxIdle and MaxActive?
> > >> >
> > >> > 3. Which is the default timeout for close inactive connections and
> > what
> > >> is
> > >> > the name of the property?
> > >> >
> > >> >
> > >> >
> > >> > I will be happy with any kind of advice.
> > >> >
> > >> > I use 2 servers with this configuration and tomee and both of them
> > read
> > >> to
> > >> > other server where the database is (2 webapp server + 1 db server).
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > -------------------------------------------------------------------
> > >> > *José Luis Cetina*
> > >> > -------------------------------------------------------------------
> > >>
> > >
> > >
> > >
> > > --
> > > -------------------------------------------------------------------
> > > *José Luis Cetina*
> > > -------------------------------------------------------------------
> > >
> >
> >
> >
> > --
> > -------------------------------------------------------------------
> > *José Luis Cetina*
> > -------------------------------------------------------------------
> >
>
--
-------------------------------------------------------------------
*José Luis Cetina*
-------------------------------------------------------------------
