session « Connection « JPA Q&A





1. Hibernate session and garbage collector    stackoverflow.com

An object with hibernate session data member when garbage collected, is session's jdbc connection closed? In other words is leaving closing session to garbage collector bad idea?

2. session.connection() deprecated on Hibernate?    stackoverflow.com

We need to be able to get the associated java.sql.Connection of a hibernate session. No other connection will work, as this connection may be associated with a running transaction. If session.connection() ...

3. session.connection() is deprecated    forum.hibernate.org

4. Get a session with only a Connection object    forum.hibernate.org

Hi everyone, I'm trying to get a session without putting in hibernate.cfg.xml the connection parameters, because i don't have them. The only thing i have accesible is a Connection object, that i get in any moment, but i can't extract the params in order to use Configuration.setProperty(). The problem is that a session (i think) can only be retrieved using a ...

5. Replacing Session.connection() in Hibernate 4    forum.hibernate.org

I've read through the hibernate 4 migration guide, and noted the removal of Session.connection() for obtaining JDBC Connection instance. According to the migration guide, I should instead be using Session.doWork() or Session.connectionWithOptions(), but neither of these approaches gives me direct access to a JDBC Connection instance. I understand the design principle behind removing direction access to the managed JDBC Connections. I ...

6. Connection returned from Session.connection() closes.    forum.hibernate.org

try{ Connection c = HibernateSession.currentSession().connection(); // do the work with a prepared stmnt. // get a resultset // set the data in the resultset to a local variabe and return it to the client }catch( Exception ) { // do something }finally{ // close the ...

7. Session handling antipattern? (ThreadLocal + disconnect)    forum.hibernate.org

Hello, Just read Gavin's latest blog post about managing Hibernate Sessions: http://blog.hibernate.org/cgi-bin/blosxom.cgi I am now concerned that I may be using session-per-user-session antipattern. I have a web application. I have a ServiceLocator object. In its static block I create ThreadLocal instance: ThreadLocal SESSIONS = new ThreadLocal(); In ServiceLocator constructor I get a static reference to Hibernate's SessionFactory object. ServiceLocator has a ...

9. avoid two session on same connection ?    forum.hibernate.org





10. closing session and database connections    forum.hibernate.org

Newbie Joined: Thu Nov 06, 2003 8:32 am Posts: 5 I am using hibernate 2.1 mysql c3p0 to manage connection pool Hi, I am using the hibernate plugin in my struts webapp. I am using some code that I found in a struts polls app: public final class HibernatePlugIn extends SetupDAO{ /** * The Log instance for this class. */ private ...

11. How about obtaining session through connection pooling    forum.hibernate.org

Hi folks, I worry now about the approach of obtaining session which confirmed available connection pooling with c3p0. Is the connection pool available by the Singleton-Pattern used in order to get session ? (for example, HibernateUtil.java in 'Hibernate2 Reference Documentation') It seems that only one connection is always reused. How should the approach of session obtaining for using a connection pooling ...

12. session.close vs session.connection.close    forum.hibernate.org

13. Does session.close() close session.connection()?    forum.hibernate.org

15. When should I use the session.disconnect() method??    forum.hibernate.org

Hi, I am a newbie in Hibernate and I am thinking about applying Hibernate to a project I will work on in the next few month. And for the project, concurrency may not be high but data stale can be a disaster. Thus, I am wondering if it is better to always use session.disconnect() in the business layer. In fact, if ...

16. hibernate Session's Database Connection Management Policy    forum.hibernate.org

Hi Does anyone know how Hibernate Session handles Database Connections. If we configure hibernate to use the connection pool of a application server and then create a session, does hibernate bind the connection to the session untill session.close() is called, or will it connect and disconnect connections as when required depending on how the session is used. Please note i do ...





17. WARNUNG: finalizing unclosed session with closed connection    forum.hibernate.org

Session session = null; Transaction tx = null; try { session=DbHandler.getInstance.getSession(); // returns back a session tx = session.beginTransaction(); // get objects from database ... // change objects ... // update objects ... tx.commit(); } catch(Exception e) { // exception handling } finally { session.close(); } What have I to do to close ...

18. Confirming session / connection behavior    forum.hibernate.org

Hi, I'm posting this to confirm some session / connection pooling behavior that I have debugged in my Hibernate implementation. I'd appreciate a confirmation if this is correct (or a correction if it is not) Assumptions - Hibernate with C3P0 for connection pooling, with min and max of the pool set to 1. The original Hibernate integration interface I wrote would ...

19. Q:How to manage sessions of database connection    forum.hibernate.org

Hi there I've hibernate2 (tested few hours) and try to code a servlet application to mobile environment where most important subject is database connection. Tell me fellows, what is most suitable way to manage this when: - program can manage sessions after server reboot - save sessions to database? - there is no "general" database connection only user specific connection is ...

20. Sharing a single connection for all sessions    forum.hibernate.org

Regular Joined: Tue Sep 28, 2004 5:18 pm Posts: 55 Location: Switzerland I'm attempting to retrofit Hibernate into our Database persisted Desktop application, with a Swing GUI. I've been running into problems in a couple areas, particularly Connection and Session management. In the interest of keeping this post focused, I'll focus on what seems to be my stickiest problem: Sharing a ...

22. Session Connection    forum.hibernate.org

If I fetch a connection from a session, am I asking the session for his connection or will he give me one from the connection pool? Case in point: 1.) I ask the session for a db connection. 2.) Do some db procedure junk. 3.) Update an object in the session. 4.) Commit my transaction. 5.) Give the connection back. Will ...

23. Hibernate 2.1 - can I mix Connection and Session processing?    forum.hibernate.org

Hi, I am porting an existing JDBC application to Hibernate 2.1. I came to a point where I need to invoke some stored procedures. As far as I know, 2.1 does not support stored procedures. My plan is to have some JDBC code that invokes the stored procedure using an SQL Connection that I get from the Hibernate session (conn = ...

24. Session with supplied Connection    forum.hibernate.org

25. Session.close() or Session.connection().close()?    forum.hibernate.org

26. Problem with Connection obtained from a Session    forum.hibernate.org

27. Should I close connection or Session if I use s.connection?    forum.hibernate.org

sorry, you should... // if you want to use hql Session s = getSession; Query q = s.createQuery("from myEntity where column1 = :value"); q.setString("value", value); q.uniqueResult(); or q.list(); // if you want the mappings and use straight sql Session s = getSession; Connection c = s.getConnection(); Statement ste = c.createStatement(); ResultSet rs = ste.execute(QueryStr); while(rs.next()) { // process results... } s.close(); ...

28. What is the $Proxy1 connection from Session.connection()????    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.1.2 I am using the oracle.jdbc.OracleConnection (Oracle's Proxy Connection) ... which has a method: getUserName() ... This will return the proxy user's db username that was set in the connection. When I call the reconnect( Connection conn ) on the Session instance (currentSession), setting a connection of type oracle.jdbc.OracleConnection ...

29. 3.0 -> 3.1 migration pb with session.connection()    forum.hibernate.org

Hello, I migrate an app from hibernate 3.0 to 3.1 and get a pb with the jdbc connection closing. I use the session.connection() in a jboss JTA manage transaction. I read in documentation that connection opened by session.connection() should be close by user. So i modify my code to close the session manualy like this : Connection cnx = session.connection(); ... ...

30. Closing connection within session    forum.hibernate.org

31. Closing connection within session    forum.hibernate.org

return (Float) XXUtil.XXXXXX.runInSession(new HibernateLogic() { public Object run(Session session) throws HibernateException { Connection conn = session.connection(); PreparedStatement stmt = null; try { stmt = conn.prepareStatement("Query..."); stmt.setString(1, XXXXXXX); ResultSet rs = stmt.executeQuery(); } catch (XXException e) { throw new HibernateException(e); } finally { if (conn != null) { conn.close(); } } catch (Exception e) { } } } }); Question : Can ...

32. session.close() and pool connection    forum.hibernate.org

[quote="mcorrea"]when i used the session.close() and how i get a new session(), i need to create a pool manager. With the pool connection i have less problems with my web applications. What is the code to manage the pool and how i close the session and open again. Thanks[/quote] Hello Friend: You can use JNDI tu get your hibernate Session, because ...

33. What about no close on connection from session.connection()?    forum.hibernate.org

That depends on how you do your connection pooling. The most likely result is that you'll lose connection resources, eventually running out of connections and losing the ability to talk to the DB. If you use user-provided connection pooling, you can avoid that issue, because it's your own code that closes the connections anyway.

34. Session.connection() vs DBUtil.getConnection()    forum.hibernate.org

Hibernate version: 3 Are there any known reason not to use hibernate's framework to obtain the JDBC Connection? The issue is: We have a large scale web app and are slowly migrating parts of it to start using Hibernate. There is a lot of custom SQL written and we already have a pooling solution in place. Is it bad practice to ...

35. Session and database connections    forum.hibernate.org

36. unable to get session using connection.datasource | WL 9.1    forum.hibernate.org

Hi: this is a basic question around obtaining a session with connection.datasource. I am having trouble getting session factory object for a connection datasource which is deployed on Weblogic 9.1 hibernate version: 3.1.3 Environment info: Weblogic 9.1 Oracle 9.2 JDK 1.5 exact line of code where the exception is occuring: SessionFactory mOTSSessionFactory = mOTSConfiguration.configure("hibernate.cfg.xml").buildSessionFactory(); Snippet of hibernate.cfg.xml: DS_NAME ...

37. get the session for particular data source    forum.hibernate.org

38. disconnect object from hibernate session / get clean object    forum.hibernate.org

hi everybody! following problem... use hibernate to get object from database. then i serialize object to bytearray > send via webservice to client > client deserialize. now my problem appears. to deserialize a class called org.hibernate.proxy.pojo.cglib.SerializableProxy is need. problem is that, the object which i serialized includes already some hibernate informations. i know that this is need if object is later ...

39. disconnect or close session    forum.hibernate.org

Hi, I use hibernate with pooled DB connection. For each call (read/write) I start a new transaction and comit if all is fine or rollback when it fails. Does not matter from result, in finally block, I always close a session. My question are: 1. should I close session or better is to disconnect it ? 2. What is disconned method ...

40. Session.connection    forum.hibernate.org

41. Reuse an old session wih a new Connection. Possible?    forum.hibernate.org

Dear All, I have a problem with multiple instances of the same pojo being attached to different session. Anyway, the problem is not relevent, what I'd like to do is to keep a single session open for a long(ish) time and just close/reopen the database connection within it each time I need to do some work with it. The connections are ...

42. Hibernate session not recovering after connection drop.    forum.hibernate.org

Hi everyone, We have an issue in Production right now. If our DMZ Server drops the connection to the Database the Hibernate Session fails, once the connection is re-established Hibernate doesnt reinitiate the session. So even though the connection is back again Hibernate can no longer talk to the Database. The only way around this is to start the Tomcat Server, ...

43. connection pool gets session.save() stuck    forum.hibernate.org

I have an application which works perfectly until I added in the connection pool. all I did was adding properties.setProperty("hibernate.c3p0.max_size", "1"); properties.setProperty("hibernate.c3p0.min_size", "0"); properties.setProperty("hibernate.c3p0.timeout", "10000"); properties.setProperty("hibernate.c3p0.max_statements", "100"); properties.setProperty("hibernate.c3p0.idle_test_period", "300"); properties.setProperty("hibernate.c3p0.acquire_increment", "2"); to the Configuration properties. and session.save(object) stops working. there is no error thrown. the insert statement was never issued as made evident by spy.log. and the thread remains a live. ...

44. deprecation:org.hibernate.Session.connection()    forum.hibernate.org

I use Connection conn = this.getSession().connection(),but when I compile it,it says: [deprecation] connection() has deprecation under org.hibernate.Session Then I looked up hibernate-3.2 api,it says: Connection connection() throws HibernateExceptionDeprecated. To be replaced with a SPI for performing work against the connection; scheduled for removal in 4.x I don't know how to "replaced with a SPI for performing work against the connection"? Anyone ...

45. AuditLogInterceptor / Session.connection() deprecated    forum.hibernate.org

Hello all, Java Persistence with Hibernate page 549 and other online ressources give an Interceptor "reference implementation" (AuditLogInterceptor) that writes an audit log about entity changes to a different table. This is done in a new Session opened via Session.connection() since an Interceptor callback method is not allowed to write to the same session. However, with (at least) Hibernate 3.2.4.sp1 the ...

46. Session.connection() deprecation    forum.hibernate.org

Session.connection() is deprecated (I'm using Hibernate 3.2.6.ga). Corresponding comment in sources says: "@deprecated To be replaced with a SPI for performing work against the connection; scheduled for removal in 4.x" I'm not a big expert in Hibernate and its internals. Can anyone give a hint: what should I use if I need to get a Connection from the Session instance? Thanks ...

47. Session that doesn't manage the connection not closed    forum.hibernate.org

I'm introducing progressively Hibernate in my system. The system is a middleware that handles web service request. For each request we get a connection from the pool and is them handed to the different DAOs to do their job with JDBC. The transaction is handled outside of the DAOs. Now I'm introducing Hibernate so I create DAOs based on hibernate (working ...

48. Connection pool in a session    forum.hibernate.org

Hi, I'm developping a swing application that uses the same session for the whole application. So the objects from the model are always bound to a session so that retrieve bounded objects when needed. (We don't access the data by queries but by using the lazy loading, all the objects can be accessed by a root node). The probleme I have ...

49. Connection Closing stratgery While using Current Session.    forum.hibernate.org

Hi , Can some one throw a light on this . We are using Hibernate factory for all transaction in our application. We had set below in Hibernate config file. My question we are trying get connection from current session and call a procedure using a statemen. DO I need to close the connection after this processing or since I am ...

50. Session/Connection question    forum.hibernate.org

Hi everyone. The other day I was facing a strange issue, for some reason my Datasource (DBCP) was throwing an error. Exhausted pool. So at first I was thinking I was leaking connections due to sessions not being recovered. Debugging the application showed I was recovering all sessions. It looks like once I opened the session hibernate asked for a connection ...

51. Single Hibernate Session with Multiple Database Connection    forum.hibernate.org

Hi, We have to insert 500000 objects into database. It takes around 120 seconds. To improve this performance we want to use single session with multiple database connection. Is it possible to use single hibernate session with multiple database connection? Or any other option to improve bulk insert performance. Any help this will be appreciated. Thanks Maulin

53. Help Regarding disconnecting a Connection from session    forum.hibernate.org

Hibernate version:3.1 Am using session-per-conversation pattern using Servlet filters. Am currently using some hibernate previous releases disconnect and reconnect functions. Since these functions are deprecated in 3.1 they have no effect. I read that in 3.1 connections will be disconnected automatically after commit. But when am calling session.isConnected() after session.commit, still it returns true only. Am new to hibernate. Please help ...

54. Hibernate Session uses dead connection    forum.hibernate.org

hi there i have a problem with my session it uses the same connection all the time ... so if this connection dies (e.g. because of timeout while the user was inactive), i get a "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure" the c3p0 - pool recognizes this, by saying following: Code: 634561 [btpool0-5] WARN com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] A PooledConnection that has ...