java - Hibernate freezes/stands still during request when trying to flush: doesn't throw exception or error, just does nothing -


i using spring 4.2.5, hibernate 5.1.0.final, c3p0 0.9.5.2, , postgresql 9.4. problem has been occurring since started using connection pooling (c3p0), before using basic spring datasource.

  [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.bellplatformcategories#193], was: [com.thebrandsapp.pojo.product.bellplatformcategories#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.configurablefields#193], was: [com.thebrandsapp.pojo.product.configurablefields#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.descriptionfields#193], was: [com.thebrandsapp.pojo.product.descriptionfields#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.productcolorimages#193], was: [com.thebrandsapp.pojo.product.productcolorimages#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.productlists#193], was: [com.thebrandsapp.pojo.product.productlists#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.productpictures#193], was: [com.thebrandsapp.pojo.product.productpictures#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.productshopifyoption1values#193], was: [com.thebrandsapp.pojo.product.productshopifyoption1values#193] (initialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.product.productvariants#193], was: [com.thebrandsapp.pojo.product.productvariants#193] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.productvariant.collectionproducts#1731], was: [com.thebrandsapp.pojo.productvariant.collectionproducts#1731] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.productvariant.orderpieces#1731], was: [com.thebrandsapp.pojo.productvariant.orderpieces#1731] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.productvariant.productpictures#1731], was: [com.thebrandsapp.pojo.productvariant.productpictures#1731] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection found: [com.thebrandsapp.pojo.productvariant.reviews#1731], was: [com.thebrandsapp.pojo.productvariant.reviews#1731] (uninitialized) [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection dereferenced: [com.thebrandsapp.pojo.product.productshopifyoption2values#193] [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.engine.internal.collections  - collection dereferenced: [com.thebrandsapp.pojo.product.productshopifyoption3values#193] [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.event.internal.abstractflushingeventlistener  - flushed: 0 insertions, 2 updates, 0 deletions 5 objects [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.event.internal.abstractflushingeventlistener  - flushed: 0 (re)creations, 0 updates, 2 removals 21 collections [info] [talledlocalcontainer] 1143785 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - listing entities: [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - com.thebrandsapp.pojo.productvariant{ispermanentlyinactive=false, regularprice=0.00, dimensionunit=null, stockquantity=0, metadescription=null, taxstatus=null, createdat=tue may 24 22:06:02 cdt 2016, inactive=false, reviews=<uninitialized>, instock=false, id=1731, grams=0, sku=, barcode=, brand=com.thebrandsapp.pojo.brand#60, brandproductvariantposition=1, height=0.0, updatedat=tue may 24 22:12:11 cdt 2016, taxable=true, upc=null, weight=0.0, brandproductvariantid=21556778823, shortdescription=null, version=12, oldinventoryquantity=0, requiresshipping=true, name=m, backordered=false, permalink=null, shippingclass=null, weightunit=lb, purchaseable=false, orderpieces=<uninitialized>, inventorypolicy=deny, collectionproducts=<uninitialized>, description=null, shippingclassid=0, metakeywords=null, taxclassid=0, option3=null, fulfillmentservice=manual, onsale=false, option1=m, option2=null, randominttoknowifstale=9964169, shippingtaxable=false, compareatprice=null, taxclass=null, product=com.thebrandsapp.pojo.product#193, availabilitydescription=null, saleprice=null, backordersallowed=false, length=0.0, productvariantitempricetype=null, orderquantitymaximum=0, orderquantityminimum=0, width=0.0, productpictures=<uninitialized>} [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - com.thebrandsapp.pojo.brand{ppnamefont=null, addresses=<uninitialized>, productlistpricefontsize=0, ppdescriptionheadercolorhexstring=null, plcellborderwidth=null, ppdescriptionbodyfont=null, productpagetextfont=null, productpageheaderfontsize=0, productpagesubheaderfont=null, productpageheaderfont=null, shippingpolicies=<uninitialized>, id=60, plnamefont=null, plbackgroundcolorhexstring=null, productlisttilebackgroundhex=null, brandstripeaccount=null, pllogobackgroundtopcolorhextstring=null, version=20, productpagetextfontsize=0, productusers=<uninitialized>, bellplatformcategories=[], logoimage=null, ppdescriptionheaderfont=null, ppnamefontsize=0, name=null, plbackgorundgradienttopcolorhextstring=null, legalbusinessname=null, ppdescriptionheaderfontsize=0, productlistpricefont=null, plcellcornerradius=0, brandstoresetting=component[accesstoken,accesstokensecret,email,isinstalled,nonce,password,storehash,storename,userid,username]{password=null, isinstalled=true, storename=the-main-main-main.myshopify.com, accesstoken=afa83706ed66fcea805a92b6e20a7040, storehash=null, nonce=1111, userid=null, accesstokensecret=null, email=null, username=null}, isverified=false, plcellbordercolor=0, pppricebackgroundcolorhexstring=null, plpricefontsize=0, plbordercolorhexstring=null, plflowlayouttype=0, productlistbackgroundimage=null, products=<uninitialized>, plcellbackgroundcolorhexstring=null, ppdescriptionbodycolorhexstring=null, pppricefontsize=0, selleruseraccounts=<uninitialized>, plcustomized=0, pppricefontcolorhexstring=null, ppnamefontcolorhexstring=null, productlistnamefontsize=0, plnamefontcolorhexstring=null, productlistnamefont=null, referralpercentage=0.0, ecommerceplatform=0, ppdescriptionbodyfontsize=0, brandorders=<uninitialized>, plbackgorundgradientbottomcolorhextstring=null, productpagebackgroundcolorhex=null, hassignedup=false, productpagesubheaderfontsize=0, pllogobackgorundbottomcolorhextstring=null, pppricefont=null} [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - com.thebrandsapp.pojo.product{descriptionfields=<uninitialized>, productshopifyoption1values=[com.thebrandsapp.pojo.productshopifyoptionvalue#769, com.thebrandsapp.pojo.productshopifyoptionvalue#770], productlistpictureurl=null, ispermanentlyinactive=false, description=, brandproducttype=, productlists=<uninitialized>, createdat=tue may 24 16:40:09 cdt 2016, inventorywarninglevel=0, inactive=false, productshopifyoption3values=null, productvariants=<uninitialized>, id=193, productshopifyoption1=component[name,position]{name=size, position=1}, sku=null, brand=com.thebrandsapp.pojo.brand#60, randominttoknowifstale=9964169, productshopifyoption3=null, productshopifyoption2=null, updatedat=tue may 24 22:12:11 cdt 2016, productcolorimages=<uninitialized>, productshopifyoption2values=null, availabilitydescription=null, ecommerceplatform=null, upc=null, version=23, productbrandproductid=6776062663, tags=, bellplatformcategories=<uninitialized>, configurablefields=<uninitialized>, name=tshirt, inventorylevel=0, productpictures=<uninitialized>} [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - com.thebrandsapp.pojo.productshopifyoptionvalue{product2=null, product1=com.thebrandsapp.pojo.product#193, id=769, value=m, product3=null} [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.internal.util.entityprinter  - com.thebrandsapp.pojo.productshopifyoptionvalue{product2=null, product1=com.thebrandsapp.pojo.product#193, id=770, value=l, product3=null} [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.engine.spi.actionqueue  - changes must flushed space: "belldatabaseschema".product_variant [info] [talledlocalcontainer] 1143786 [http-nio-8080-exec-30] debug org.hibernate.sql  - update "belldatabaseschema".product set product_availability_description=?, product_brand_id=?, product_brand_product_type=?, product_brand_product_created_at=?, product_description=?, product_ecommerce_platform=?, product_inactive=?, product_inventory_level=?, product_inventory_warning_level=?, product_is_permanently_inactive=?, product_name=?, product_brand_product_id=?, product_list_picture_url=?, productshopifyoption1_name=?, productshopifyoption1_position=?, productshopifyoption2_name=?, productshopifyoption2_position=?, productshopifyoption3_name=?, productshopifyoption3_position=?, product_random_int_to_know_if_stale=?, product_sku=?, product_tags=?, product_upc=?, product_brand_product_updated_at=?, product_optlock=? product_id=? , product_optlock=? [info] [talledlocalcontainer] hibernate: update "belldatabaseschema".product set product_availability_description=?, product_brand_id=?, product_brand_product_type=?, product_brand_product_created_at=?, product_description=?, product_ecommerce_platform=?, product_inactive=?, product_inventory_level=?, product_inventory_warning_level=?, product_is_permanently_inactive=?, product_name=?, product_brand_product_id=?, product_list_picture_url=?, productshopifyoption1_name=?, productshopifyoption1_position=?, productshopifyoption2_name=?, productshopifyoption2_position=?, productshopifyoption3_name=?, productshopifyoption3_position=?, product_random_int_to_know_if_stale=?, product_sku=?, product_tags=?, product_upc=?, product_brand_product_updated_at=?, product_optlock=? product_id=? , product_optlock=? 

my hibernate.xml

 <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://www.springframework.org/schema/beans  http://www.springframework.org/schema/beans/spring-beans.xsd  http://www.springframework.org/schema/tx  h  ttp://www.springframework.org/schema/tx/spring-tx.xsd     http://www.springframework.org/schema/context          http://www.springframework.org/schema/context/spring-context.xsd">  <context:property-placeholder location="classpath:properties/database.properties" />      <bean id="sessionfactory"         class="org.springframework.orm.hibernate5.localsessionfactorybean">         <property name="packagestoscan" value="com.thebrandsapp" />         <property name="hibernateproperties">             <props>                  <prop key="hibernate.connection.driver_class">${jdbc.driverclassname}</prop>                 <prop key="hibernate.connection.url">${jdbc.url}</prop>                 <prop key="hibernate.connection.username">${jdbc.username}</prop>                 <prop key="hibernate.connection.password">${jdbc.password}</prop>                 <prop key="hibernate.dialect">org.hibernate.dialect.postgresqldialect</prop>                 <prop key="hibernate.connection.autocommit">false</prop>                         <prop key="hibernate.cp30.min_size">1</prop>                 <prop key="hibernate.show_sql">true</prop>                 <prop key="hibernate.c3p0.testconnectiononcheckout">true</prop>                 <prop key="hibernate.c3p0.idle_test_period">0</prop>                 <prop key="hibernate.c3p0.preferredtestquery">select 1</prop>                 <prop key="hibernate.c3p0.max_size">100</prop>         <prop key="hibernate.c3p0.min_size">5</prop>         <prop key="hibernate.c3p0.max_size">100</prop>         <prop key="hibernate.c3p0.timeout">2000</prop>         <prop key="hibernate.c3p0.acquire_increment">3</prop>      <prop key="hibernate.c3p0.max_statements">0</prop>         <prop key="hibernate.connection.release_mode">after_transaction</prop>                 <prop key="hibernate.jdbc.use_get_generated_keys">true</prop> <prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>             </props>         </property>     </bean>  <!-- transaction management stuff…. --> <bean id="transactionmanager"     class="org.springframework.orm.hibernate5.hibernatetransactionmanager">     <property name="sessionfactory" ref="sessionfactory" /> </bean>   <tx:annotation-driven transaction-manager="transactionmanager"     proxy-target-class="false" />  </beans> 


Comments

Popular posts from this blog

PySide and Qt Properties: Connecting signals from Python to QML -

c# - DevExpress.Wpf.Grid.InfiniteGridSizeException was unhandled -

scala - 'wrong top statement declaration' when using slick in IntelliJ -