Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Can't Get CSV ODA Plugin to Work
Can't Get CSV ODA Plugin to Work [message #772335] Thu, 29 December 2011 14:38 Go to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Good afternoon,

as described in the book 'Integrating and Extending BIRT' I tried to get the CSV ODA plugin to work. I have downloaded the two zip archives from http://www.actuate.com/products/resources/?articleid=22889 and proceeded as described in the book's chapter 20, section 'Testing the CSV ODA UI Plugin'.
My Eclipse version is Helios and the BIRT included therein is 2.6.2, allthough when looking at all bits there are occasional glimpses of 2.6.1. My book's version is 'Second Edition' so it did not exactly match the more recent circumstances but I managed somehow accordingly.

The two plugins could be imported and the described run-time configuration could be started. I created a reporting project, a report and a DataSource. Test configuration said 'PING succeeded' (upon csvTestODA.csv taken from Test-CSVODA.zip downloaded form the same location as the plugins). When trying to create a DataSet, I came to the pop-up where the columns were to be selected:

29.12.2011 15:28:02 org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil toResultSetColumnsDesign( IResultSetMetaData )
INFO: Some optional metadata of column 1 are not available.
java.lang.UnsupportedOperationException
at org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
at ...

This is true, the method getColumnDisplayLength in org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData only throws an UnsupportedOperationException when called.

Also I failed in previewing the report new_report_1.rptdesign which I also took from Test-CSVODA.zip:

2011-12-29 15:34:00.502:WARN::ERROR: Error for /viewer/run
java.lang.OutOfMemoryError: PermGen space
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
at ...

I may have done something wrong in the setup, there might be something rotten with my Eclipse installation, can somebody give me a hint?

Thanks & regards,
Juliane.

Re: Can't Get CSV ODA Plugin to Work [message #774309 is a reply to message #772335] Tue, 03 January 2012 17:08 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

There may be a bug in the code. Can you try these plugins?
BTW did you load up the source and then export the plugins? The
attached ones are in exported format and can just be added to the designer.


Jason

On 12/29/2011 9:38 AM, Juliane Harbarth wrote:
>
> Good afternoon,
>
> as described in the book 'Integrating and Extending BIRT' I tried to get
> the CSV ODA plugin to work. I have downloaded the two zip archives from
> http://www.actuate.com/products/resources/?articleid=22889 and proceeded
> as described in the book's chapter 20, section 'Testing the CSV ODA UI
> Plugin'. My Eclipse version is Helios and the BIRT included therein is
> 2.6.2, allthough when looking at all bits there are occasional glimpses
> of 2.6.1. My book's version is 'Second Edition' so it did not exactly
> match the more recent circumstances but I managed somehow accordingly.
>
> The two plugins could be imported and the described run-time
> configuration could be started. I created a reporting project, a report
> and a DataSource. Test configuration said 'PING succeeded' (upon
> csvTestODA.csv taken from Test-CSVODA.zip downloaded form the same
> location as the plugins). When trying to create a DataSet, I came to the
> pop-up where the columns were to be selected:
> 29.12.2011 15:28:02
> org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil
> toResultSetColumnsDesign( IResultSetMetaData )
> INFO: Some optional metadata of column 1 are not available.
> java.lang.UnsupportedOperationException
> at
> org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
>
> at ...
>
> This is true, the method getColumnDisplayLength in
> org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData only throws
> an UnsupportedOperationException when called.
> Also I failed in previewing the report new_report_1.rptdesign which I
> also took from Test-CSVODA.zip:
>
> 2011-12-29 15:34:00.502:WARN::ERROR: Error for /viewer/run
> java.lang.OutOfMemoryError: PermGen space
> at java.lang.ClassLoader.defineClass1(Native Method)
> at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
> at ...
>
> I may have done something wrong in the setup, there might be something
> rotten with my Eclipse installation, can somebody give me a hint?
>
> Thanks & regards,
> Juliane.
>
>
  • Attachment: plugins.zip
    (Size: 43.43KB, Downloaded 226 times)
Re: Can't Get CSV ODA Plugin to Work [message #778366 is a reply to message #774309] Thu, 12 January 2012 15:54 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Hi Jason,

thanks for your reply. What I obtained from the mentioned site were zips containing both java and class files. I selected 'Import' / 'Existing Projects into Workspace'. Since this brought me at least to seing the CSF DataSource in my BIRT Perspective I this was not too bad.

What you sent me are jars and they do contain only class files. Allthough I am basically interested in the javas since I want to play around with them, I can of course test the jars you send me, but I did not manage. How to handle the exported format? Can you please explain.

Juliane.
Re: Can't Get CSV ODA Plugin to Work [message #778413 is a reply to message #778366] Thu, 12 January 2012 16:18 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

To export the plugin correctly, open the source and open the plugin.xml.
This will launch the manifest editor. On the first tab there is an
export link in the bottom right hand corner. This will export the
plugin properly.

Jason

On 1/12/2012 10:54 AM, Juliane Harbarth wrote:
>
> Hi Jason,
>
> thanks for your reply. What I obtained from the mentioned site were zips
> containing both java and class files. I selected 'Import' / 'Existing
> Projects into Workspace'. Since this brought me at least to seing the
> CSF DataSource in my BIRT Perspective I this was not too bad.
>
> What you sent me are jars and they do contain only class files.
> Allthough I am basically interested in the javas since I want to play
> around with them, I can of course test the jars you send me, but I did
> not manage. How to handle the exported format? Can you please explain.
> Juliane.
>
Re: Can't Get CSV ODA Plugin to Work [message #778549 is a reply to message #778413] Fri, 13 January 2012 08:29 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Hi Jason,

I managed to import the jars you sent me and the result is the same as with the previous ones, i.e.:

INFO: Some optional metadata of column 1 are not available.
java.lang.UnsupportedOperationException
at org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
at org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil.toResultSetColumnsDesign(DesignSessionUtil.java:538)
...

I get this for every one of the three existing columns. So I guess there is something wrong with my environment or the way I am using it?

Regards,
Juliane.

Re: Can't Get CSV ODA Plugin to Work [message #778681 is a reply to message #778549] Fri, 13 January 2012 16:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Juliane,

The jars I sent you were already exported. You should just be adding
these to your BIRT install.

Jason

On 1/13/2012 3:29 AM, Juliane Harbarth wrote:
>
> Hi Jason,
>
> I managed to import the jars you sent me and the result is the same as
> with the previous ones, i.e.:
>
> INFO: Some optional metadata of column 1 are not available.
> java.lang.UnsupportedOperationException
> at
> org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
>
> at
> org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil.toResultSetColumnsDesign(DesignSessionUtil.java:538)
>
> ...
>
> I get this for every one of the three existing columns. So I guess there
> is something wrong with my environment or the way I am using it?
>
> Regards,
> Juliane.
>
>
Re: Can't Get CSV ODA Plugin to Work [message #780174 is a reply to message #778681] Tue, 17 January 2012 09:57 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Hi Jason,

got it. After moving the jars into my Eclipse's plugins folder, I could create and preview a report using the CSV DataSource and after moving the jars into my Tomcat's webapps\birt\WEB-INF\platform\plugins folder, my BIRT run-time could execute the report, too.
Since this version of the plugin seems to work well with my environment, can I have the sources for further experiments, please?

Thanks & regards,
Juliane.
Re: Can't Get CSV ODA Plugin to Work [message #780395 is a reply to message #780174] Tue, 17 January 2012 18:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Here they are.

Jason

On 1/17/2012 4:57 AM, Juliane Harbarth wrote:
>
> Hi Jason,
>
> got it. After moving the jars into my Eclipse's plugins folder, I could
> create and preview a report using the CSV DataSource and after moving
> the jars into my Tomcat's webapps\birt\WEB-INF\platform\plugins folder,
> my BIRT run-time could execute the report, too.
> Since this version of the plugin seems to work well with my environment,
> can I have the sources for further experiments, please?
>
> Thanks & regards,
> Juliane.
>
Re: Can't Get CSV ODA Plugin to Work [message #780850 is a reply to message #780395] Thu, 19 January 2012 16:04 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Hi Jason,

your binaries worked for me when I put them into my Eclipse plugins folder, but when I imported the two projects and launched an inner Eclipse from the editor of plugin.xml of the csv.ui, I ran into the same problems I had with my previous plugin projects, namely

...
INFO: Some optional metadata of column 1 are not available.
java.lang.UnsupportedOperationException
at org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
at org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil.toResultSetColumnsDesign(DesignSessionUtil.java:538)
...

what have I done to my environment to make your binaries work well, but your sources not?

Regards,
Juliane.
Re: Can't Get CSV ODA Plugin to Work [message #780883 is a reply to message #780850] Thu, 19 January 2012 19:20 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Are you using a debug configuration to launch an inner eclipse? If you
start a new workspace, import the two projects and then launch a debug
configuration use Run a product with it set to org.eclipse.platform.ide.
I also set -XX:MaxPermSize=256M in the arguments tab under VM
Arguments. I then create a new birt project and new birt report from
within the inner Eclipse instance. BTW I am using the BIRT allinone
download.

Jason

On 1/19/2012 11:04 AM, Juliane Harbarth wrote:
>
> Hi Jason,
>
> your binaries worked for me when I put them into my Eclipse plugins
> folder, but when I imported the two projects and launched an inner
> Eclipse from the editor of plugin.xml of the csv.ui, I ran into the same
> problems I had with my previous plugin projects, namely
> ...
> INFO: Some optional metadata of column 1 are not available.
> java.lang.UnsupportedOperationException
> at
> org.eclipse.birt.report.data.oda.csv.impl.ResultSetMetaData.getColumnDisplayLength(ResultSetMetaData.java:97)
>
> at
> org.eclipse.datatools.connectivity.oda.design.ui.designsession.DesignSessionUtil.toResultSetColumnsDesign(DesignSessionUtil.java:538)
>
> ...
>
> what have I done to my environment to make your binaries work well, but
> your sources not?
>
> Regards,
> Juliane.
Re: Can't Get CSV ODA Plugin to Work [message #782784 is a reply to message #780883] Tue, 24 January 2012 12:54 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member


Hi Jason,

have tried launching in debug mode (used non-debug previously) but it has the same error. Since what I am getting is a real programming error (it tries to call a method that doesn't exist) that's what I expected. Your sourcecode works for you so I best try the very same Eclipse that you use. Currently I am using a so-called 'Designer' which is some proprietaryly brushed-up Eclipse. Can you tell me your exact version please (a link would be perfect) so I can give it a try in an environment like your's.

Thanks & regards,
Juliane.
Re: Can't Get CSV ODA Plugin to Work [message #782838 is a reply to message #782784] Tue, 24 January 2012 14:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Juliane,

I use the allinone package. I did that in BIRT 2.6.1 but 2.6.2 and
later should work. Here is 2.6.2 allione

http://www.eclipse.org/downloads/packages/eclipse-ide-java-and-report-developers/heliossr2

3.7.1 allinone is:
http://www.eclipse.org/downloads/packages/eclipse-ide-java-and-report-developers/indigosr1

What version are you using?

Jason


On 1/24/2012 7:54 AM, Juliane Harbarth wrote:
>
>
> Hi Jason,
>
> have tried launching in debug mode (used non-debug previously) but it
> has the same error. Since what I am getting is a real programming error
> (it tries to call a method that doesn't exist) that's what I expected.
> Your sourcecode works for you so I best try the very same Eclipse that
> you use. Currently I am using a so-called 'Designer' which is some
> proprietaryly brushed-up Eclipse. Can you tell me your exact version
> please (a link would be perfect) so I can give it a try in an
> environment like your's.
>
> Thanks & regards,
> Juliane.
>
Re: Can't Get CSV ODA Plugin to Work [message #784445 is a reply to message #782838] Fri, 27 January 2012 14:37 Go to previous messageGo to next message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member

Hi Jason,

I installed the 64-bit version of the 3.7.1 allinone and imported your two projects and launched a debug configuration. Everything went fine, but when creating a DataSource in the inner Eclipse's BIRT perspective, the CSV-option is not offered.

My inner Eclipse's 'Eclipse Platform Installation Details' tell me
*** Plug-in Registry:
org.eclipse.birt.report.data.oda.csv (1.0.0) "CSV ODA Runtime Driver" [Installed]
org.eclipse.birt.report.data.oda.csv.ui (1.0.0) "CSV File ODA Data Source ODA Designer" [Installed]
which is no good, it should be [Starting] instead of [Installed], I assume.

I did set -XX:MaxPermSize=256M in the arguments tab under VM Arguments. But you gave another advise, namely 'use Run a product with it set to org.eclipse.platform.ide.' which I did not do, may be this is the isseu here.

Thanks & regards,
Juliane.


Re: Can't Get CSV ODA Plugin to Work [message #784463 is a reply to message #784445] Fri, 27 January 2012 15:12 Go to previous message
Juliane Harbarth is currently offline Juliane HarbarthFriend
Messages: 21
Registered: July 2009
Junior Member


Aahhh, never mind, it works for me now!!!!!!!

The last issue was something with the JVM: 1.5 vs. 1.6 / 32bit vers 64bit, don't exactly understood that last bit, but isn't that wonderful!

Can't promise I won't be back with more questions, but for the moment, thank you very much for your help and your patience.

Have a nice weekend,
Juliane.

Previous Topic:Reference Images on File System
Next Topic:Schedular??
Goto Forum:
  


Current Time: Sat Apr 20 02:54:20 GMT 2024

Powered by FUDForum. Page generated in 0.18294 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top