connection « Performance « JPA Q&A





2. Label Security and Connection Pooling... performance problem    forum.hibernate.org

One of the mandates on our project is to use oracle label security, which we have been using successfully. In order to use label security, we need to 'stamp' the username of the user on the connection that comes out of the connection pool prior to using it. We accomplish this through a C3P0 connection customizer: Code: public void onCheckOut(Connection connection, ...

3. query to hang on open connection....awful performance    forum.hibernate.org

All, Been using hibernate for a few weeks now and everything looks great...until now. I have a query (mapping below) that uses a join. when I run it with hibernate debug on, it flies up until the point where it says: "DEBUG: opening JDBC connection:" "DEBUG: select blah blah blah" it then hangs for about 5 seconds, returns a few results ...

4. Hibernate performance issue (no enough jdbc connection)    forum.hibernate.org

Hi all, I'm using jboss 4.2.2 and facing performance issue. My jboss handles about 100 HTTP request per/seconds and for each HTTP request, a couple of database query will be executed with hibernate. I have configed the size of jdbc connection pool as 50~140. At the begging, jboss serves all requests well and only 50 jdbc connections are used. But after ...