Can you give me an example?? Thanks much!
mraible wrote: > > You should not use your own HibernateUtil class. You should use the > "sessionFactory" bean that's already configured and use it (or a > HibernateTemplate) to get your session. > > Matt > > On Sun, May 3, 2009 at 7:58 PM, Kenny Ha <vifaxoc...@yahoo.com> wrote: > >> >> Hi all, >> >> I posted this problem on AppFuse-Dev, but I haven't found solution yet. >> All I want is to excute SQL query from an XML file by using Hibernate >> (Hibernate Named SQL query) >> >> I create Maven with Struts 2 framework by running commands : >> >> _ mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes >> -DarchetypeArtifactId=appfuse-basic-struts >> -DremoteRepositories=http://static.appfuse.org/releases >> -DarchetypeVersion=2.0.2<http://static.appfuse.org/releases%0A-DarchetypeVersion=2.0.2>-DgroupId=com.mycompany.app >> -DartifactId=myproject >> >> _ mvn eclipse:eclipse >> >> _ mvn appfuse:full-source >> >> _ mvn jetty:run >> >> Everything is OK and run web application successful >> (http://localhost:8080 >> ) >> >> After that, I create a new file HibernateUtil.java in >> src/main/java/com/mycompany/app/webapp >> >> package com.mycompany.app.webapp.util; >> >> import java.sql.Statement; >> >> import org.hibernate.Session; >> import org.hibernate.SessionFactory; >> import org.hibernate.cfg.Configuration; >> >> public class HibernateUtil { >> Session session; >> Statement st; >> Configuration config; >> >> public HibernateUtil(){ >> config = new Configuration().configure(); >> >> >> SessionFactory sessionFactory = config.buildSessionFactory(); >> session = sessionFactory.openSession(); >> } >> >> public Configuration getConfiguration(){ >> return config; >> } >> >> public Session getSession(){ >> return session; >> } >> } >> >> Then,I continue creating a new file User.hbm.xml in src/main/resources >> >> <?xml version='1.0' encoding='utf-8'?> >> <!DOCTYPE hibernate-mapping >> PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" >> "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd";> >> >> <hibernate-mapping> >> <sql-query name="User.SqlQuery"> >> <![CDATA[ >> delete from app_user where id = -2 >> ]]> >> </sql-query> >> </hibernate-mapping> >> >> And I add some lines in src/main/resources/hibernate.cfg.xml >> >> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate >> Configuration DTD 3.0//EN" >> "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";> >> >> <hibernate-configuration> >> <session-factory> >> <mapping class="com.mycompany.app.model.User" /> >> <mapping class="com.mycompany.app.model.Role"/> >> >> <!-- Mapping files --> >> <mapping resource="User.hbm.xml"/> >> >> </session-factory> >> </hibernate-configuration> >> >> In src/main/java/com/mycompany/app/webapp/action/UserAction.java >> ,function >> delete : >> >> /** >> * Delete the user passed in. >> * @return success >> */ >> public String delete() { >> //userManager.removeUser(user.getId().toString()); >> Session session = hibernateUtil.getSession(); >> Query query = session.getNamedQuery("User.SqlQuery"); >> query.executeUpdate(); >> List<String> args = new ArrayList<String>(); >> args.add(user.getFullName()); >> saveMessage(getText("user.deleted", args)); >> >> return SUCCESS; >> } >> >> I run web application again, login to access admin menu, and chose >> Administration ---> View Users errors occur : >> >> javax.servlet.ServletException: Unable to instantiate Action, userAction, >> defined for 'users' in namespace '/admin'Error creating bean with name >> 'userAction' defined in ServletContext resource >> [/WEB-INF/applicationContext-struts.xml]: Instantiation of bean failed; >> nested exception is org.springframework.beans.BeanInstantiationException: >> Could not instantiate bean class >> [com.mycompany.app.webapp.action.UserAction]: Constructor threw >> exception; >> nested exception is org.hibernate.MappingException: An >> AnnotationConfiguration instance is required to use - action - >> file:/E:/Green%20Sun/Projects/demo_2/target/classes/struts.xml:131:63 >> at >> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:515) >> at >> >> org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> com.mycompany.app.webapp.filter.StaticFilter.doFilterInternal(StaticFilter.java:106) >> at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) >> at >> >> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:99) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) >> at >> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) >> at >> >> org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) >> at >> >> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> net.sf.ehcache.constructs.web.filter.GzipFilter.doFilter(GzipFilter.java:75) >> at >> net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:92) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> com.mycompany.app.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:74) >> at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:359) >> at >> >> org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) >> at >> >> org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:172) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:268) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:87) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:61) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) >> at >> >> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >> at >> >> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >> at >> >> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:174) >> at >> >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) >> at >> >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96) >> at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> at >> >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >> at >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) >> at >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) >> at >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) >> at >> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) >> at >> >> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206) >> at >> >> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) >> at >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:324) >> at >> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) >> at >> >> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:828) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514) >> at >> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) >> at >> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) >> at >> >> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) >> at >> >> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) >> Caused by: Unable to instantiate Action, userAction, defined for 'users' >> in >> namespace '/admin'Error creating bean with name 'userAction' defined in >> ServletContext resource [/WEB-INF/applicationContext-struts.xml]: >> Instantiation of bean failed; nested exception is >> org.springframework.beans.BeanInstantiationException: Could not >> instantiate >> bean class [com.mycompany.app.webapp.action.UserAction]: Constructor >> threw >> exception; nested exception is org.hibernate.MappingException: An >> AnnotationConfiguration instance is required to use - action - >> file:/E:/Green%20Sun/Projects/demo_2/target/classes/struts.xml:131:63 >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:294) >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation.init(DefaultActionInvocation.java:365) >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation.access$000(DefaultActionInvocation.java:38) >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:83) >> at >> >> com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455) >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation.(DefaultActionInvocation.java:74) >> at >> >> com.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:189) >> at >> >> org.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:41) >> at >> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:494) >> ... 79 more >> Caused by: org.springframework.beans.factory.BeanCreationException: Error >> creating bean with name 'userAction' defined in ServletContext resource >> [/WEB-INF/applicationContext-struts.xml]: Instantiation of bean failed; >> nested exception is org.springframework.beans.BeanInstantiationException: >> Could not instantiate bean class >> [com.mycompany.app.webapp.action.UserAction]: Constructor threw >> exception; >> nested exception is org.hibernate.MappingException: An >> AnnotationConfiguration instance is required to use >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:881) >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:824) >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) >> at >> >> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283) >> at >> >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) >> at >> >> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) >> at >> >> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:881) >> at >> >> com.opensymphony.xwork2.spring.SpringObjectFactory.buildBean(SpringObjectFactory.java:125) >> at >> com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:143) >> at >> com.opensymphony.xwork2.ObjectFactory.buildAction(ObjectFactory.java:113) >> at >> >> com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:275) >> ... 87 more >> Caused by: org.springframework.beans.BeanInstantiationException: Could >> not >> instantiate bean class [com.mycompany.app.webapp.action.UserAction]: >> Constructor threw exception; nested exception is >> org.hibernate.MappingException: An AnnotationConfiguration instance is >> required to use >> at >> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:111) >> at >> >> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61) >> at >> >> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:875) >> ... 100 more >> Caused by: org.hibernate.MappingException: An AnnotationConfiguration >> instance is required to use >> at >> >> org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1606) >> at >> >> org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1561) >> at >> org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1540) >> at >> org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1514) >> at >> org.hibernate.cfg.Configuration.configure(Configuration.java:1434) >> at >> org.hibernate.cfg.Configuration.configure(Configuration.java:1420) >> at >> com.mycompany.app.webapp.util.HibernateUtil.(HibernateUtil.java:15) >> at com.mycompany.app.webapp.action.UserAction.(UserAction.java:37) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >> at >> >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >> at >> >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> at java.lang.reflect.Constructor.newInstance(Constructor.java:494) >> at >> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:96) >> ... 102 more >> >> I debug source ,it throw an exeption at BeanUtils.class : >> >> /** >> * Convenience method to instantiate a class using the given >> constructor. >> * As this method doesn't try to load classes by name, it should >> avoid >> * class-loading issues. >> * <p>Note that this method tries to set the constructor >> accessible >> * if given a non-accessible (that is, non-public) constructor. >> * @param ctor the constructor to instantiate >> * @param args the constructor arguments to apply >> * @return the new instance >> * @throws BeanInstantiationException if the bean cannot be >> instantiated >> */ >> public static Object instantiateClass(Constructor ctor, Object[] >> args) throws BeanInstantiationException { >> Assert.notNull(ctor, "Constructor must not be null"); >> try { >> ReflectionUtils.makeAccessible(ctor); >> return ctor.newInstance(args); >> } >> [...] >> catch (InvocationTargetException ex) { >> throw new >> BeanInstantiationException(ctor.getDeclaringClass(), >> "Constructor threw exception", >> ex.getTargetException()); >> } >> } >> >> MappingException = org.hibernate.MappingException: An >> AnnotationConfiguration instance is required to use <mapping >> class="com.mycompany.app.model.User"/> >> >> Help me solve this! Its urgent. >> Thanks all! >> -- >> View this message in context: >> http://www.nabble.com/Hibernate-Named-SQL-query-tp23361995s2369p23361995.html >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net >> For additional commands, e-mail: users-h...@appfuse.dev.java.net >> >> > > -- View this message in context: http://www.nabble.com/Hibernate-Named-SQL-query-tp23361995s2369p23379844.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net
