Use Mysql Database

[ktrinad]

By: Allen Lin - allendarjer

Use Mysql Database

2003-03-16 22:13

I use mysql database,i set the connection

driver = org.gjt.mm.mysql.Driver

url = jdbc:mysql://localhost/atl

when i test connect it's OK

and i can get the field.

But when i compiler the XML and run it!!

It will appear error message!!

Compiling to file... C:CVS-ViewatlinkjspreportATL_Translator_Performance_old.jasper

 

Compilation running time : 9613

 

Opening connection....

 

org.gjt.mm.mysql.jdbc2.NotImplemented

 

at org.gjt.mm.mysql.jdbc2.ResultSet.getStatement(ResultSet.java:1979)

 

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:379)

 

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:157)

 

at IReportCompiler.main(IReportCompiler.java:151)

 

 

NESTED BY :

 

dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : ATL_Translator_Performance_old

 

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:391)

 

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:157)

 

at IReportCompiler.main(IReportCompiler.java:151)

 

Caused by: org.gjt.mm.mysql.jdbc2.NotImplemented

 

at org.gjt.mm.mysql.jdbc2.ResultSet.getStatement(ResultSet.java:1979)

 

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:379)

 

... 4 more

 

 

 

Abnormal termination!

 

Please Help Me!!

 

 

 

 

By: Giulio Toffoli - gt78

RE: Use Mysql Database

2003-03-17 00:40

it's strange: seems that jasperreports use a method not implemented in the driver. I use mysql too without problems.

 

The only suggestion that I can give you is to try to change/update your JDBC driver.

 

Let me know if this resolve the problem.

 

Giulio

 

 

 

 

By: Allen Lin - allendarjer

RE: Use Mysql Database

2003-03-17 18:25

Thank you Giulio!!

I update my JDBC driver(2.0.2->2,0,14)

My problem is solve!!

If anybody need this driver, please mail to me!!

 

 

 

 

By: Simon Chevrier - simonchevrier

RE: Use Mysql Database

2003-05-05 06:05

Hi,

 

I got the same problem with my application

 

Can you send to me the jdbc driver or the link where you found it?

 

thanks

 

Simon

 

 

 

 

By: Simon Chevrier - simonchevrier

RE: Use Mysql Database

2003-05-05 06:16

Ok I find it

 

Thanks for the post

 

Simon