刚涉及pentaho,了解的不深,请各位师兄弟多多指教
首先:下载pentaho pentaho-solutions pentaho-data
其次:改pentaho的环境为tomcat容器识别的环境
新建WebRoot WEB-INF classes lib
将pentaho中third-party中的lib文件拷贝到lib文件夹中!
然后:配置jndi数据源
修改web.xml
<param-name></param-name>
solution-path pentaho-solution路径
放hsqldb.jar到 tomcat common/lib中
最后:启动pentaho-data 启动tomcat在eclipse中调试
我的tomcat jndi配置:
<Context path="/pentaho" docBase="F:\pentaho\test\pentaho\WebRoot\" debug="0" reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="pentaho_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/SampleData" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="100" maxIdle="30" maxWait="10000"
username="pentaho_user" password="password" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/Shark"/>
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="100" maxIdle="30" maxWait="10000"
username="pentaho_user" password="password" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/Hibernate"/>
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="100" maxIdle="30" maxWait="10000"
username="pentaho_user" password="password" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/quartz"/>
<Resource name="jdbc/Shark" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="100" maxIdle="30" maxWait="10000"
username="pentaho_user" password="password" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/Shark"/>
</Context>
