Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Problem with hibernate DB on MySQL

  1. #1
    Join Date
    Aug 2008
    Posts
    11

    Default Problem with hibernate DB on MySQL

    Hi, I have a problem with the hibernate DB created with the SampleDataDump_MySQL.sql file on MySQL 5. I have manually deployed pentaho 1.7.0.GA on Tomcat 5.5, ( Ant 1.7.1 and JVM 1.5 )created the hibernate,quartz,sampledata DB on MySQL, modified hibernate.cfg.xml,server.xml and all the other steps indicated in http://wiki.pentaho.com/display/Pent...ent+of+Pentaho.
    Pentaho runs, I can log in with any pre-definied user but when I try to go to menu "Navigate\Solutions" I got this error:
    ----------------------------------------------------------------------
    Il server della Piattaforma Pentaho BI è pronto.
    2008/09/03 12:55:13:609 CEST [INFO] balancer] - org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
    2008/09/03 12:55:13:859 CEST [INFO] jsp-examples] - ContextListener: contextInitialized()
    2008/09/03 12:55:13:859 CEST [INFO] jsp-examples] - SessionListener: contextInitialized()
    2008/09/03 12:55:14:718 CEST [INFO] servlets-examples] - ContextListener: contextInitialized()
    2008/09/03 12:55:14:718 CEST [INFO] servlets-examples] - SessionListener: contextInitialized()
    12:55:39,500 ERROR [JDBCExceptionReporter] Table 'hibernate.contentitem' doesn't exist
    12:55:39,546 ERROR [[UserContent]] Servlet.service() for servlet UserContent threw exception
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.contentitem' doesn't exist
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2220)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at org.pentaho.repository.content.ContentRepository.getBackgroundExecutedContentItemsForUser(ContentRepository.java:234)
    at org.pentaho.plugin.quartz.QuartzBackgroundExecutionHelper.getBackgroundExecutedContentList(QuartzBackgroundExecutionHelper.java:161)
    at org.pentaho.ui.component.UserFilesComponent.addExecutedlist(UserFilesComponent.java:183)
    at org.pentaho.ui.component.UserFilesComponent.addFiles(UserFilesComponent.java:132)
    at org.pentaho.ui.component.UserFilesComponent.getXmlContent(UserFilesComponent.java:125)
    at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:46)
    at org.apache.jsp.jsp.UserContent_jsp._jspService(UserContent_jsp.java:127)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Unknown Source)
    -----------------------------------------------------------------------------------------------
    The problems seems to be in the hibernate DB ; I have the same problem when , after publishing a report on the server, I try to run it.
    Could someone help me ? There is a script with the correct hibernate db?
    Thanks, Arfiooo

  2. #2
    Join Date
    Aug 2008
    Posts
    11

    Default

    I found the solution at my problem : had to modify the dialect property on hibernate.cfg.xml file and set it to:

    org.hibernate.dialect.MySQLDialect.

    Hope it can help.

  3. #3

    Default HibernateUtil Problem

    I have installed 1.7 on OpenSolaris on Tomcat and Java 1.6.

    I have followed the Wiki for the Tomcat install and can access the main Pentaho splash page; however, when I try to select one of the users and login, I get the following error:

    type Exception report

    message

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

    exception

    javax.servlet.ServletException: Filter execution threw an exception
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    root cause

    java.lang.NoClassDefFoundError: Could not initialize class org.pentaho.repository.HibernateUtil
    org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:75)
    org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1144)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:205)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169)
    org.pentaho.core.system.PentahoSystem.sessionStartup(PentahoSystem.java:832)
    com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:70)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
    org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)

    I have verified that the "hibuser" can log into the MySQL database. I have also verified various config files to make sure that the hibuser is set correctly. I have also looked through the forums for errors with Hibernate and followed advice where appropriate. Any ideas?

    My server is setup to only allow MySQL connections from localhost. Remote users must use an SSH tunnel. So, this could be the issue in that there is something that is violating the connection?

    BR,
    BillW

  4. #4

    Default

    well the answer will lie in hibernate.cfg.xml, but without seeing it its hard to give much advice
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  5. #5

    Default

    Here is my hibernate.cfg.xml. I left the server to localhost as documented in http://www.pentaho-wiki.com/wiki/HOW...guring_Pentaho



    Code:
    <?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-configuration
      PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">^M
    <hibernate-configuration>
      <session-factory>
      
            <property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</
    property>
    
        <property name="hibernate.generate_statistics">true</property>
        <property name="hibernate.cache.use_query_cache">true</property>
      
        <!--  MySQL Configuration -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>^M
        <property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property
    >
        <property name="dialect">org.pentaho.repository.MySQL5InnoDBDialect</property>
        <property name="connection.username">hibuser</property>
        <property name="connection.password">password</property>
        <property name="connection.pool_size">10</property>
        <property name="show_sql">false</property>
        <property name="hibernate.jdbc.use_streams_for_binary">true</property>
      </session-factory>
    </hibernate-configuration>
    Thanks for the help. I have deployed the PCI many times, but this is the first manual install, and I have gotten a bit frustrated.

    Bill

  6. #6

    Default

    so just to clarify, from the command line on the pentaho server, not the mysql server, you can log onto mysql using hibuser, using the details you provided in the hibernate.cfg.xml file?

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  7. #7

    Default

    Yep. I can log in from the command line and access Quartz, Hibernate and run queries.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.