- This topic has 15 replies, 4 voices, and was last updated 18 years, 8 months ago by
.
-
Posts
-
I am following the tutorial for a simple struts/hibernal/MySQL from this web site. I am using Eclipse 3.1, Workbench 4.1, and JBOSS 4.03SP1 I am “deplying the application using thw work bench.
I have added struts and hibernate capabilities using the work bench tool, however, I am getting the below:
[11:23:00,078] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:117) at com.rrcorp.hibernate.SessionFactory.<clinit>(SessionFactory.java:30) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:28) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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)Any help or suggestions would be greatly appreciated.
russray,
this is answer for both your post – problem is same
you haven’t all hibernate libraries in your project (this is log4j library, another message is ehcache libraries)
if you haven’t own libraries check My Eclipse library (like screenshoot)
if you have your libraries you check that all libraries are in your path (jars from hibernate lib directory + hibernate3.jar)you can add all libraries manual, too
best
[/img]I am at a lost here to understand……..
This is a workbench wizard which created the project. The workbench also compiled the source code…………..It all appears to compile correctly. It is the hot button that moves the war file over to the application server–JBoss. This Application Server uses logging and therefore has the common.logging package. I’ve added Hibernate 3.1.jar and dom4j.jar to the classpath for the server……..However, the only thing this does is moves me to another error.
I wish these tutorials from this site would include a section on configuration so I can spend more time learning the technology than chasing silly configuration errors.
Now I am stuck and the tutorial is absolutley useless to me…………
okay I’ve gotten the extra libraries added correctly………
But now the application is complaining about the some other darn thing about a duplicate data mapping configuration file……
I checked the directory and I did not see duplication. I looked at the hibernate configuration files and did not see any duplication………
[15:54:56,125] [INFO ] [Configuration] configuring from resource: /hibernate.cfg.xml [15:54:56,125] [INFO ] [Configuration] Configuration resource: /hibernate.cfg.xml [15:54:56,140] [INFO ] [Configuration] Reading mappings from resource: com/rrcorp/hibernate/Catalog.hbm.xml [15:54:56,156] [INFO ] [Mappings] duplicate import: com.rrcorp.hibernate.Catalog->com.rrcorp.hibernate.Catalog [15:54:56,156] [INFO ] [Mappings] duplicate import: com.rrcorp.hibernate.Catalog->Catalog [15:54:56,156] [INFO ] [HbmBinder] Mapping class: com.rrcorp.hibernate.Catalog -> catalog [15:54:56,156] [INFO ] [STDOUT] %%%% Error Creating SessionFactory %%%% [15:54:56,156] [INFO ] [STDOUT] org.hibernate.MappingException: Could not read mappings from resource: com/rrcorp/hibernate/Catalog.hbm.xml at org.hibernate.cfg.Configuration.addResource(Configuration.java:476) at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1414) at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1382) at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1363) at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1339) at org.hibernate.cfg.Configuration.configure(Configuration.java:1259) at com.rrcorp.hibernate.SessionFactory.currentSession(SessionFactory.java:48) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:28) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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: org.hibernate.MappingException: duplicate class mapping: com.rrcorp.hibernate.Catalog at org.hibernate.cfg.Mappings.addClass(Mappings.java:96) at org.hibernate.cfg.HbmBinder.bindRoot(HbmBinder.java:111) at org.hibernate.cfg.Configuration.add(Configuration.java:379) at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:418) at org.hibernate.cfg.Configuration.addResource(Configuration.java:473) ... 33 more [15:54:56,156] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception java.lang.NullPointerException at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:29) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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)This is getting tiresome……
Russ
You answer does not sound cogent. The way the tool generates the hibernate configuration file for the table, it places the file in the directory with all the other classes for hibernate (com.rrcorp.hibernate) The system can find the SessionFactory in the same directory, yet it can not find the hibernate configuration file? The JSP calls the SessionFactory before the query is executed (using the hibernate configuration file for the single table I would assume).
I’m not buying it……….
Russ
Russ,
You can make hibernate mapping files in some directory, but they must be in classpath on runtime.
I suppose, you made them out of source tree (probably in project’s root directory or directory src/com/rrcomp/hibernate/com/rrcomp/hibernate).Try to make them in source
directory of project and redeploy.
You followed an old tutorial and probably set source folder to ‘src/com/rr…’ – new ‘mapping configuration wizard’ has tow fields : ‘Java src folder’ and ‘Package’ – try set ‘src’ to ‘Java src folder’ field and your package to ‘Package’.Good luck
Ohhhh the pain…………
Okay I figured out that in the hibernate.cfg.xml file, one needs to edit the properties setting for the mapping element.
I followed your suggestion and populated the package name with “/com/rrcorp/hibernate” and the resource property with “/com/rrcorp/hibernate/Catalog.hbm.xml”
This appears to be working as I am not getting the same error any more, but I am now getting a familar eerror
[22:09:26,437] [INFO ] [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true [22:09:26,453] [INFO ] [PropertyMessageResources] Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [22:09:26,468] [INFO ] [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true [22:09:26,468] [INFO ] [PropertyMessageResources] Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true [22:09:26,625] [INFO ] [Environment] Hibernate 3.1 [22:09:26,671] [INFO ] [Environment] hibernate.properties not found [22:09:26,671] [INFO ] [Environment] using CGLIB reflection optimizer [22:09:26,671] [INFO ] [Environment] using JDK 1.4 java.sql.Timestamp handling [22:09:26,906] [INFO ] [Configuration] configuring from resource: /hibernate.cfg.xml [22:09:26,906] [INFO ] [Configuration] Configuration resource: /hibernate.cfg.xml [22:09:26,953] [INFO ] [Configuration] Reading mappings from resource: /com/rrcorp/hibernate/Catalog.hbm.xml [22:09:27,203] [INFO ] [HbmBinder] Mapping class: com.rrcorp.hibernate.Catalog -> catalog [22:09:27,281] [INFO ] [Configuration] Configured SessionFactory: null [22:09:27,281] [INFO ] [Configuration] processing extends queue [22:09:27,281] [INFO ] [Configuration] processing collection mappings [22:09:27,281] [INFO ] [Configuration] processing association property references [22:09:27,281] [INFO ] [Configuration] processing foreign key constraints [22:09:27,578] [INFO ] [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!) [22:09:27,578] [INFO ] [DriverManagerConnectionProvider] Hibernate connection pool size: 20 [22:09:27,593] [INFO ] [DriverManagerConnectionProvider] autocommit mode: false [22:09:27,609] [INFO ] [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/test [22:09:27,609] [INFO ] [DriverManagerConnectionProvider] connection properties: {user=root, password=root} [22:09:28,109] [INFO ] [SettingsFactory] RDBMS: MySQL, version: 5.0.16-nt [22:09:28,109] [INFO ] [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.11 ( $Date: 2005-09-21 18:20:03 +0000 (Wed, 21 Sep 2005) $, $Revision: 4287 $ ) [22:09:28,250] [INFO ] [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect [22:09:28,265] [INFO ] [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions) [22:09:28,281] [INFO ] [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) [22:09:28,281] [INFO ] [SettingsFactory] Automatic flush during beforeCompletion(): disabled [22:09:28,281] [INFO ] [SettingsFactory] Automatic session close at end of transaction: disabled [22:09:28,281] [INFO ] [SettingsFactory] JDBC batch size: 15 [22:09:28,281] [INFO ] [SettingsFactory] JDBC batch updates for versioned data: disabled [22:09:28,281] [INFO ] [SettingsFactory] Scrollable result sets: enabled [22:09:28,296] [INFO ] [SettingsFactory] JDBC3 getGeneratedKeys(): enabled [22:09:28,296] [INFO ] [SettingsFactory] Connection release mode: auto [22:09:28,296] [INFO ] [SettingsFactory] Maximum outer join fetch depth: 2 [22:09:28,296] [INFO ] [SettingsFactory] Default batch fetch size: 1 [22:09:28,296] [INFO ] [SettingsFactory] Generate SQL with comments: disabled [22:09:28,296] [INFO ] [SettingsFactory] Order SQL updates by primary key: disabled [22:09:28,296] [INFO ] [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory [22:09:28,312] [INFO ] [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory [22:09:28,312] [INFO ] [SettingsFactory] Query language substitutions: {} [22:09:28,312] [INFO ] [SettingsFactory] Second-level cache: enabled [22:09:28,312] [INFO ] [SettingsFactory] Query cache: disabled [22:09:28,312] [INFO ] [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider [22:09:28,359] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception java.lang.NoClassDefFoundError: net/sf/ehcache/CacheException at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2328) at java.lang.Class.getConstructor0(Class.java:2640) at java.lang.Class.newInstance0(Class.java:321) at java.lang.Class.newInstance(Class.java:303) at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:327) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:219) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1823) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1143) at com.rrcorp.hibernate.SessionFactory.currentSession(SessionFactory.java:49) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:28) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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) [22:09:57,906] [INFO ] [DriverManagerConnectionProvider] cleaning up connection pool: jdbc:mysql://localhost:3306/testHelp…I’m drowning here……..
Russ
Russ,
Look my screenshoot.Check ‘Hibernate 3.0 Advanced Support Libraries – your missing jars is here (ehcache)
Best regards
Russ,
There seems to be a forum issue displaying snpe’s screeenshot.
I apologize for the tutorials, the new hibernate capabilies are brand new and we are bringing the documentation up to speed now.Your problem is that you haven’t chosen “advanced hibernate libraries” while setting up your hibernate project.
The solution is:
Right click on your project and choose Properties, choos the Java Build Path tab.
Add Librarary > MyEclipse Libraries, make sure “Hibernate 3.0 Advanced Support libraries” is selected.
Click Finish.That sould fix it for you.
Another alternative would be to create a new hibernate project and make sure you select the advanced libraries while setting it up. You can just copy your existing project contents into it and everything should work out.
Let us know if you require further assistance,
Best,
Brian.Guys:
The root cause of my problem I am not sure, but what I do know is the project has BOTH hibernate libraries (Core and Advance) listed in the package explorer in the workbench. Yes, one of my earlier problems was the Advance library was not included in the project.
Brain’s suggestion may me think JBOSS may not have the Advance Libraries either, so I did some comparison with the JBOSS lib directory with the Advance Support Library. I picked out 7 jars not in the JBOSS lib. When I added them, The above error in my previous post went away, but I returned to this familiar error
[07:37:10,671] [INFO ] [Configuration] configuring from resource: /hibernate.cfg.xml [07:37:10,671] [INFO ] [Configuration] Configuration resource: /hibernate.cfg.xml [07:37:10,703] [INFO ] [Configuration] Reading mappings from resource: /com/rrcorp/hibernate/Catalog.hbm.xml [07:37:11,000] [INFO ] [HbmBinder] Mapping class: com.rrcorp.hibernate.Catalog -> catalog [07:37:11,062] [INFO ] [Configuration] Configured SessionFactory: null [07:37:11,078] [INFO ] [Configuration] processing extends queue [07:37:11,078] [INFO ] [Configuration] processing collection mappings [07:37:11,078] [INFO ] [Configuration] processing association property references [07:37:11,078] [INFO ] [Configuration] processing foreign key constraints [07:37:11,765] [INFO ] [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!) [07:37:11,765] [INFO ] [DriverManagerConnectionProvider] Hibernate connection pool size: 20 [07:37:11,765] [INFO ] [DriverManagerConnectionProvider] autocommit mode: false [07:37:11,781] [INFO ] [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/test [07:37:11,781] [INFO ] [DriverManagerConnectionProvider] connection properties: {user=root, password=root} [07:37:12,484] [INFO ] [SettingsFactory] RDBMS: MySQL, version: 5.0.16-nt [07:37:12,484] [INFO ] [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.11 ( $Date: 2005-09-21 18:20:03 +0000 (Wed, 21 Sep 2005) $, $Revision: 4287 $ ) [07:37:12,593] [INFO ] [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect [07:37:12,609] [INFO ] [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions) [07:37:12,625] [INFO ] [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) [07:37:12,625] [INFO ] [SettingsFactory] Automatic flush during beforeCompletion(): disabled [07:37:12,640] [INFO ] [SettingsFactory] Automatic session close at end of transaction: disabled [07:37:12,640] [INFO ] [SettingsFactory] JDBC batch size: 15 [07:37:12,640] [INFO ] [SettingsFactory] JDBC batch updates for versioned data: disabled [07:37:12,640] [INFO ] [SettingsFactory] Scrollable result sets: enabled [07:37:12,640] [INFO ] [SettingsFactory] JDBC3 getGeneratedKeys(): enabled [07:37:12,640] [INFO ] [SettingsFactory] Connection release mode: auto [07:37:12,640] [INFO ] [SettingsFactory] Maximum outer join fetch depth: 2 [07:37:12,640] [INFO ] [SettingsFactory] Default batch fetch size: 1 [07:37:12,640] [INFO ] [SettingsFactory] Generate SQL with comments: disabled [07:37:12,640] [INFO ] [SettingsFactory] Order SQL updates by primary key: disabled [07:37:12,640] [INFO ] [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory [07:37:12,656] [INFO ] [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory [07:37:12,656] [INFO ] [SettingsFactory] Query language substitutions: {} [07:37:12,656] [INFO ] [SettingsFactory] Second-level cache: enabled [07:37:12,656] [INFO ] [SettingsFactory] Query cache: disabled [07:37:12,656] [INFO ] [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider [07:37:12,687] [INFO ] [SettingsFactory] Optimize cache for minimal puts: disabled [07:37:12,687] [INFO ] [SettingsFactory] Structured second-level cache entries: disabled [07:37:12,703] [INFO ] [SettingsFactory] Statistics: disabled [07:37:12,703] [INFO ] [SettingsFactory] Deleted entity synthetic identifier rollback: disabled [07:37:12,703] [INFO ] [SettingsFactory] Default entity-mode: POJO [07:37:13,093] [INFO ] [SessionFactoryImpl] building session factory [07:37:13,312] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at net.sf.ehcache.CacheManager.<clinit>(CacheManager.java:86) at org.hibernate.cache.EhCacheProvider.start(EhCacheProvider.java:130) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:174) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1145) at com.rrcorp.hibernate.SessionFactory.currentSession(SessionFactory.java:49) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:28) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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)This leads me to conclude JBOSS 4.0.3SP1 may not have all the required jar files for Hibernate3.0 or the building process for the project is flawed…….
Russ
Russ,
If you expand all the hibernate library containers in your package view, do you see ehcache and commons-logging in there? These errors are run-of-the-mill classpath issues that shouldn’t be occuring, but are easily fixed.okay…….sorry it has taken my so long to respond, but duty called….. 😈
I am looking at my project…….
In the Package Explorer, I see the basic jars one gets when creating a Web Project. One of these jars is commons-logging…..
When I cared the Hibernate Capability I only selected the Core Libraries…
Two of the jars in this library are duplicates from the Web Project jars–collections and logging… The hibernate3.jar is there too…..When I discovered the advance library was missing….I added it. In this library, I see the ehcache-1.1.jar file.
So based on your comments, I am concluding the classpath is not getting updated……. I looked at the project’s properties and discovered all the llibraries and jar files were there…..Next I looked at the order of the classpath. Here I adjusted the order to put the Hibernate libraries before the individual jars and after the JDK and J22EE libraries.
Guess what happend?
[20:51:07,593] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception java.lang.NoClassDefFoundError: net/sf/ehcache/CacheException at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2328) at java.lang.Class.getConstructor0(Class.java:2640) at java.lang.Class.newInstance0(Class.java:321) at java.lang.Class.newInstance(Class.java:303) at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:327) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:219) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1823) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1143) at com.rrcorp.hibernate.SessionFactory.currentSession(SessionFactory.java:49) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:28) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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)I am using the workbench tool to deploy to JBOSS. I have done it two ways….Exploding Package and Package Archiving….In either case NONE of the Hibernate Core and Hibernate Advance libraries are making it over to the server… I added the Hibernate libraries to the classpath (prepended) and added to the path(append) myself just to get by the Hibernate issues.
I am inclined to believe we have a build or configuration issue. The libraries are not making it into the war file during the build process. As for the configuration issue, the server config is not right and should be updated to point to the core and advance libraries for Hibernate.
You guys are the experts, which one is it? Do you have another alternative?
Want to know what the problem is?
Under the Window>Preferences>MyEclipse>J2EE Project>WebProject> Under the Library Deployment Policies, select the Jars in Web Project’s user libraries.
Deduction and NOT documentation solved this issue……shame I wasted a DAY on this stupid configuration issue……Let me say thank you………. 😈21:36:29,640] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception org.hibernate.QueryException: addEntity() or addScalar() must be called on a sql query before executing the query. [SELECT (catalog.*) FROM catalog (catalog)] at org.hibernate.impl.SQLQueryImpl.verifyParameters(SQLQueryImpl.java:169) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:140) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:31) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) 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:159) 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)This tells me we are attempting to execute the query……All is working now….
The darn war file is 9MB when I deploy it as an archive……..GET OUT!
