Integrate a Custom Oda Driver in a Java Program?

Important would be, how to change:
- plugin.xml
- plugin.properties
of the the google oda runtime folder

And what anything else i have to change, to run the google oda
example within of the java class?

thx+best wishes
Jenny

Has nobody an answer? 
 
Please could you try, take a custom oda driver (csv, hibernate) and try to integrate it in that example: 
 
<a class='bbc_url' href='http://wiki.eclipse.org/Java_-_Build_Dynamic_Table_(BIRT)'>Java - Build Dynamic Table (BIRT) - Eclipsepedia</a> 
 
May I get a feedback if it will working, please?

Thank you+Greetings

Jenny,

It looks like your issue is that your oda runtime plugin is not in the plugins directory of the runtime.
ie
config.setProperty("BIRT_HOME", "C:/java/birt-runtime-2_5_0/ReportEngine");

Your code is correct I believe.

Jason

Here was my modified code with attached plugins

package DEAPI;

import java.io.IOException;
import java.util.ArrayList;

import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.model.api.CellHandle;
import org.eclipse.birt.report.model.api.DataItemHandle;
import org.eclipse.birt.report.model.api.DesignConfig;
import org.eclipse.birt.report.model.api.ElementFactory;
import org.eclipse.birt.report.model.api.IDesignEngine;
import org.eclipse.birt.report.model.api.IDesignEngineFactory;
import org.eclipse.birt.report.model.api.LabelHandle;
import org.eclipse.birt.report.model.api.OdaDataSetHandle;
import org.eclipse.birt.report.model.api.OdaDataSourceHandle;
import org.eclipse.birt.report.model.api.PropertyHandle;
import org.eclipse.birt.report.model.api.ReportDesignHandle;
import org.eclipse.birt.report.model.api.RowHandle;
import org.eclipse.birt.report.model.api.SessionHandle;
import org.eclipse.birt.report.model.api.StructureFactory;
import org.eclipse.birt.report.model.api.TableHandle;
import org.eclipse.birt.report.model.api.activity.SemanticException;
import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn;

import com.ibm.icu.util.ULocale;

/**
* Simple BIRT Design Engine API (DEAPI) demo.
*/

public class CopyDECreateDynamicTable
{
ReportDesignHandle designHandle = null;
ElementFactory designFactory = null;
StructureFactory structFactory = null;

public static void main( String[] args )
{
try
{
CopyDECreateDynamicTable de = new CopyDECreateDynamicTable();

de.buildReport();
}
catch ( IOException e )
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch ( SemanticException e )
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}

void buildDataSource( ) throws SemanticException
{

OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource("Data Source", "myodaruntime" );
//dsHandle.setProperty( "odaDriverClass","myodaruntime.Driver" );
dsHandle.setProperty( "property1", "modified property1" );

designHandle.getDataSources( ).add( dsHandle );

}

void buildDataSet() throws SemanticException
{

OdaDataSetHandle dsHandle = designFactory.newOdaDataSet( "ds",
"myodaruntime.dataSet" );
dsHandle.setDataSource( "Data Source" );
dsHandle.setQueryText( "This query does nothing" );

designHandle.getDataSets( ).add( dsHandle );

}
void buildReport( ) throws IOException, SemanticException
{

DesignConfig config = new DesignConfig( );
config.setBIRTHome("C:/birt/birt-runtime-2_5_0/birt-runtime-2_5_0/ReportEngine");
IDesignEngine engine = null;
try{

Platform.startup( config );
IDesignEngineFactory factory = (IDesignEngineFactory) Platform
.createFactoryObject( IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY );
engine = factory.createDesignEngine( config );

}catch( Exception ex){
ex.printStackTrace();
}

SessionHandle session = engine.newSessionHandle( ULocale.ENGLISH ) ;

try{
//open a design or a template
designHandle = session.createDesign();

designFactory = designHandle.getElementFactory( );

buildDataSource();
buildDataSet();

TableHandle table = designFactory.newTableItem( "table",2 );
table.setWidth( "100%" );
table.setDataSet( designHandle.findDataSet( "ds" ) );

PropertyHandle computedSet = table.getColumnBindings( );
ComputedColumn cs1 = null;
cs1 = StructureFactory.createComputedColumn();
cs1.setName("MyCol1");
cs1.setExpression("dataSetRow["Column1"]");
computedSet.addItem(cs1);

// table header
RowHandle tableheader = (RowHandle) table.getHeader( ).get( 0 );

LabelHandle label1 = designFactory.newLabel( "Column1" );
label1.setText("Column One");
CellHandle cell = (CellHandle) tableheader.getCells( ).get( 0 );
cell.getContent( ).add( label1 );

// table detail
RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );
CellHandle mydatacell = (CellHandle) tabledetail.getCells( ).get( 0 );
DataItemHandle data = designFactory.newDataItem( "data_1" );
data.setResultSetColumn( "MyCol1");
mydatacell.getContent( ).add( data );

designHandle.getBody( ).add( table );

// Save the design and close it.

designHandle.saveAs( "output/desample/sampleoda.rptdesign" ); //$NON-NLS-1$
designHandle.close( );
Platform.shutdown();
System.out.println("Finished");
}catch (Exception e){
e.printStackTrace();
}

}
}

Hi Jason, 
 
sry for my late answer, but i was on vacation. 
 
I don´t know why, bu it doesn´t work. 
I get the following exception again: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
java.lang.NullPointerException
at Demo.CopyDECreateDynamicTable.buildDataSource(CopyDECreateDynamicTable.java:63)
at Demo.CopyDECreateDynamicTable.buildReport(CopyDECreateDynamicTable.java:109)
at Demo.CopyDECreateDynamicTable.main(CopyDECreateDynamicTable.java:44)

</pre>
 
I have done that actions: 
- Copy your modified class CopyDECreateDynamicTable in my package 
- Change the path to my birtengine 
- Copy the both jars (myodaruntime_1.0.0.200908191722.jar & myodadesigner_1.0.0.200908191722.jar) into eclipseplugins folder 
- Running the java-programm 
 
Jason, please could you say me what am I doing wrong? 
 
Thank you in advance. 
 
Best regards 
Jenny

Jenny,

Does a normal datasource work?

Jason

Hello Jason, 
 
that example under that link: 
<a class='bbc_url' href='http://wiki.eclipse.org/Java_-_Build_Dynamic_Table_(BIRT)'>Java - Build Dynamic Table (BIRT) - Eclipsepedia</a> 
 
works perfectly. 
 
Probably your example works on your environment, or? 
And you did that operations, like me: 
- Copy your modified class CopyDECreateDynamicTable in my package 
- Change the path to my birtengine 
- Copy the both jars (myodaruntime_1.0.0.200908191722.jar & myodadesigner_1.0.0.200908191722.jar) into eclipseplugins folder 
- Running the java-programm 
 
If yes, I am at my wit´s end.

Hopefully you have another hint for me. 
 
Best regards 
Jenny

Jenny,

Did you use the jars that I attached? If not can you try them? The oda plugins have to be exported using the manifest editor to deploy them.

Jason

Jason,

Yes, i used your jars.

I copied both jars

- myodaruntime_1.0.0.200908191722.jar
- myodadesigner_1.0.0.200908191722.jar

into the folder eclipseplugins. Is it right?

After a restart of eclipse, I run your modified Java - class CopyDECreateDynamicTable
and i got the exception.

In Line 63:the method buildDataSource can´t called successfully. I don´t know, why?
Demo.CopyDECreateDynamicTable.buildDataSource(CopyDECreateDynamicTable.java:63)

Thx
Jenny

Jenny,

You should copy the plugins to this directory:
config.setBIRTHome("C:/birt/birt-runtime-2_5_0/birt-runtime-2_5_0/ReportEngine");

plus plugins. So whereever you set your runtime/plugins

Jason

Hi Jason,

thank you very much for your great help.

Now it works, my mistake was that i put the jars into the eclipseplugins folder and not into the ReportEngineplugins folder.

Have a nice day.

Bye
Jenny

Good to hear(read).

Jason

nallaiah

based on Db values have to generate the Report file as view PDF give me example its need ful

Hi, I have a custom oda driver (runtime and design). I have exported both of them into the
C:/birt-runtime-2_6_1/ReportEngine and into eclipse/plugins. If I run my oda driver by launching an eclipse application, it works fine. However when I try to run the report in my workspace, it does not work and I get the following error:

The driver odaruntime_driver's initial entry point cannot be found or cannot be instantiated.
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Unable to load or instantiate the custom ODA driver class. (odaruntime_driver.impl.Driver) ;
java.lang.ClassNotFoundException: odaruntime_driver.impl.Driver
..........

When I try to run the report from my java project I get the following error:
java.lang.NullPointerException
at com.infotechsoft.ad_edc.reporting.Report.changeDataSource(Report.java:187)

This is my code in my java class where is failing:

config = new EngineConfig();
config.setEngineHome("C:/birtruntime/birt-runtime-2_6_1/ReportEngine");
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject( IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
engine = factory.createReportEngine(config);
designConfig = new DesignConfig();
IDesignEngineFactory iDesignEngineFactory = (IDesignEngineFactory) Platform.createFactoryObject(
IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY);
iDesignEngineFactory.createDesignEngine(designConfig);

....

ElementFactory elementFactory = null;
ReportDesignHandle reportDesignHandle = null;
reportDesignHandle = (ReportDesignHandle) designRep.getDesignHandle( );
elementFactory = reportDesignHandle.getElementFactory();
Iterator i = reportDesignHandle.getDataSources().iterator(); i.hasNext();) {
reportDesignHandle.getDataSources().dropAndClear((DesignElementHandle) i.next());}

String dataSrcName = "Data Source";
OdaDataSourceHandle dataSourceHandle = elementFactory.newOdaDataSource(dataSrcName, "odaRuntime_Driver");
dataSourceHandle.setProperty("ODM_File", odmFile);

reportDesignHandle.getDataSources().add(dataSourceHandle);

List<OdaDataSetHandle> dataSets;
dataSets = reportDesignHandle.getAllDataSets();
for(OdaDataSetHandle ds : dataSets){
reportDesignHandle.findDataSet(ds.getName()).setDataSource(dataSrcName);}

designRep.setDesignHandle(reportDesignHandle);

This is my build.properties for the designer oda:

bin.includes = plugin.xml,\
META-INF/,\
plugin.properties,\
icons/,\
src/
source.. = src/
output.. = bin/

This is my build.properties for the runtime oda:

bin.includes = plugin.xml,\
META-INF/,\
plugin.properties,\
resources/dataset-adapter-1.0-SNAPSHOT-jar-with-dependencies.jar

I appreciate any help.
Thanks in advanced

Well, now I got to preview the report, but when I try to edit the data set, I get the following error:

org.eclipse.birt.report.designer.core.runtime.GUIException: Caused by org.eclipse.datatools.connectivity.oda.OdaException.
at org.eclipse.birt.report.designer.core.runtime.GUIException.createGUIException(GUIException.java:78)
at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:169)
at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:150)
at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:89)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.addCustomPageODAV3(DataSetEditor.java:226)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.<init>(DataSetEditor.java:177)
at org.eclipse.birt.report.designer.data.ui.dataset.AdvancedDataSetEditor.<init>(AdvancedDataSetEditor.java:23)
at org.eclipse.birt.report.designer.data.ui.actions.EditDataSetAction.doAction(EditDataSetAction.java:99)
at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
at org.eclipse.equinox.launcher.Main.main(Main.java:1383)
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.RuntimeException: Unable to find or create class (odadesigner_driver.impl.CustomDataSetWizardPage).
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.createWizardPage(DataSetWizardBase.java:234)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.createCustomPage(DataSetWizardBase.java:191)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.addCustomPages(DataSetWizardBase.java:147)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.initialize(DataSetWizardBase.java:89)
at org.eclipse.datatools.connectivity.oda.design.internal.designsession.DataSetDesignSessionBase.initWizard(DataSetDesignSessionBase.java:184)
at org.eclipse.datatools.connectivity.oda.design.ui.designsession.DataSetDesignSession.startEditDesign(DataSetDesignSession.java:104)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.addCustomPageODAV3(DataSetEditor.java:216)
... 33 more
Caused by: java.lang.RuntimeException: Unable to find or create class (odadesigner_driver.impl.CustomDataSetWizardPage).
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DesignerUtil.createInstanceWithStringArg(DesignerUtil.java:100)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.createWizardPage(DataSetWizardBase.java:228)
... 39 more
Caused by: java.lang.ClassNotFoundException: odadesigner_driver.impl.CustomDataSetWizardPage
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:506)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:338)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:232)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1197)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DesignerUtil.createInstanceWithStringArg(DesignerUtil.java:85)

Before, it was not finding the Driver class in the oda runtime driver. Now it is not finding CustomDataSetWizardPage in the oda designer driver. This is my modified build.properties

bin.includes = plugin.xml,\
META-INF/,\
plugin.properties,\
icons/,\
src/
jars.compile.order = .
source.. = src/
output.. = bin/

Thanks in advanced

Good news! I got it to work. It was a mistake in the build configuration. However, I am still having problems running the report from my java application. 
Here is the code again: 
 
private static IReportRunnable changeDataSource(IReportRunnable designRep ) throws SemanticException 
{ 
 
ElementFactory elementFactory = null; 
 
ReportDesignHandle reportDesignHandle = null; 
 
reportDesignHandle = (ReportDesignHandle) designRep.getDesignHandle( ); 
elementFactory = reportDesignHandle.getElementFactory(); 
/*Remove all data sources*/ 
for ( Iterator i = reportDesignHandle.getDataSources().iterator(); i.hasNext()) 
{ 
reportDesignHandle.getDataSources().dropAndClear((DesignElementHandle) i.next()); 
} 
 
/*custom oda data source creation & binding */ 
String dataSrcName = "Data Source"; 
OdaDataSourceHandle dataSourceHandle = elementFactory.newOdaDataSource(dataSrcName,"odaruntime_driver"); 
dataSourceHandle.setProperty("ODM_File", odmFile); 
 
reportDesignHandle.getDataSources().add(dataSourceHandle); 
//Change the Data source of the data sets 
List<OdaDataSetHandle> dataSets; 
dataSets = reportDesignHandle.getAllDataSets(); 
for(OdaDataSetHandle ds : dataSets){ 
reportDesignHandle.findDataSet(ds.getName()).setDataSource(dataSrcName); 
} 
 
designRep.setDesignHandle(reportDesignHandle); 
return designRep; 
} 
 
The problem is that dataSourceHandle is null. I can preview the report and create new data sources and data sets. I don't know why I can't open it from my java app. 
Help please. 
Thanks

This is the error that I am getting. Can somebody help me? I have tried many things, but nothing works.

OdaDataSet Data Set:
+ Failed to find out data source of data set "Data Set".
datasource.null.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Failed to find out data source of data set "Data Set".
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1195)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:152)
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:122)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:61)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:178)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at com.infotechsoft.ad_edc.reporting.Report.runReport(Report.java:264)
at com.infotechsoft.ad_edc.reporting.Report.runBirtReport(Report.java:83)
at com.infotechsoft.ad_edc.reporting.Main.main(Main.java:12)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Failed to find out data source of data set "Data Set".
at org.eclipse.birt.report.data.adapter.internal.adapter.DataAdapterUtil.adaptBaseDataSet(DataAdapterUtil.java:77)
at org.eclipse.birt.report.data.adapter.internal.adapter.OdaDataSetAdapter.<init>(OdaDataSetAdapter.java:55)
at org.eclipse.birt.report.data.adapter.impl.ModelAdapter.adaptDataSet(ModelAdapter.java:133)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:297)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:238)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:147)
... 10 more