java - Connection pooling with hibernate 4 and struts2 -

-

After

I have a web application using struts2 implemeted and hibernate 4.3.5

I have encountered some problems and some clarification is required on some connection pooling properties.

I have used to create pooling connections with hibernate c3p0-0.9. 1.jar

Below are connection pooling properties in c3p0 in hibernate.cfg.xml 

  & Lt ;! - Connection pooling c3p0 - & gt; & Lt; Property Name = "connection.provider_class" & gt; Org.hibernate.connection.C3P0ConnectionProvider & lt; / Property & gt; & Lt; Property Name = "hibernate.c3p0.min_size" & gt; 5 & ​​lt; / Property & gt; & Lt; Property Name = "hibernate.c3p0.max_size" & gt; 10 & lt; / Property & gt; & Lt; Property Name = "hibernate.c3p0.timeout" & gt; 500 & lt; / Property & gt; & Lt; Property Name = "hibernate.c3p0.max_statements" & gt; 2 & lt; / Property & gt; // I have heard somewhere that this property improves performance .. but do not know how it improves and & lt; Property Name = "hibernate.c3p0.idle_test_period" & gt; 300 & lt; / Property & gt; & Lt; Property Name = "hibernate.c3p0.preferredTestQuery" & gt; Choose sysdate from dual; & Lt; / Property & gt;   
 In my application, I set the following property in the  hibernte-cfg.xml    
 
 * session- Per-request * pattern is used  & lt ;! - To open the connection when the request is hit - & gt; & Lt; Property Name = "hibernate.current_session_context_class" & gt; Thread & lt; / Property & gt;   
 When I use this I am using  session  as the following  
  // MyHiberantaeUtil here is your own class Having singleton patterns and creating static block // hibernet-cfg.xml and will create the SessionFactroy object. SessionFastria SessionFacture = MyHibernTutL.getSessionFactor (); Session session = sessionFactory.getCurrentSession ();   
 According to the documentation .. When I use this pattern connection when request is requested and should be closed upon completion of the request. My case is its connection to the connection .. ie for the session I use this  getCurrentSession ()  but it can not be closed when the request is finished.  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 `NumBusyConection = 2 (if it has two requests.)`   
 I would like to know that I do not remember anything. As expected, why the  thread  property is not working?  
  And to say that the request is complete and has been generated from the request? Is the session-per-request best pattern or better for a pattern? I did not find this class `org.hibernate.connection.C3P0ConnectionProvider` in any jar file .. but my application is connecting to DB and working fine.   
 Please thank you in advance   
 
 
 JDBC connection Then opened when necessary and closes for the first time. When you exit your service layer, you need to manually close the session:  
  session.close ();   
 Otherwise connections will not be closed and you will starve the connection pool.  
 This is a good idea to use the spring, because it is a support to automatically create. There is no match for offer for you / off session spring:  < Ul> 
  •  Local transactions  
  •  Global transactions  
  •  Transaction annotations and automated comment runtime exceptions on success and rollback   
     with hibernation Installing the Spring Hibernate Upalit Class is easy to use.   

     




  
    •

    Comments

    Post a Comment

    Popular posts from this blog

    ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

    -
    I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
    Read more

    Matlab transpose a table vector -

    -
    An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
    Read more

    c# - Textbox not clickable but editable -

    -
    I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
    Read more