Help jdbc NoClassDefFoundError

[2004 IR Help]

By: barrox - barrox

Help jdbc NoClassDefFoundError

2002-10-29 14:55

Hello

 

I'm new to iReport and on my first day I've been unable to make a conection using iReport 0.0.5 and latest Firebird (Interbase) jdbc driver.

I uncompressed all the .jar files of the driver because adding the jars insted of the directory I got the error "ClassNotFoundError"

Also tryed with MySQL and all worked fine, only addind its jar to the classpath.

 

Thanks in advance for your answers, Fernando.

 

 

 

 

By: Giulio Toffoli - gt78

RE: Help jdbc NoClassDefFoundError

2002-10-29 15:35

The simpler solution (it is not elegant but works fine) is to copy all class you need into the iReport directory. This directory is, infact, in Java sun classpath and in MS JVM classpath.

 

 

I hope this helps you

Giulio

 

 

 

 

By: barrox - barrox

RE: Help jdbc NoClassDefFoundError

2002-10-30 01:51

After uncompressing all the jars into the iReport directory continue with the same error "NoClassDefFoundError".

I'm becoming crazy with this error because this jdbc driver works fine whith JBuilder.

Is there any way of obtaining more info about what causes the error?

 

 

Many thanks, Fernando.

 

 

 

 

By: Giulio Toffoli - gt78

RE: Help jdbc NoClassDefFoundError

2002-10-30 02:44

In wich context you become NoClassDefFoundError ? Compiling report? Retriving fields? When?

 

Giulio

 

 

 

 

By: barrox - barrox

RE: Help jdbc NoClassDefFoundError

2002-10-30 07:23

I get the error when I test the connection:

Database->Connections->Modify->Test

or when I try to add database field to a report executing a query:

Database->Report Query

Driver is: org.firebirdsql.jdbc.FBDriver

and jdbc url: jdbc:firebirdsql:linux/3050:/opt/cierres.gdb

As an emergency solution I made the same database structure on MySQL and query it from iReport to obtain fields, then on my program will call jasper with the apropiate driver, which works fine with jasperReports.

 

Thanks Giulio for this great tool!

 

 

 

 

 

By: John Arthur - n0n

RE: Help jdbc NoClassDefFoundError

2002-10-31 15:04

I too have the same exact issue and symptoms as described above. Except I am using the jTDS driver (net.sourceforge.jtds.jdbc.Driver). MySQL works fine as does hsql