3:24 p.m.
Tihomir Surdilovic [http://community.jboss.org/people/tsurdilovic] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639724#639724
--------------------------------------------------------------
With 3.7 there is nothing you need outiside of copying jars of ReportEngine/lib to your
classpath (web-inf/lib). What you are running into most likely is that you are still using
the 1.3 report-server code which is not compatible with Birt 3.7. We are fixing this now
as part of the jbpm-installer AS7 upgrade. Will update here when its changed in (remind me
too if you don't hear anything in the next couple of days).
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639724#639724]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
3:59 p.m.
Anand Awasthi [http://community.jboss.org/people/anand.awasthi] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639729#639729
--------------------------------------------------------------
thanks,
that makes sense as jbpm console 5.1 is using report-core-1.3 but then what version of
birt runtime is compatible with 1.3, I initially tried using birt 2.6.2 and that was
giving me broblem such as below:
[11/23/11 15:17:31:901 EST] 00000012 SystemErr R Exception in thread
"BirtService-Init" java.lang.NoSuchMethodError:
org/eclipse/birt/report/engine/api/EngineConfig.getLogRollingSize()I
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.eclipse.birt.report.engine.api.impl.ReportEngine.intializeLogger(ReportEngine.java:217)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.eclipse.birt.report.engine.api.impl.ReportEngine.<init>(ReportEngine.java:133)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.eclipse.birt.report.engine.api.impl.ReportEngineFactory$1.run(ReportEngineFactory.java:18)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.eclipse.birt.report.engine.api.impl.ReportEngineFactory$1.run(ReportEngineFactory.java:1)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
java.security.AccessController.doPrivileged(AccessController.java:202)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.eclipse.birt.report.engine.api.impl.ReportEngineFactory.createReportEngine(ReportEngineFactory.java:14)
[11/23/11 15:17:31:902 EST] 00000012 SystemErr R at
org.jboss.bpm.report.BirtEngineFactory.newInstance(BirtEngineFactory.java:48)
[11/23/11 15:17:31:903 EST] 00000012 SystemErr R at
org.jboss.bpm.report.BirtService.create(BirtService.java:80)
[11/23/11 15:17:31:903 EST] 00000012 SystemErr R at
org.jboss.bpm.report.BirtService$2.run(BirtService.java:213)
[11/23/11 15:17:31:903 EST] 00000012 SystemErr R at
java.lang.Thread.run(Thread.java:736)
so I upgraded to 3.7.1 , above problem went away but then i started seeing the current
jdbc related issues.
does it mean that there is no version of birt that we can currently plugin with jbpm
console 5.1 ?
thanks
Anand
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639729#639729]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4:12 p.m.
Tihomir Surdilovic [http://community.jboss.org/people/tsurdilovic] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639731#639731
--------------------------------------------------------------
You cannot use 2.6 either because report-server (1.3.0) used to put in it's own Birt
client jars. As far as what version to use, look at the jBPM 5.1 installer build.xml..that
will tell you. ( https://github.com/droolsjbpm/jbpm/blob/master/jbpm-installer/build.xml
https://github.com/droolsjbpm/jbpm/blob/master/jbpm-installer/build.xml -
<property name="birt.download.url"
value="http://www.eclipse.org/downloads/download.php?file=/birt/down...
(http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/...
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639731#639731]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4:16 p.m.
Tihomir Surdilovic [http://community.jboss.org/people/tsurdilovic] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639732#639732
--------------------------------------------------------------
In jBPM 5.2 the installer will default to AS7 with Birt 3.7.0.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639732#639732]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
2:10 p.m.
Anand Awasthi [http://community.jboss.org/people/anand.awasthi] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639906#639906
--------------------------------------------------------------
Ok, So I downloaded 2.3.2.2 runtime and deployed the report engine in
-Dorg.jbpm.report.engine.dir=D:\birt-runtime-2_3_2 (set this via JVM settings in Websphere
7 admin console).
I have copied the db2jcc.jar in
D:\birt-runtime-2_3_2\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212\drivers
but i am still getting "can not load Report Query".
Now I have seen that as part of jbpm 5.1 installer, Report Engine needs to be installed in
${jboss.server.data.dir}/birt.
How about location for Websphere 7 ? Since I am installing Reprot Engine in
D:\birt-runtime-2_3_2 (which is out side of Webpshere Location) that could be causing this
issue of not being able to load the Report queries ?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639906#639906]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
2:40 p.m.
Tihomir Surdilovic [http://community.jboss.org/people/tsurdilovic] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639911#639911
--------------------------------------------------------------
The report server 1.3.0 code looks at a property variable called
"org.jbpm.report.engine.dir" .. you should set it w/
-Dorg.jbpm.report.engine.dir=XYZ where XYZ is the location of where you install the Birt
runtime.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639911#639911]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
3:13 p.m.
Anand Awasthi [http://community.jboss.org/people/anand.awasthi] created the discussion
"Re: birt report data not showing up in jbpm console - can't load jdbc jar
?"
To view the discussion, visit: http://community.jboss.org/message/639914#639914
--------------------------------------------------------------
Ok..finally some good news...
Got it working with 2.3.2.... Thanks a bunch Tihomir.
Yep, the location of report run time does not matter,,it can be set to where one wants as
long as server can find it...
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/639914#639914]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4771
days inactive
4772
days old
6 comments
2 participants
participants (2)
-
Anand Awasthi -
Tihomir Surdilovic