These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 
  Previous topic | Next topic 
Author Message
Bulto
 Post subject: Nammed queries and performance
PostPosted: Thu Jun 01, 2006 4:52 am 
Newbie

Joined: Thu Jun 01, 2006 4:49 am
Posts: 5
Hello,

Is there a performance increase with the use of nammed queries ?
Work of parsing is made only once ?
For a performance increase, is a recommendation to use nammed queries ?

Thanks
Top
 Profile  
 
damnhandy
 Post subject:
PostPosted: Thu Jun 01, 2006 7:39 am 
Senior
Senior

Joined: Tue Mar 09, 2004 2:38 pm
Posts: 141
Location: Lowell, MA USA
There is a subtle performance boost, yes. The queries are parsed once at startup so you do remove this overhead. Generally, named queries are a good idea if your query is static. However, don't expect a 10x speed increase just because you have a named query :)

Ryan-

_________________
Ryan J. McDonough
http://damnhandy.com

Please remember to rate!

Top
 Profile  
 
Bulto
 Post subject:
PostPosted: Fri Jun 02, 2006 8:41 am 
Newbie

Joined: Thu Jun 01, 2006 4:49 am
Posts: 5
Thank you, any profit of performance is good to take.
Top
 Profile  
 
prashant shukla
 Post subject:
PostPosted: Tue Jun 06, 2006 4:26 am 
Newbie

Joined: Fri Apr 21, 2006 5:58 am
Posts: 2
hi all
i m trying to do one named query example but it is giving null pointer exception.i m posting my logs and hbm.please let me know what is wrong in that .

Thanks for your inputs in advance.


//-- calling named query here
Code:
public List getCountryNamedBy() {             
         
    Query query =getHibernateTemplate().getSessionFactory().getCurrentSession().getNamedQuery("country.by_code");                
    return query.list();
          
    }





//-- My hbm file

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.webui.command.admin.Country" table="Country_tbl">
<cache usage="read-write" />
<id name="objectId" type="string" column="Cou_CountryCode" >
<generator class="assigned" />
</id>
<property name="countryName" type="string" column="Cou_CountryName" />

<set name="stateCountry" cascade="all" lazy="false" inverse="false" >
<key column="Sta_CountryCode"/>
<one-to-many class="com.webui.command.admin.State" />
</set>



</class>

<query name="country.by_code">
<![CDATA[ select con from com.webui.command.admin.Country con order by con.objectId ]]>
</query>
</hibernate-mapping>


//-- and this is the Error Log





java.lang.NullPointerException
at com.services.admin.hmimpl.CountryServiceImpl.getCountryNamedBy(CountryServiceImpl.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:163)
at $Proxy3.getCountryNamedBy(Unknown Source)
at com.webui.controller.admin.CountryController.list(CountryController.java:102)
at com.webui.controller.admin.CountryController.showForm(CountryController.java:69)
at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:306)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:248)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:118)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:53)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy14.handleRequest(Unknown Source)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:79)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:143)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Top
 Profile  
 
Bulto
 Post subject:
PostPosted: Tue Jun 06, 2006 10:39 am 
Newbie

Joined: Thu Jun 01, 2006 4:49 am
Posts: 5
Code:
at com.services.admin.hmimpl.CountryServiceImpl.getCountryNamedBy(CountryServiceImpl.java:64)


What is your code around ligne 64 of CountryServiceImpl.java ?
Top
 Profile  
 
prashant shukla
 Post subject:
PostPosted: Wed Jun 07, 2006 12:08 am 
Newbie

Joined: Fri Apr 21, 2006 5:58 am
Posts: 2
Hi Bulto

this is my code around that query.im working on spring framework+ hibernate3 combination.


Code:
private ModelAndView editCountry(HttpServletRequest req, BindException exc) {
      ModelAndView mv = loadCountry(req,exc);
      String objectId = req.getParameter("objectId");
      List aCountry =new LinkedList();
      
      try {
          aCountry = (List) countryService.getCountryNamedBy(objectId);
         mv.getModel().put("country", aCountry);
         mv.getModel().put("action", "edit");
      } catch (Exception e) {
         e.printStackTrace();
      }
      return mv;
   }
   
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.