JFreeChart and Jdbc

A discussion forum for JFreeChart (a 2D chart library for the Java platform).
Locked
herve

JFreeChart and Jdbc

Post by herve » Thu Aug 15, 2002 5:47 pm

Hello,

Help please, a simple example (JFreeChart and Jdbc)
(for Ms-Access 2000)

Thanks.

David Gilbert

Re: JFreeChart and Jdbc

Post by David Gilbert » Thu Aug 15, 2002 8:22 pm

Hi Herve,

I have finished writing up some simple JDBC examples for the PDF documentation. I'm just tidying up some other new stuff on servlets, and I will release a new version of the document (the one you have to pay for).

The code for these examples is committed to CVS, so you can look at that now. I've done my testing against PostgreSQL...it's hard to run Ms-Access 2000 on Linux! But you should be able to set up some tables in Access and have it work just the same.

Regards,

DG.

herve

Re: JFreeChart and Jdbc

Post by herve » Thu Aug 15, 2002 8:50 pm

Hi David,

It's not Ms-Access 2000 for linux but Windows.

@+

David Gilbert

Re: JFreeChart and Jdbc

Post by David Gilbert » Fri Aug 16, 2002 6:05 am

herve wrote:
> It's not Ms-Access 2000 for linux but Windows.

I know, but I run Linux so I can't test the JDBC code with Access.

Regards,

DG

herve

Re: JFreeChart and Jdbc

Post by herve » Fri Aug 16, 2002 4:19 pm

Hi,

Information:

I download and try with MySQL for windows 98

I use ODBC and i've the same thing than Ms-Access.


Unable to load column 3(5)
Java.Sql.SQLException: No Data Found.

(Nb: Sorry for English, i'am bad).

@+
Thanks.

Navin Pathuru

Re: JFreeChart and Jdbc

Post by Navin Pathuru » Fri Aug 16, 2002 9:45 pm

Herve,
I am not sure if this will help, but look at this web site and see if you can find anything:
http://forum.java.sun.com/thread.jsp?fo ... read=89901

Regards,
Navin Pathuru

Bryan

Re: JFreeChart and Jdbc

Post by Bryan » Fri Aug 16, 2002 10:38 pm

Herve

I am still away from work for another week. If you have not resolved by then I would be happy to get a copy of your mdb file and see if I can get it working.

Bryan

herve

Re: JFreeChart and Jdbc

Post by herve » Sun Aug 18, 2002 11:55 am

Hi Bryan, Hi David,

For Information:

I try with MySQL for windows 98 and i don't use ODBC ("sun.jdbc.odbc.JdbcOdbcDriver")

but i use the driver of type 4 ("com.mysql.jdbc.Driver")
--> (A native Java driver).

The test is good.

@+
Thanks.

Locked