Eclipse Community Forums: BIRT » newbie failes to create a simple chart...

Help

Home

Home » Archived » BIRT » newbie failes to create a simple chart...

Show: Today's Messages :: Show Polls :: Message Navigator

newbie failes to create a simple chart... [message #53537]

Tue, 05 July 2005 15:08

Florian Schaefer

Messages: 14
Registered: July 2009

Junior Member

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

Report message to a moderator

Re: newbie failes to create a simple chart... [message #53721 is a reply to message #53537]

Tue, 05 July 2005 22: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

Report message to a moderator

Re: newbie failes to create a simple chart... [message #53832 is a reply to message #53537]

Wed, 06 July 2005 00: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
>
>
>

Report message to a moderator

Re: newbie failes to create a simple chart... [message #54116 is a reply to message #53832]

Wed, 06 July 2005 07:41

Florian Schaefer

Messages: 14
Registered: July 2009

Junior Member

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ür
Treiber (org.eclipse.birt.report.data.oda.jdbc) nicht geöffnet werden.
Cannot load JDBC Driver class: [com.mysql.jdbc.Driver].
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:101)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:147)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:140)
at
..
..
..
and so on...
..
..
..
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot
load JDBC Driver class: [com.mysql.jdbc.Driver].
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:294)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:143)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:92)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:218)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:179)
at
org.eclipse.birt.data.engine.odaconsumer.manager.OdaConnecti on.open(OdaConnection.java:221)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:89)
... 55 more

sounds simple but somehow I don't know why this happens...

Florian

Report message to a moderator

Re: newbie failes to create a simple chart... [message #54169 is a reply to message #54116]

Wed, 06 July 2005 07:53

Florian Schaefer

Messages: 14
Registered: July 2009

Junior Member

I forgot this point: I use eclipse 3.0.1

Report message to a moderator

Re: newbie failes to create a simple chart... [message #54196 is a reply to message #54116]

Wed, 06 July 2005 08: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

Report message to a moderator