Eclipse Community Forums: BIRT » javabridge with BIRT 3.7.0

Home » Archived » BIRT » javabridge with BIRT 3.7.0

javabridge with BIRT 3.7.0 [message #727208]

Tue, 20 September 2011 11:52

Eclipse User

Hi there,

A while back, I wrote about my difficulties configuring Javabridge to make it work with the latest runtime of Eclipse BIRT. Thanks to Jason Weathersby, I was able to fix this problem... but now it's back with the latest download of the runtime library (namely 3.7.0).

To make a long story short, you essentially need to replace two folders in the JavaBridge folder, namely the "lib" and the "plugins" folder... but BIRT runtime 3.7.0 doesn't HAVE a plugins folder.

So the question is: What should I replace the "plugins" directory with? Should I try copying the one in the Eclipse installation folder?

Thanks in advance

Osuwariboy

Re: javabridge with BIRT 3.7.0 [message #727214 is a reply to message #727208]

Tue, 20 September 2011 12:00

Eclipse User

I updated this entry:
http://www.birt-exchange.org/org/devshare/deploying-birt-reports/743-calling-birt-from-php/

With directions for 3.7.

Jason

On 9/20/2011 11:52 AM, tob_filt wrote:
> Hi there,
>
> A while back, I wrote about my difficulties configuring Javabridge to
> make it work with the latest runtime of Eclipse BIRT. Thanks to Jason
> Weathersby, I was able to fix this problem... but now it's back with the
> latest download of the runtime library (namely 3.7.0).
>
> To make a long story short, you essentially need to replace two folders
> in the JavaBridge folder, namely the "lib" and the "plugins" folder...
> but BIRT runtime 3.7.0 doesn't HAVE a plugins folder.
>
> So the question is: What should I replace the "plugins" directory with?
> Should I try copying the one in the Eclipse installation folder?
>
> Thanks in advance
>
> Osuwariboy

Re: javabridge with BIRT 3.7.0 [message #739411 is a reply to message #727214]

Mon, 17 October 2011 08:53

Eclipse User

Thanks a lot, it works Smile

Re: javabridge with BIRT 3.7.0 [message #763059 is a reply to message #739411]

Thu, 08 December 2011 23:27

Eclipse User

Hello Osuwariboy

Did you get it to work with BIRT 3.7?

I followed the steps from

http://www.birt-exchange.org/org/devshare/deploying-birt-reports/743-calling-birt-from-php/

I can see the report but i am having some problem with the data connection.

I get the following error:

The following items have errors:

Data (id = 1524):
+ Can not load the report query: 1524. Errors occurred when generating the report document for the report element with ID 1,524. (Element ID:1524)

apparently the data connection is not being done. I am using mysql 5, so my connector file is currently: mysql-connector-java-5.1.17-bin.jar

I simply placed it in the WEB-INF/lib folder but it does not seem to work?

Please let me know how did you do it?

Thanks a lot..

Karvesh

Re: javabridge with BIRT 3.7.0 [message #763314 is a reply to message #763059]

Fri, 09 December 2011 09:52

Eclipse User

Putting it in the WEB-INF/lib should work. Is this a normal jdbc
connection or are you using connection profiles?

Jason

On 12/8/2011 11:27 PM, karvesh wrote:
> Hello Osuwariboy
>
> Did you get it to work with BIRT 3.7?
>
> I followed the steps from
> http://www.birt-exchange.org/org/devshare/deploying-birt-reports/743-calling-birt-from-php/
>
> I can see the report but i am having some problem with the data connection.
> I get the following error:
>
>
> The following items have errors:
>
> Data (id = 1524):
> + Can not load the report query: 1524. Errors occurred when generating
> the report document for the report element with ID 1,524. (Element ID:1524)
>
> apparently the data connection is not being done. I am using mysql 5, so
> my connector file is currently: mysql-connector-java-5.1.17-bin.jar
>
> I simply placed it in the WEB-INF/lib folder but it does not seem to work?
>
> Please let me know how did you do it?
>
> Thanks a lot..
>
> Karvesh
>

Re: javabridge with BIRT 3.7.0 [message #763585 is a reply to message #763314]

Fri, 09 December 2011 22:13

Eclipse User

Dear Jason

I am using a simple JDBC Driver Connections with the details:

MySQL JDBC Driver and path of driver set to:

C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\JavaBridge\WEB-INF\mysql-connector-java-5.1.17-bin.jar

When i preview it in eclipse, the report works fine.

However, when i use it with the javabridge, it still gets the problem to connect with the database.

I noted one thing when doing the integration with 3.7: there was no jaxrpc.jar file in the javabridge folder when it has been exploded.. It might be some problem?

In fact, i am trying to get the 3.7 working hopefully so that the out of memory errors do not happen. I realised that i was using the 2.6 version live..

Please find enclosed the report design i am using.. I hope it may help.

Thanks in advance Jason

Karvesh

Attachment: StockItems.rptdesign
(Size: 46.69KB, Downloaded 291 times)

Re: javabridge with BIRT 3.7.0 [message #764652 is a reply to message #763585]

Mon, 12 December 2011 10:35

Eclipse User

Karvesh,

Are you using the 3.7 runtime? I noticed in your report you are using a
connection profile and not the direct connection. This should work in
3.7 as long as you set the datatools workspacepath environment variable
in the tomcat startup:
http://wiki.eclipse.org/Birt_3.7_Migration_Guide#Connection_Profiles

The quickest way to verify that the connection works is to use the
direct connection without the connection profile first.

Jason

On 12/9/2011 10:13 PM, karvesh wrote:
> Dear Jason
>
> I am using a simple JDBC Driver Connections with the details:
>
> MySQL JDBC Driver and path of driver set to:
>
> C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\JavaBridge\WEB-INF\mysql-connector-java-5.1.17-bin.jar
>
> When i preview it in eclipse, the report works fine.
>
> However, when i use it with the javabridge, it still gets the problem to connect with the database.
>
> I noted one thing when doing the integration with 3.7: there was no jaxrpc.jar file in the javabridge folder when it has been exploded.. It might be some problem?
>
> In fact, i am trying to get the 3.7 working hopefully so that the out of memory errors do not happen. I realised that i was using the 2.6 version live..
>
> Please find enclosed the report design i am using.. I hope it may help.
>
> Thanks in advance Jason
>
> Karvesh
>

Re: javabridge with BIRT 3.7.0 [message #764896 is a reply to message #764652]

Mon, 12 December 2011 22:40

Eclipse User

Dear Jason

It works fine finally! It was indeed the connection profile issue. I use direct connection now. thanks a lot Smile

Re: javabridge with BIRT 3.7.0 [message #766173 is a reply to message #764652]

Thu, 15 December 2011 05:15

Eclipse User

Dear Jason,

I have quite a lot of reports with the connection profile property..
I was thinking about adding the profile settings to catalina bat..

I saw that i need to add the lines:

SET java.io.tmpdir=C:\apps\apache-tomcat-5.5.20\tmpdir
SET org.eclipse.datatools_workspacepath=%java.io.tmpdir%\workspace_dtp
mkdir %java.io.tmpdir%
mkdir %org.eclipse.datatools_workspacepath%

In my case, i am using tomcat 7, so the path will be
C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp

My question here is how do i add it? I set in in tomcat java configuration just below:
-XX:MaxPermSize=256M?

I am a bit confused here..

Could you please hint me here?

Thanks in advance
Karvesh

Re: javabridge with BIRT 3.7.0 [message #766345 is a reply to message #766173]

Thu, 15 December 2011 10:26

Eclipse User

You should be able to add those lines to the top of the catalina.bat file.

Jason

On 12/15/2011 5:15 AM, karvesh wrote:
> Dear Jason,
>
> I have quite a lot of reports with the connection profile property..
> I was thinking about adding the profile settings to catalina bat..
>
> I saw that i need to add the lines:
>
>
> SET java.io.tmpdir=C:\apps\apache-tomcat-5.5.20\tmpdir
> SET org.eclipse.datatools_workspacepath=%java.io.tmpdir%\workspace_dtp
> mkdir %java.io.tmpdir%
> mkdir %org.eclipse.datatools_workspacepath%
>
> In my case, i am using tomcat 7, so the path will be C:\Program
> Files\Apache Software Foundation\Tomcat 7.0\temp
>
> My question here is how do i add it? I set in in tomcat java
> configuration just below:
> -XX:MaxPermSize=256M?
>
> I am a bit confused here..
>
> Could you please hint me here?
>
> Thanks in advance Karvesh
>

Re: javabridge with BIRT 3.7.0 [message #766582 is a reply to message #766345]

Thu, 15 December 2011 22:00

Eclipse User

Dear Jason

sorry if my question may sound naive.. its just that i am running tomcat 7 on windows and i dont seem to have the catalina.bat file.
Instead i am trying to add the lines via the monitor tomcat > configure > java tab > Java options.
I already have these options in the textarea:

-Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
-Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
-Djava.endorsed.dirs=C:\Program Files\Apache Software Foundation\Tomcat 7.0\endorsed
-Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\logging.properties
-XX:MaxPermSize=256M

I am wondering is it here that I add the other ones:

SET java.io.tmpdir=C:\apps\apache-tomcat-5.5.20\tmpdir
SET org.eclipse.datatools_workspacepath=%java.io.tmpdir%\workspace_dtp
mkdir %java.io.tmpdir%
mkdir %org.eclipse.datatools_workspacepath%

If yes, i just add -Dcatalina in front instead of SET? and how about the mkdir?

Sorry about the hassle Jason Sad

Karvesh

Re: javabridge with BIRT 3.7.0 [message #766898 is a reply to message #766582]

Fri, 16 December 2011 11:05

Eclipse User

Understood, so you are running tomcat as a service. Can you set the
java.io.tmpdir and org.eclipse.datatools_workspacepath as environment
variables use control panel->system->Advanced system
settings->Environment Variables? Just make sure the directories already
exist.

Jason

On 12/15/2011 10:00 PM, karvesh wrote:
> Dear Jason
>
> sorry if my question may sound naive.. its just that i am running tomcat
> 7 on windows and i dont seem to have the catalina.bat file. Instead i am
> trying to add the lines via the monitor tomcat > configure > java tab >
> Java options.
> I already have these options in the textarea:
>
> -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
> -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
> -Djava.endorsed.dirs=C:\Program Files\Apache Software Foundation\Tomcat
> 7.0\endorsed
> -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat
> 7.0\temp
> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
> -Djava.util.logging.config.file=C:\Program Files\Apache Software
> Foundation\Tomcat 7.0\conf\logging.properties
> -XX:MaxPermSize=256M
>
> I am wondering is it here that I add the other ones:
>
> SET java.io.tmpdir=C:\apps\apache-tomcat-5.5.20\tmpdir
> SET org.eclipse.datatools_workspacepath=%java.io.tmpdir%\workspace_dtp
> mkdir %java.io.tmpdir%
> mkdir %org.eclipse.datatools_workspacepath%
>
> If yes, i just add -Dcatalina in front instead of SET? and how about the
> mkdir?
>
> Sorry about the hassle Jason :(
> Karvesh

Previous Topic:	BIRT Books
Next Topic:	Programatically setting a value in crosstab cell

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 22:30:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter