| newbie failes to create a simple chart... [message #53537] |
Tue, 05 July 2005 11:08  |
Eclipse User |
|
|
|
Hello list,
I'm new to BIRT and try to do the following:
I have data like this:
cat count
------------
1 4
2 2
3 1
The data is from a mysql database, connection works, i can see the data.
Now i try to put these value into a simple bar chart. I put the cat values
on the x-series and the count values on the y-series.
When I click OK, I get an 'Out of memory error'. Started Eclipse with
512MB, nothing changed.
When I click on Preview afterwards, there is diplayed the following:
--------
There are errors on the report page:
Error1:Die Verbindung kann für Treiber
(org.eclipse.birt.report.data.oda.jdbc) nicht geöffnet werden. /* engl:
can't open connection for this driver */
Cannot load JDBC Driver class: [com.mysql.jdbc.Driver].
Cannot load JDBC Driver class: [com.mysql.jdbc.Driver].
Error2:Failed to render Chart
The dataset used by the Chart is invalid
--------
I'm a bit in desperation now, anyone has an idea what I'm doing wrong?
Thanks in advance,
Florian
|
|
|
| Re: newbie failes to create a simple chart... [message #53721 is a reply to message #53537] |
Tue, 05 July 2005 18:16  |
| Eclipse User |
|
|
|
Originally posted by: none.none.com
Hi Florian,
Did you try to bind the same data to a table? Does it work with the sample
database? What version of Eclipse are you using?
It would help if you could look in the error log file of Eclipse and check
what exceptions/errors you see there. The log file is inside the .metadata
folder of your workspace folder, and is called .log.
Thanks,
David
"Florian Schaefer" <fschaefer@ita-logistics.com> wrote in message
news:4cbc7f182d816232853693ccc89b7128$1@www.eclipse.org...
> Hello list,
> I'm new to BIRT and try to do the following:
> I have data like this:
>
> cat count
> ------------
> 1 4
> 2 2
> 3 1
>
> The data is from a mysql database, connection works, i can see the data.
> Now i try to put these value into a simple bar chart. I put the cat values
> on the x-series and the count values on the y-series.
> When I click OK, I get an 'Out of memory error'. Started Eclipse with
> 512MB, nothing changed. When I click on Preview afterwards, there is
> diplayed the following:
>
> --------
> There are errors on the report page:
> Error1:Die Verbindung kann f
|
|
|
| Re: newbie failes to create a simple chart... [message #53832 is a reply to message #53537] |
Tue, 05 July 2005 20:57 |
| Eclipse User |
|
|
|
Originally posted by: Patrick.Lai.broadvision.com
When you said connection worked and you could see the data, did you mean
from BIRT's "Data Explorer"? If you double click your data set and
select "Preview Results", do you see your data?
The error message suggests that you may not have configured JDBC driver
properly, but then you would get error from Data Explorer too.
-- Patrick
Florian Schaefer wrote:
> Hello list,
> I'm new to BIRT and try to do the following:
> I have data like this:
>
> cat count
> ------------
> 1 4
> 2 2
> 3 1
>
> The data is from a mysql database, connection works, i can see the data.
> Now i try to put these value into a simple bar chart. I put the cat
> values on the x-series and the count values on the y-series.
> When I click OK, I get an 'Out of memory error'. Started Eclipse with
> 512MB, nothing changed. When I click on Preview afterwards, there is
> diplayed the following:
>
> --------
> There are errors on the report page:
> Error1:Die Verbindung kann für Treiber
> (org.eclipse.birt.report.data.oda.jdbc) nicht geöffnet werden. /* engl:
> can't open connection for this driver */
> Cannot load JDBC Driver class: [com.mysql.jdbc.Driver]. Cannot load JDBC
> Driver class: [com.mysql.jdbc.Driver]. Error2:Failed to render Chart
> The dataset used by the Chart is invalid
> --------
>
> I'm a bit in desperation now, anyone has an idea what I'm doing wrong?
>
> Thanks in advance,
> Florian
>
>
>
|
|
|
|
|
| Re: newbie failes to create a simple chart... [message #54196 is a reply to message #54116] |
Wed, 06 July 2005 04:24 |
| Eclipse User |
|
|
|
Originally posted by: none.none.com
Florian,
This sql jdbc driver needs to be also inside the viewer plugin, or it won't
find it for previewing. Check
http://www.eclipse.org/birt/index.php?page=deploy/viewer-dep loy.html#jump_4
You need to copy your driver to
org.eclipse.birt.report.viewer/birt/WEB-INF/plugins/org.ecli pse.birt.report.data.oda.jdbc/drivers
Thanks,
David
"Florian Schaefer" <fschaefer@ita-logistics.com> wrote in message
news:f34ed393a6ed2f3b601cc0af6faa7cee$1@www.eclipse.org...
> first of all, thanks for replying...
>
> Patrick,
> yes, I can see the data in the Data Explorer. When I define the datasource
> I can test the connection successfully.
> Connection is like this:
> Driverclass: com.mysql.jdbc.Driver (v3.1)
> database url: jdbc:mysql://localhost/databasename
> username: ...
> pw: ...
>
> The mysql-connector-java-3.1.8-bin.jar exists in
> $ECLIPSE_HOME\plugins\org.eclipse.birt.report.data.oda.jdbc_ 1.0.0\drivers
>
> ___________________
>
> David,
> no, I can't bind the data to a table, same error. Tutorial with the
> sampledatabase works fine.
>
> There is the following in the logfile:
>
> org.eclipse.birt.data.engine.core.DataException: Die Verbindung kann f
|
|
|
|
Powered by
FUDForum. Page generated in 0.03649 seconds
Home