PDA

View Full Version : Integrating BIRT 2.x



Lucho
03-27-2006, 12:05 AM
Do you have begun to integrate BIRT 2.0 in pentaho ?

If no, how can I do for doing this, because I have the BIRT 2.0 and I would like to try to integrate it.

In other way, I have a proble whith the pentaho wizard when I would like to publish a report with a database (postgresql). I have this error in my browser :


Erreur : [fr_198] The data object is not an IPentahoResultSet object (org.pentaho.jfree.JFreeReportComponent)

Debug : [fr_21] Starting execute of samples/reporting/testReportPentaho.xaction (org.pentaho.solution.SolutionEngine)
Debug : [fr_30] Getting runtime context and data (org.pentaho.solution.SolutionEngine)
Debug : [fr_33] Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
Debug : [fr_34] audit: instanceId=bf351865-bd67-11da-9804-3fbdcc5d9e72, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
Debug : [fr_1] validateComponent validating component org.pentaho.jfree.JFreeReportComponent (org.pentaho.runtime.RuntimeContext)
Debug : Validation du composant en cours pour laction {0} (org.pentaho.jfree.JFreeReportComponent)
Debug : [fr_42] Executing action sequence (org.pentaho.runtime.RuntimeContext)
Debug : [fr_24] Executing action definition: Iteration 0 (org.pentaho.runtime.RuntimeContext)
Debug : [fr_34] audit: instanceId=bf351865-bd67-11da-9804-3fbdcc5d9e72, objectId=org.pentaho.jfree.JFreeReportComponent, messageType=component_execution_started (org.pentaho.runtime.RuntimeContext)
Debug : [fr_3] execute pre-audit (org.pentaho.runtime.RuntimeContext)
Debug : [fr_21] Setting component log level to DEBUG (org.pentaho.runtime.RuntimeContext)
Debug : [fr_11] Initializing component (org.pentaho.runtime.RuntimeContext)
Debug : [fr_4] executeComponent starting audited execute (org.pentaho.runtime.RuntimeContext)
Debug : Exécute la validation=true (org.pentaho.jfree.JFreeReportComponent)
Erreur : [fr_198] The data object is not an IPentahoResultSet object (org.pentaho.jfree.JFreeReportComponent)
Debug : [fr_15] executeComponent finished audited execute (org.pentaho.runtime.RuntimeContext)
Erreur : RuntimeContext.ERROR_0012 - [fr_33] ActionDefinition for org.pentaho.jfree.JFreeReportComponent did not execute successfully (org.pentaho.runtime.RuntimeContext)
Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.solution.SolutionEngine)


The same report with the integrated database (sampledata) of pentaho workbench is working.

Thank your for your help.

Luc LABBE

Lucho
03-27-2006, 12:43 AM
I have resolved a part of the problem cause I have now this error :


Erreur : ConnectFactory.ERROR_0001 - [fr_1] Database connection could not be established to: PostgreSQLConnection (org.pentaho.component.SQLDataComponent)

Debug : [fr_21] Starting execute of samples/reporting/PostgreSQLReport.xaction (org.pentaho.solution.SolutionEngine)
Debug : [fr_30] Getting runtime context and data (org.pentaho.solution.SolutionEngine)
Debug : [fr_33] Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
Debug : [fr_34] audit: instanceId=4bec8488-bd6c-11da-86b1-af1a6acf478a, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
Erreur : ConnectFactory.ERROR_0001 - [fr_1] Database connection could not be established to: PostgreSQLConnection (org.pentaho.component.SQLDataComponent)
Erreur : SQLBaseComponent.ERROR_0006 - Impossible dexécuter {0} (org.pentaho.component.SQLDataComponent)
Erreur : RuntimeContext.ERROR_0012 - [fr_33] ActionDefinition for org.pentaho.jfree.JFreeReportComponent did not execute successfully (org.pentaho.runtime.RuntimeContext)
Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.solution.SolutionEngine)


I've got the impression that it doesn't found my Database connection. But, I have updated my jdbc.properties file :

MyJNDIConnection/type=javax.sql.DataSource
MyJNDIConnection/driver=org.hsqldb.jdbcDriver
MyJNDIConnection/url=jdbc:hsqldb:hsql://localhost/sampledata
MyJNDIConnection/user=pentaho_user
MyJNDIConnection/password=password
SampleData/type=javax.sql.DataSource
SampleData/driver=org.hsqldb.jdbcDriver
SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
SampleData/user=pentaho_user
SampleData/password=password
Quartz/type=javax.sql.DataSource
Quartz/driver=org.hsqldb.jdbcDriver
Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
Quartz/user=pentaho_user
Quartz/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=org.hsqldb.jdbcDriver
Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Shark/type=javax.sql.DataSource
Shark/driver=org.hsqldb.jdbcDriver
Shark/url=jdbc:hsqldb:hsql://localhost/shark
Shark/user=sa
Shark/password=
PostgreSQLConnection/type=javax.sql.DataSource
PostgreSQLConnection/driver=org.postgresql.Driver
PostgreSQLConnection/url=jdbc:postgresql://localhost:5432/postgres
PostgreSQLConnection/user=postgres
PostgreSQLConnection/password=xxxxx
This file is in this directory : {pentaho-demo}/pentaho-solutions/system/simple-jndi

I continue to search about it. If we know why I've this problem let me a message please.

Luc LABBE

Lucho
03-27-2006, 04:19 AM
I have found how we have to do :
For creating a report with your own database :

--> create a xml file in {pentaho-demo}/jboss/server/default/deploy/postgresqlconnection-ds.xml
--> put your .jar of your driver database connection inthis directory :
{pentaho-demo}/jboss/server/default/lib

And it's working very well.

For the syntax of the xml file we can copy the sampledata-ds.xml for example.


EDIT : ok, all is written in the doc "Create a pentaho solution". I'm sorry...

Luc LABBE

Post edited by: Lucho, at: 03/27/2006 08:38

mbatchelor
03-27-2006, 06:07 AM
BIRT doesn't use JNDI. Instead, it uses ODA. The datasource will need to be defined inside the report definition (.rptspec).

Hope this helps,

Marc