PDA

View Full Version : Dashboard integration with webapp



mstacey
03-14-2007, 01:32 PM
Hi,

I have a web application that I would like to add pentaho dashboard functionality to, but rather than accessing this functionality from http://localhost/pentaho, I would like to see it seemlessly embedded in my own application.

How can I go about doing this? I have a struts based application utilising tiles for layout running on jboss 4. I would like the dashboards to appear in the main section of the web page surrounded by the menu and header section of the page.

Will I need to deploy certain elements of pentaho directly in to my web app, or can I create tiles definitions that link to jsp pages defined in the solutions folder via the pentaho ear deployment. Would portlets be necessary to achieve this?

thanks!

Mark

gmoran
03-16-2007, 03:59 PM
Here's the short of it - your best route is to embed Pentaho along with your app. Going the "link to .jsp" route can and probably will leave you with URL issues between web apps. So our best advice is to embed Pentaho and use the Pentaho API to do the dashboarding within your Struts application. You can check out the SampleDashboard.jsp that comes with the PCI demo to see the classes that facilitate this.

Also, if you look at our portlet implementation, you will see that they rely on the same API. So whether you use portlets or the API directly, it would be an embedding exercise.

mstacey
03-20-2007, 07:11 AM
Thanks Gretchen, is there any documentation or tips on this?

I'd like to try to start with the bare minimum required for what I want to start with and add more libraries as I need more pentaho functionality. I'll probably just start with some basic libraries and figure out classpath exceptions.

thanks!

Mark

astrid_mv20
05-10-2007, 11:51 AM
Hello Gretchen,

I read your answer to Mark about “Dashboard Integration with WebApp” on 03-16-2007. I tried to understand it because I have a very similar situation using Jakarta Tomcat 5.0 with Struts and Tiles. However, I would like to ask you what is the meaning of “to embed Pentaho and use the Pentaho API to do the dashboarding within your Struts application”

It would mean that I could insert Pentaho file directory inside the file directory of my web application. For instance, I have now the following configuration:




\jakarta-tomcat-5.0.30
|____\webapps
|______\pentaho
|______\estadisticas

Where \estadisticas is associated with my webapp and \pentaho corresponds to Pentaho solution. Then, I may suggest the following configuration

\jakarta-tomcat-5.0.30
|____\webapps
|______\estadisticas
|______\pentaho


Is this the right way to understand your proposal???

Your insight to this issue will be helpful.

Thanks and all the best
Forward Message

mstacey
05-14-2007, 05:39 AM
Hi,

You may have to embed your pentaho further in to your web application.

If estadisticas is your web app, you will need to place the required pentaho libraries in your lib folder for this app. The estadisticas/WEB-INF/web.xml will also need to contain the required pentaho servlets, listeners and filters.

I worked through mine by trial and error, I knew I wasn't going to need all the pentaho functionality, so I only added libraries where I had ClassNotFoundExceptions when trying to get the dashboard functionality working.

The other configuration property in web.xml you'll need to consider is where to place you pentaho-solutions folder. I placed this directly below my jboss installation folder and configured web.xml to look here for xactions etc.

Hope that helps!

Mark

noris
05-23-2007, 03:56 AM
Hello,

I refer to the suggestion made by mstacey:

"The other configuration property in web.xml you'll need to consider is where to place you pentaho-solutions folder. I placed this directly below my jboss installation folder and configured web.xml to look here for xactions etc."

I want to embed Pentaho dashboard functionality in my own webapplication, but I don't know how to configure web.xml to look for xactions?


Thanks for helping
noris


Ok, thats how one has to define the location of the solution folder in web.xml:

<context-param>
<param-name>solution-path</param-name>
<param-value>c:\pentaho-solutions\</param-value>
</context-param>

noris

noris
05-24-2007, 07:22 AM
Hello,

could anyone please provide me with the essential libs, changes to web.xml neccesary to embed Pentaho's dashboard functionality into another webapplication?

Is there a documentation on how to integrate Pentaho's dashboard functionality into another webapplication?

thanks
noris

mstacey
05-24-2007, 09:44 AM
Hi noris,

The web.xml file in

pentaho_j2ee_deployments-1.2.0.534-GA\pentaho-webapp\WEB-INF

is where you will find what to merge with your own web.xml file, and the libraries in

pentaho_j2ee_deployments-1.2.0.534-GA\pentaho-third-party

are what will go in your web application lib folder. You'll probably end up having to resolve classpath dependencies and the like, but at least you'll have a starting point!

Mark

noris
05-25-2007, 04:59 AM
Hi Mark,

thanks for replying!

What about the JARs in pentaho_j2ee_deployments-1.2.1.625-GA\pentaho-jars like pentaho-core-1.2.1.jar, pentaho-ui-1.2.1.jar etc.?
They are imported e.g. into SampleDashboard.jsp of the Pentaho demo, so they are needed to make a dashboard work! Am I right?

Thats what I did:

1. I put the libraries in
pentaho_j2ee_deployments-1.2.0.534-GA\pentaho-third-party and pentaho_j2ee_deployments-1.2.1.625-GA\pentaho-jars into my web application lib folder.

2. From the web.xml file in
pentaho_j2ee_deployments-1.2.0.534-GA\pentaho-webapp\WEB-INF
I took the following filters, listeners and servlets and put them into my waebapp's web.xml:



<filter>
<filter-name>SystemStatusFilter</filter-name>
<filter-class>org.pentaho.core.system.SystemStatusFilter</filter-class>
<init-param>
<param-name>initFailurePage</param-name>
<param-value>InitFailure</param-value>
<description>This page is displayed if the PentahoSystem fails to properly initialize.</description>
</init-param>
</filter>

<filter-mapping>
<filter-name>SystemStatusFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

<listener>
<listener-class>org.pentaho.core.session.PentahoHttpSessionListener</listener-class>
</listener>


<listener>
<listener-class>org.pentaho.core.system.SolutionContextListener</listener-class>
</listener>


<servlet>
<servlet-name>SampleDashboard</servlet-name>
<jsp-file>/jsp/SampleDashboard.jsp</jsp-file>
</servlet>

<servlet-mapping>
<servlet-name>SampleDashboard</servlet-name>
<url-pattern>/SampleDashboard</url-pattern>
</servlet-mapping>


3. Then I defined a datasource in the web.xml and jboss-web.xml and put mydatasource-ds.xml into the deploy folder of Jboss.

But when running Jboss I get the following Exception:


[exec] 11:24:32,870 ERROR [org.quartz.utils.JNDIConnectionProvider] Error looking up datasource: Quartz not bound
[exec] javax.naming.NameNotFoundException: Quartz not bound
[exec] at org.jnp.server.NamingServer.getBinding(NamingServer.java:491)
[exec] at org.jnp.server.NamingServer.getBinding(NamingServer.java:499)
[exec] at org.jnp.server.NamingServer.getObject(NamingServer.java:505)
[exec] at org.jnp.server.NamingServer.lookup(NamingServer.java:278)
[exec] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:544)
[exec] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:520)
[exec] at javax.naming.InitialContext.lookup(InitialContext.java:347)
[exec] at org.quartz.utils.JNDIConnectionProvider.init(JNDIConnectionProvider.java:127)
[exec] at org.quartz.utils.JNDIConnectionProvider.<init>(JNDIConnectionProvider.java:103)
So I added quartz-ds.xml to my deploy folder and jboss startet. But when trying to execute the SampleDashboard.jsp I get the following Exception:


[exec] 11:30:20,923 ERROR [org.pentaho.repository.HibernateUtil] HIBUTIL.ERROR_0006 - Building SessionFactory failed.
[exec] org.hibernate.HibernateException: /hibernate.cfg.xml not found
[exec] at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
[exec] at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1287)
[exec] at org.hibernate.cfg.Configuration.configure(Configuration.java:1309)
[exec] at org.hibernate.cfg.Configuration.configure(Configuration.java:1296)
[exec] at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:117)
[exec] at org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:83)
[exec] at org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
[exec] at org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1016)
[exec] at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
[exec] at org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:162)
[exec] at org.pentaho.ui.component.charting.PieDatasetChartComponent.createChart(PieDatasetChartComponent.java:78)
[exec] at org.pentaho.ui.component.charting.PieDatasetChartComponent.getXmlContent(PieDatasetChartComponent.java:162)
[exec] at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:41)
[exec] at org.pentaho.ui.ChartHelper.doPieChart(ChartHelper.java:125)
[exec] at org.apache.jsp.jsp.SampleDashboard_jsp._jspService(SampleDashboard_jsp.java:139)
[exec] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
[exec] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
[exec] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
[exec] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
[exec] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
[exec] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
[exec] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:150)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
[exec] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
[exec] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
[exec] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
[exec] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
[exec] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
[exec] at java.lang.Thread.run(Thread.java:534)
[exec] 11:30:20,954 ERROR [org.jboss.web.localhost.Engine] StandardWrapperValve[SampleDashboard]: Servlet.service() for servlet SampleDashboard threw exception
[exec] java.lang.ExceptionInInitializerError
[exec] at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:155)
[exec] at org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:83)
[exec] at org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
[exec] at org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1016)
[exec] at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
[exec] at org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:162)
[exec] at org.pentaho.ui.component.charting.PieDatasetChartComponent.createChart(PieDatasetChartComponent.java:78)
[exec] at org.pentaho.ui.component.charting.PieDatasetChartComponent.getXmlContent(PieDatasetChartComponent.java:162)
[exec] at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:41)
[exec] at org.pentaho.ui.ChartHelper.doPieChart(ChartHelper.java:125)
[exec] at org.apache.jsp.jsp.SampleDashboard_jsp._jspService(SampleDashboard_jsp.java:139)
[exec] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
[exec] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
[exec] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
[exec] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
[exec] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
[exec] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
[exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
[exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
[exec] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
[exec] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:150)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[exec] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
[exec] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
[exec] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
[exec] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
[exec] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
[exec] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
[exec] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
[exec] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
[exec] at java.lang.Thread.run(Thread.java:534)
[exec] Caused by: org.hibernate.HibernateException: /hibernate.cfg.xml not found
[exec] at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
[exec] at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1287)
[exec] at org.hibernate.cfg.Configuration.configure(Configuration.java:1309)
[exec] at org.hibernate.cfg.Configuration.configure(Configuration.java:1296)
[exec] at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:117)
[exec] ... 52 more
[exec] 11:38:09,245 ERROR [org.jboss.web.localhost.Engine] StandardWrapperValve[SampleDashboard]: Servlet.service() for servlet SampleDashboard threw exception
[exec] java.lang.NoClassDefFoundError
[exec] at org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
[exec] at org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1016)
[exec] at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)


Obviously my webapp tries use hibernate which ships configured with the pentaho-demo to use hypersonic!?

DO I need Quartz or Hibernate to make a Dashboard work? How can I get rid of that? Do I have to apply changes to pentaho-solutions/system/pentaho.xml?


Thanks
noris

mstacey
05-28-2007, 05:21 AM
Actually, I haven't upgraded to pentaho 1.2.1 yet, but I think there was a pentaho-core.jar in both those locations? Do you have two versions of this file (and others) around?

I think you need a lot more in the web.xml file - I merged in all of the servlets that are used, such as DisplayChart, GetChart, GetImage as an example. I don't need all of them but I'll remove the ones I don't need later.

I don't need Quartz either, so I removed those datasources and references. In terms of your hibernate error you will need to have the .hbm.xml files available on your classpath (like ContentItem.hbml.xml) and you will need to tell pentaho that you are using App Server managed datasources, see references to hibernateManaged and hibernateConfigPath in the web.xml file.

I suppose a lot depends on what you are trying to achieve, do you want to run all the pentaho demos using your app or do you just want to run the dashboard and use a few of the pentaho functional areas? I only need the dashboard for the moment, so I'm not worried about mondrian, kettle, scheduling, etc, so I haven't included the jar files until necessary. Have a look back over the installation documentation now that you are more familiar with the pentaho set up. It might help clear a few things up.

Mark

noris
05-29-2007, 06:48 AM
Hi Mark,

I also only need the dashboard! I want to integrate pentaho dashboard into my Webapp and thus display my own data using the dashboard.

I merged in all of the servlets and have the .hbm.xml files available on my classpath, as you suggested. But I'm not sure about the container-specific hibernate configuration:

<context-param>
<param-name>hibernateConfigPath</param-name>
<param-value>system/hibernate/hibernate-jboss-managed.xml</param-value>
</context-param>

hibernate-jboss-managed.xml (I configured the PentahoHibernate-ds.xml according to my oracle db settings):


<?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">
<hibernate-configuration>
<session-factory name="java:Pentaho/SessionFactory" >
<!-- CacheProviderClass -->

<property name="connection.datasource">Hibernate</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
<property name="show_sql">false</property>
<property name="session_factory_name">hibernate/HibernateFactory</property>
</session-factory>
</hibernate-configuration>
Now I'm running into the following exception:



java.lang.ExceptionInInitializerError
org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:155)
org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:83)
org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:1016)
org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:162)
org.pentaho.ui.component.charting.PieDatasetChartComponent.createChart(PieDatasetChartComponent.java:78)
org.pentaho.ui.component.charting.PieDatasetChartComponent.getXmlContent(PieDatasetChartComponent.java:162)
org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:41)
org.pentaho.ui.ChartHelper.doPieChart(ChartHelper.java:125)
org.apache.jsp.jsp.SampleDashboard_jsp._jspService(SampleDashboard_jsp.java:139)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)


That's at least one small step ahead!

Thanks
noris

mstacey
05-29-2007, 06:54 AM
The line

<property name="connection.datasource">Hibernate</property>
is used to tie the Pentaho Hibernate settings to your deployed datasources. You need to make sure that your *-ds.xml file has the configuration property in your deploy folder, so for instance, in my hibernate-jboss-managed.xml,

<property name="connection.datasource">java:/appDS</property>
matches

<jndi-name>appDS</jndi-name>

in app-ds.xml

noris
05-29-2007, 10:50 AM
IT WORKS, finally!!!!!!!!

Thank you Mark :)

bupathirajha
06-20-2007, 10:21 AM
I'm trying to integrate pentaho with my web application. I followed the steps in this thread and end with the following error.

My web.xml contains all servlets, filters and references

and I changed these lines for hibernate configuration.
<context-param>
<param-name>hibernateManaged</param-name>
<param-value>system/hibernate/hibernate.cfg.xml</param-value>
</context-param>
<context-param>
<param-name>hibernateConfigPath</param-name>
<param-value>system/hibernate/hibernate-jboss-managed.xml</param-value>
</context-param>

and WEB-INF/classes folder contains .hbm.xml files (all the files and folders in pentaho-classes which is in j2ee deployments folder)

Also I put hibernate.cfg.xml in system/hibernate folder.

I also checked the datasource name in PentahoHibernate-ds.xml and hibernate-jboss-managed.xml

When I run pivot.jsp i got the following error , Can anyone solve this issue?

Thanks in advance.

Error Log:

17:53:16,734 ERROR [HibernateUtil] HIBUTIL.ERROR_0006 - Building SessionFactory failed.
java.lang.ClassCastException: org.jboss.tm.TxManager
at org.hibernate.transaction.JNDITransactionManagerLookup.getTransactionManager(JNDITransactionManagerLookup.java:23)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:304)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1145)
at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:137)
at org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:81)
at org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
at org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:944)
at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
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.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
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)
17:53:16,921 INFO [STDOUT] java.lang.NoClassDefFoundError
17:53:16,921 INFO [STDOUT] at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.java:610)
17:53:16,921 INFO [STDOUT] at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints(StandaloneApplicationContext.java:118)
17:53:16,921 INFO [STDOUT] at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.java:1051)
17:53:16,921 INFO [STDOUT] at org.apache.jsp.jsp.Pivot_jsp._jspService(org.apache.jsp.jsp.Pivot_jsp:1482)
17:53:16,921 INFO [STDOUT] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
17:53:16,921 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:53:16,921 INFO [STDOUT] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
17:53:16,921 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
17:53:16,921 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
17:53:16,921 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:16,921 INFO [STDOUT] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:16,921 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:53:16,921 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
17:53:16,921 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
17:53:16,921 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:53:16,921 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:53:16,921 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:53:16,921 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
17:53:16,921 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:53:16,921 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
17:53:16,921 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
17:53:16,921 INFO [STDOUT] java.lang.NoClassDefFoundError
17:53:16,937 INFO [STDOUT] at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.java:616)
17:53:16,937 INFO [STDOUT] at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints(StandaloneApplicationContext.java:118)
17:53:16,937 INFO [STDOUT] at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.java:1051)
17:53:16,937 INFO [STDOUT] at org.apache.jsp.jsp.Pivot_jsp._jspService(org.apache.jsp.jsp.Pivot_jsp:1482)
17:53:16,937 INFO [STDOUT] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
17:53:17,437 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:53:17,437 INFO [STDOUT] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
17:53:17,437 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
17:53:17,437 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
17:53:17,437 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:17,437 INFO [STDOUT] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
17:53:17,437 INFO [STDOUT] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
17:53:17,437 INFO [STDOUT] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:17,437 INFO [STDOUT] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:17,437 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:53:17,437 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
17:53:17,437 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
17:53:17,437 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:53:17,437 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:53:17,437 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:53:17,437 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
17:53:17,937 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:53:17,937 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
17:53:17,937 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
17:53:17,937 INFO [STDOUT] 17:53:17,937 ERROR [RequestFilter] exeption
javax.servlet.ServletException
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
at org.apache.jsp.jsp.Pivot_jsp._jspService(org.apache.jsp.jsp.Pivot_jsp:1490)
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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
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)
17:53:18,437 INFO [STDOUT] 17:53:18,437 ERROR [RequestFilter] cause
java.lang.ExceptionInInitializerError
at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:153)
at org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:81)
at org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
at org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:944)
at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
at org.apache.jsp.jsp.Pivot_jsp.getRuntimeForQuery(org.apache.jsp.jsp.Pivot_jsp:83)
at org.apache.jsp.jsp.Pivot_jsp._jspService(org.apache.jsp.jsp.Pivot_jsp:273)
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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
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: java.lang.ClassCastException: org.jboss.tm.TxManager
at org.hibernate.transaction.JNDITransactionManagerLookup.getTransactionManager(JNDITransactionManagerLookup.java:23)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:304)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1145)
at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:137)
... 40 more
17:53:18,937 INFO [STDOUT] 17:53:18,937 INFO [RequestFilter] redirecting to error page PivotError
17:53:18,968 INFO [STDOUT] 17:53:18,968 INFO [RequestFilter] Request Execution total time: 9156 ms

mstacey
06-20-2007, 10:35 AM
Hi bupathirajha,

Can't help you out too much, but hidden in the stack trace is the following:

java.lang.NoClassDefFoundError

But I'm not sure if this is the cause of the stack trace (in which case you are missing something from your classpath), of it is as a result of the stack trace (and a constructor threw an exception).

I also don't have hibernate.cfg.xml in system/hibernate folder. Maybe try removing this file.

Mark

sutcha
06-29-2007, 03:58 AM
Hallo,

I am trying to embed the pentaho dashboard in my webapp. I don't know much about webapps, still learning about it ;)

In the documentation I read about *.widget.xml where I can configure the charts used in the dashboard. these xmls are in the pentaho-solution-directory. They should be in the deployment directory too, shouldn't they?

How can I start the webapp using TomCat?

Sacha

mstacey
06-29-2007, 05:12 AM
Hi Sacha,

I'm running in JBoss so I can only really describe how it's set up for me. I have a c:\jboss\pentaho-solutions folder with the necessary xactions and widget.xmls. In web.xml, I specify this folder as follows:



<context-param>
<param-name>solution-path</param-name>
<param-value>..\pentaho-solutions</param-value>
</context-param>
As JBoss is started from c:\jboss\bin, this becomes the current working directory, and pentaho-solutions sits a level above bin\. So you don't need it in your deploy folder as well.

You'll have to check the documentation for tomcat, Jboss uses and embedded tomcat.

Mark

sutcha
07-13-2007, 07:07 AM
Where can I get the Source of ChartHelper?
I don't really like the way it works. I want to code the dashboard on another way that will be easier to embed...

mstacey
09-07-2007, 06:07 AM
Hi Vijay,

see post dated 05-29-2007, 05:54 AM

Mark

mstacey
09-07-2007, 08:24 AM
Its post number 12, I've pasted it below, see if it resolves your problem!

The line

<property name="connection.datasource">Hibernate</property>
is used to tie the Pentaho Hibernate settings to your deployed datasources. You need to make sure that your *-ds.xml file has the configuration property in your deploy folder, so for instance, in my hibernate-jboss-managed.xml,

<property name="connection.datasource">java:/appDS</property>
matches

<jndi-name>appDS</jndi-name>

in app-ds.xml