1. which connection pool to use with JPA/Toplink implementation in J2EE? stackoverflow.comI have J2EE Application where I am using JPA/Toplink now I want to implement external or internal connection pool ... please help me to figure out how to implement connection pooling ... |
2. What is best approach for connection pooling? stackoverflow.comI am implementing connection pooling in project. Performance wise which is better approach to do it?
|
3. Hibernate with Application server connection pool coderanch.comI have successfully tested using hibernate in my application. However now i need to be able to use hibernate in such a way that the Application server takes care of handling database connections from it's connection pool. Which means like in Entity beans programmer should be able to use db connections without having to worry about open/close connections. So he could ... |
5. hibernate connection pool coderanch.comusing tomcat - hibernate - mysql. configured c3p0 default values for connection pool settings. when opening single session using factory pool grows by specified increment (5). session is closed. another session is opened and 5 more connections are established. seems incorrect. this continues until connections are exhausted and no sessions are open. Removed all session operations (create, find, save, etc) and ... |
6. Hibernate: Couldn't get connection pooling to work coderanch.comI followed this hibernate tutorial at http://www.gloegl.de/8.html and I a little modification to it so that it runs in J2EE app. I could get it to work with regular jdbc connection based on the setting below:- |
7. Hibernate & Connection Pooling coderanch.comHi I've been looking at using Hibernate for my database acivity on a new system I'm writing, but there are stil a couple of things I need to find out first One is in regards to load/stress with large scale (possibly 5 million records) databases, as my understaning is Hibernate basically creates a Bean for each result from the ResultSet (in ... |
8. hibernate setting using an application connection pool coderanch.com |
9. Is Hibernate's Connection Pooling worthy ? coderanch.com |
10. Connection pooling in Hibernate coderanch.com |
11. Connection pooling problem with Hibernate and WAS 6.1 coderanch.com |
12. Hibernate Connection Pool conf versus App Server Connection Pool conf coderanch.comYour connection pooling, and efficient use of connections is an absolutely critical part of your entire architecture. Working with WebSphere, I always prefer to defer to WebSphere connection pooling. Why? Bias perhaps, but I like the idea of offloading this important work to the server provider. I'm assuming the server vendor has put more work into making their pooling services more ... |
13. Connection Pooling in Hibernate coderanch.com |
14. Hibernate Connection Pooling. coderanch.com |
15. Best Connection pool API for hibernate coderanch.com |
16. Hibernate Connection Pool coderanch.comHi, I am using hibernate framework for generating excel reports using JXL Api. I was using default connection pooling mechanism provided by hibernate, however, i noticed that even though i close sessions, connections and resultsets, there were many connections that remained idle and as a result after some time my Oc4j server goes out of memory. Is there anyway i can ... |
17. Connection pooling using hibernate and struts1.3 coderanch.comHi all, I am learning struts with hibernates. I want to implement connection pooling. I wrote the configuration code in a java class, when ever I want a connection I am creating an instance for that class in my bean class and getting a session factory object. From that I am creating a session object and persisting the data to database. ... |
18. Jaybird connection pool forum.hibernate.orgHello! I'm using Jaybird driver and want to use Jaybird connection pool. According driver's documentation, there are two classes: org.firebirdsql.pool.FBSimpleDataSource and org.firebirdsql.pool.FBWrappingDataSource. Both works when I write pure jdbc code. Hibernate gives me an error Could not instantiate connection provider: org.firebirdsql.pool.FBSimpleDataSource. If I remove |
19. Connection pooling with hibernet forum.hibernate.orgMY application used below configuration for connection pool in hibernet.cfg.xml file. property name="connection.pool_size">1 Below is my question? 1) will it enough hibernate take care of the inbuild connection pool. My application has Hibernet3.0 EJB JMS Websphere6.0 I am trying to use C3p0 , but i am unable to get the connection. I did the below things. 1).created hibernate.prop file and kept ... |
20. Connection pool question forum.hibernate.orgHello everybody, I would like to know what are the most common solutions for connection pooling nowadays? Is there better support for this purpose integrated in hibernate 3.5 or should I still use a external conection pool like c3p0 or apache DBCP? I know there is also support for this in some application servers. But what about if I am using ... |
21. about hibernate's own connection pool forum.hibernate.orghi all, I am confused about how to configure c3p0 connection pool of hibernate in Spring. In my application, I configure database source as following: I am configuring sessionFactory as following: |
68. Using 3rd party connection pools forum.hibernate.orgI am working on a simple command line app demonstrating the use of Hibernate. I would like to use a 3rd part connection pool in my example, not the c3p0 or Proxool that are list in the documentation. I understand that if I ran in an App Server I could use that pool manager but for my purposes a stand alone ... |
69. connection pooling with firewall forum.hibernate.orgHi all, I have a firewall which closes all the connections which are idle for 30 mins.So i have included the following connection pooling parameters inside my context file. timeBetweenEvictionRunsMillis=300000 numTestsPerEvictionRun=20 minEvictableIdleTimeMillis= 180000 I also have maxActive=50 maxIdle=100 maxWait=-1 But still its not working.Can anybody have any suggestion in this regard. regards, Ajse |
70. connection pool destroyed... forum.hibernate.orgI use hibernate connection pool (c3p0) with oracle with configuration : jdbc.driverClassName=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@192.168.0.1:1521:test hibernate.dialect=org.hibernate.dialect.Oracle9Dialect hibernate.jdbc.batch_size=100 hibernate.cache.use_second_level_cache=true hibernate.show_sql=true jdbc.username=test jdbc.password=1 hibernate.c3p0.max_size=150 hibernate.c3p0.min_size=5 hibernate.c3p0.timeout=5000 hibernate.c3p0.max_statements=0 hibernate.c3p0.idle_test_period=300 hibernate.c3p0.acquire_increment=5 and code : public void method1(){ Session sess=getSession(); Connection conn = sess.connection(); CallableStatement statement= conn.prepareCall("{call p_sec.set_Cont(?,?)}"); statement.setString(1,identificator1_); statement.setString(2,identificator2_); statement.execute(); statement.close(); } it works fine during runtime, but after some exetution method1 (after Connection conn = sess.connection(); ... |
71. Connection Pooling forum.hibernate.orgIf you use Spring, which is a good idea, here is the way Hibernate is feeded with dbcp source info. First a dataSource is created in the config.xml file of Spring: Code: |
72. Connection Pooling forum.hibernate.org |
73. Please explain: Using Hibernate built-in connection pool forum.hibernate.org |
74. Strange problem with Hibernate pool connection forum.hibernate.orgHi, when run my application, after randomic time, I get this Hibernate exception: ------------------------------------------------------------------------------------- WARNING: SQL Error: 0, SQLState: 08S01 Oct 8, 2007 8:53:08 AM org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Communication link failure: java.io.EOFException, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1319) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1496) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 186) ... |
75. connection pooling forum.hibernate.orgHibernate version i am using:3.0 Mapping documents:hibernate.cfg.xml hibernate.properties Name and version of the database i am using:Oracle 8.i Actually I would like to know that if I have not configured connection pooling in hibernate.cfg.xml then where is the default connection pool taken from . I am using my application in WebSphere server. |
76. all connections in pool are sleepy! forum.hibernate.org |
82. Connection pool configuration advice? forum.hibernate.orgI am using Spring with Hibernate and at the moment am using the following datasource configuration. I am looking for suggestions as to what I might want to change or add to achieve maximum performance in a production environment. I know there are many other factors that would affect such tuning decisions, but I was hoping for some advice on how ... |
83. Connection Pool forum.hibernate.orgWhen there's a problem, it will usually show up in the logs. Maybe you're out of cursors? Maybe your proxies have timed out the connection through the firewall, but the server is still trying to use those same ports? Maybe it's just bad code in your apps that is making it look like a connection pool problem. Dig deeper, and post ... |