Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » javabridge with BIRT 3.7.0
javabridge with BIRT 3.7.0 [message #727208] Tue, 20 September 2011 15:52 Go to next message
Tobbi Filteau is currently offline Tobbi Filteau
Messages: 10
Registered: September 2011
Junior Member
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 16:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 12:53 Go to previous messageGo to next message
Tobbi Filteau is currently offline Tobbi Filteau
Messages: 10
Registered: September 2011
Junior Member
Thanks a lot, it works Smile
Re: javabridge with BIRT 3.7.0 [message #763059 is a reply to message #739411] Fri, 09 December 2011 04:27 Go to previous messageGo to next message
karvesh ghunsam is currently offline karvesh ghunsam
Messages: 95
Registered: July 2011
Member
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 14:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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] Sat, 10 December 2011 03:13 Go to previous messageGo to next message
karvesh ghunsam is currently offline karvesh ghunsam
Messages: 95
Registered: July 2011
Member
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 #764652 is a reply to message #763585] Mon, 12 December 2011 15:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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] Tue, 13 December 2011 03:40 Go to previous messageGo to next message
karvesh ghunsam is currently offline karvesh ghunsam
Messages: 95
Registered: July 2011
Member
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 10:15 Go to previous messageGo to next message
karvesh ghunsam is currently offline karvesh ghunsam
Messages: 95
Registered: July 2011
Member
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 15:26 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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] Fri, 16 December 2011 03:00 Go to previous messageGo to next message
karvesh ghunsam is currently offline karvesh ghunsam
Messages: 95
Registered: July 2011
Member
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 16:05 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Sat Sep 20 06:06:58 GMT 2014

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

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