Change BIRT - Build Dynamic Table (DEAPI)'s datasource to Informix dataBase

Eric Wong · 2011-01-06T02:24:43+00:00

Dear friends, how should I do to change dataSource to Informix dataBase? that example under that link: Java - Build Dynamic Table (BIRT) - Eclipsepedia works perfectly. I want to use Informix…

Eric Wong

Dear friends, 
how should I do to change dataSource to Informix dataBase? 
 
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. 
 
I want to use Informix dataBase as dataSource, so I modified the code like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>void buildDataSource() throws SemanticException
{
OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource(
"Data Source", "org.eclipse.birt.report.data.oda.jdbc" );
dsHandle.setProperty("odaDriverClass", "com.informix.jdbc.IfxDriver");
dsHandle.setProperty(
"odaURL","myDBURL");
dsHandle.setProperty("odaUser", "myDBUser");
dsHandle.setProperty("odaPassword", "myDBPassword");

designHandle.getDataSources().add(dsHandle);
}</pre>
 
I have copied ifxjdbc.jar to \birt-runtime-2_3_2\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.v20090331-1440\drivers 
 
Now, when I run the program, I get a java.lang.NullPointerException: 
<pre class='_prettyXprint _lang-auto _linenums:0'>Exception in thread "main" java.lang.NullPointerException
at hob.integration.CreatDynamicTable.buildDataSource(CreatDynamicTable.java:37)
at hob.integration.CreatDynamicTable.buildReport(CreatDynamicTable.java:89)
at hob.integration.CreatDynamicTable.main(CreatDynamicTable.java:153)</pre>
 
I would be pleased to get help. 
 
Thank you. 
 
Best regards 
Burke

Find more posts tagged with

Comments

averma

Hi Burke, 
Please check your odaURL, here is a sample format: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
jdbc:informix-sqli://{<ip-address>|<host-name>}:<port-number>[/<dbname>]: INFORMIXSERVER=<server-name>
</pre>
 
Ashwini

Eric Wong

hi Ashwini, 
In my previous example, I hid my odaURL, odaUser, odaPassword. 
my source code property as follow: 
<pre class='_prettyXprint _lang-auto _linenums:0'>OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource(
"Data Source", "org.eclipse.birt.report.data.oda.jdbc" );
dsHandle.setProperty("odaDriverClass", "com.informix.jdbc.IfxDriver");
dsHandle.setProperty(
"odaURL","jdbc:informix-sqli://10.1.3.118:8002/tnmsdb2_ln:informixserver=tnms118;newcodeset=GBK,8859-1,819;CLIENT_LOCALE=en_US.819;DB_LOCALE=en_US.819;SERVER_LOCALE=en_US.819;IFX_LOCK_MODE_WAIT=10");
dsHandle.setProperty("odaUser", "myUserName");
dsHandle.setProperty("odaPassword", "myPassword");</pre>
I am sure the odaURL, odaUser and odaPassword are correct. 
 
when I run the program, I get a java.lang.NullPointerException. 
 
And what anything else I have to change? 
 
thx+best wishes 
Burke

averma

Hi Burke,
What code is on line 37?
Can you also try to create a report using this db in the report designer look at its xml and verify the settings against what you have in the code.

Ashwini

Eric Wong

Hi Ashwini, 
the code on 37 is: 
<pre class='_prettyXprint _lang-auto _linenums:0'>OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource(
"Data Source", "org.eclipse.birt.report.data.oda.jdbc" );</pre>
 
The report using this db in report designer works fine. 
 
Could you give me an example to change dataSource to special dataBase. 
Change base on <a class='bbc_url' href='http://wiki.eclipse.org/Java_-_Build_Dynamic_Table_(BIRT)'>Java - Build Dynamic Table (BIRT)</a> could be better. 
 
Looking forward to receiving your reply ASAP. 
 
thx+best wishes 
Burke

averma

Can you check if you designFactory is null before line 37?

Ashwini

Eric Wong

Hi Ashwini, 
 
Thank you very much for your great help. 
 
Now it works, my mistake was that my designFactory hasn't been initialized. the code line:<pre class='_prettyXprint _lang-auto _linenums:0'>designFactory = designHandle.getElementFactory();</pre> was missing. 
 
Have a nice day. 
 
Bye 
Burke