Database Explorer and Hibernate Tutorial problem

MyEclipse IDE

Java EE Development (EJB, JSP, Struts, XDoclet, etc.)

This topic has 12 replies, 2 voices, and was last updated 19 years, 2 months ago by mm2ha.

Viewing 13 posts - 1 through 13 (of 13 total)

Author

Posts

July 25, 2005 at 7:36 pm #233609 Reply

mm2ha

Member

Hi,I was trying to do the hibernate tutorial mentioned in the tutorials section. However, when I try to run my AddVipData.jsp, I get this error:


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

root cause

java.lang.NullPointerException
    com.nscorp.hibernate.SessionFactory.currentSession(SessionFactory.java:56)
    com.nscorp.hibernate.VipService.getVipdataList(VipService.java:137)
    org.apache.jsp.AddVipData_jsp._jspService(org.apache.jsp.AddVipData_jsp:130)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

what can be the problem? I am running JBoss 4.03RC1 and hsqldb 1.8 with Eclipse 3.1 and MyEclipse 4.0. Thanks a lot for your help

marko

July 26, 2005 at 9:10 am #233630 Reply

Riyad Kalla

Member

java.lang.NullPointerException
com.nscorp.hibernate.SessionFactory.currentSession(SessionFactory.java:56)
com.nscorp.hibernate.VipService.getVipdataList(VipService.java:137)

Can you copy-paste the entire SessionFactory.java “currentSession” method here?

July 26, 2005 at 9:18 am #233636 Reply

mm2ha

Member

this is it:


public static Session currentSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

        if (session == null) {
            if (sessionFactory == null) {
                try {
                    cfg.configure(CONFIG_FILE_LOCATION);
                    sessionFactory = cfg.buildSessionFactory();
                }
                catch (Exception e) {
                    System.err.println("%%%% Error Creating SessionFactory %%%%");
                    e.printStackTrace();
                }
            }
Line56:            session = sessionFactory.openSession();
            threadLocal.set(session);
        }

        return session;
    }

July 26, 2005 at 9:26 am #233640 Reply

Riyad Kalla

Member

Hmm, do you ever see this error:

System.err.println(“%%%% Error Creating SessionFactory %%%%”);

in your console output?

July 26, 2005 at 9:37 am #233641 Reply

mm2ha

Member

Hmm, no I cannot see it in the console output.

July 26, 2005 at 10:20 am #233645 Reply

Riyad Kalla

Member

Marko,
Is your hibernate.cfg.xml file in the root of your source tree? If you print out the value of sessionFactory on line 55, is it null? If so, there is likely an exception happening while creating the sessionFactory for some reason. Please paste the contents of your hibernate.cfg.xml file here, as well as tell me where it lives in yoiur source tree. Also let me know where all the mapping hbm.xml files live in your source tree as well.

July 26, 2005 at 10:22 am #233646 Reply

mm2ha

Member

Oops, sorry, I found it in the console. I just expected it to be in red.

Here is the jboss console output after I try to open the AddVipData.jsp:


16:33:49,652 INFO  [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
16:33:49,662 INFO  [PropertyMessageResources] Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
16:33:49,662 INFO  [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
16:33:49,662 INFO  [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
16:33:49,712 INFO  [Environment] Hibernate 2.1.8
16:33:49,712 INFO  [Environment] hibernate.properties not found
16:33:49,722 INFO  [Environment] using CGLIB reflection optimizer
16:33:49,722 INFO  [Environment] using JDK 1.4 java.sql.Timestamp handling
16:33:49,722 INFO  [Configuration] configuring from resource: /hibernate.cfg.xml
16:33:49,722 INFO  [Configuration] Configuration resource: /hibernate.cfg.xml
16:33:49,852 INFO  [Configuration] Mapping resource: com/nscorp/hibernate/Test.hbm.xml
16:33:49,862 INFO  [STDOUT] %%%% Error Creating SessionFactory %%%%
16:33:49,872 INFO  [STDOUT] net.sf.hibernate.MappingException: Resource: com/nscorp/hibernate/Test.hbm.xml not found
    at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:335)
    at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:1027)
    at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:983)
    at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:911)
    at com.nscorp.hibernate.SessionFactory.currentSession(SessionFactory.java:48)
    at com.nscorp.hibernate.VipService.getVipdataList(VipService.java:137)
    at org.apache.jsp.AddVipData_jsp._jspService(org.apache.jsp.AddVipData_jsp:130)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    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:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
16:33:49,872 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
    at com.nscorp.hibernate.SessionFactory.currentSession(SessionFactory.java:56)
    at com.nscorp.hibernate.VipService.getVipdataList(VipService.java:137)
    at org.apache.jsp.AddVipData_jsp._jspService(org.apache.jsp.AddVipData_jsp:130)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    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:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)

July 26, 2005 at 10:24 am #233649 Reply

mm2ha

Member

When I am looking at it right now, where can I change the mapping resource? because test was my previous database, but then I changed it to vipdata.

July 26, 2005 at 10:24 am #233650 Reply

mm2ha

Member

When I am looking at it right now, where can I change the mapping resource? because test was my previous database, but then I changed it to vipdata.

July 26, 2005 at 10:25 am #233651 Reply

Riyad Kalla

Member

16:33:49,872 INFO [STDOUT] net.sf.hibernate.MappingException: Resource: com/nscorp/hibernate/Test.hbm.xml not found

Oh so this file should be in your /src/com/nscorp/hibernate/ package, I”m guessing it’s not…

July 26, 2005 at 10:27 am #233652 Reply

mm2ha

Member

but it should not be there anymore, and it should not be asking for it…what I did at the begining was that I have created database Test, but then later on when doing the tutorial, I have changed it to vipdata, so that I would not be confused. but i guess the settings for it are still there. how can I change that?

July 26, 2005 at 10:34 am #233653 Reply

Riyad Kalla

Member

Open up the hibernate.cfg.xml file and remove the line that related to that mapping file, should be near the bottom where all the hbm.xml files are listed.

July 26, 2005 at 11:35 am #233658 Reply

mm2ha

Member

Hi, I fixed that and couple other errors which followed. But now I got stucked with another one. I have no clue, why it is doing query for table vipdata0 if my table name is vipdata. Do you have any idea?

18:31:36,514 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
18:31:36,514 ERROR [JDBCExceptionReporter] Table not found in statement [select vipdata0_.vip_id as vip_id, vipdata0_.vipname as vipname, vipdata0_.viptitle as viptitle from vipdata vipdata0_ order by  vipdata0_.vipname]
18:31:36,534 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
18:31:36,534 ERROR [JDBCExceptionReporter] Table not found in statement [select vipdata0_.vip_id as vip_id, vipdata0_.vipname as vipname, vipdata0_.viptitle as viptitle from vipdata vipdata0_ order by  vipdata0_.vipname]
18:31:36,554 INFO  [STDOUT] Hibernate ExceptionCould not execute query
18:31:36,564 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: net.sf.hibernate.exception.SQLGrammarException: Could not execute query
    at com.nscorp.hibernate.VipService.getVipdataList(VipService.java:151)
    at org.apache.jsp.AddVipData_jsp._jspService(org.apache.jsp.AddVipData_jsp:130)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    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:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
Caused by: net.sf.hibernate.exception.SQLGrammarException: Could not execute query
    at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:69)
    at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
    at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
    at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
    at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
    at com.nscorp.hibernate.VipService.getVipdataList(VipService.java:145)
    ... 26 more
Caused by: java.sql.SQLException: Table not found in statement [select vipdata0_.vip_id as vip_id, vipdata0_.vipname as vipname, vipdata0_.viptitle as viptitle from vipdata vipdata0_ order by  vipdata0_.vipname]
    at org.hsqldb.jdbc.Util.throwError(Unknown Source)
    at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
    at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
    at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
    at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
    at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
    at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
    at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
    at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
    at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
    at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
    at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
    ... 28 more

Author

Posts

Viewing 13 posts - 1 through 13 (of 13 total)