Hibernate Connection Datasource not running

[vmustafa]

Hi,

I am trying to use Hibernate Connection as the data source (using MySql) with iReports (version iReports 3.1.2) but am unsuccessful. After doing the initial config file & mapping file checkups, iReport is unable to open connection - "Cannot open connection" while testing the Hibernate connection. The main messages in the IDE-Log are:-

1 - java.lang.IllegalStateException: You are trying to access file: hibernate.cfg.xml from the default package. Please see http://www.netbeans.org/download/dev/javadoc/org-openide-modules/org/openide/modules/doc-files/classpath.html#default_package
 

2 - org.hibernate.exception.GenericJDBCException: Cannot open connection
 

3 - Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3307/xxx
 

The hibernate associated files are in the directory -

C:Program FilesJasperSoftiReport-nb-3.1.2ireportmodulesext

The MySql related file - mysql-connector-java-5.0.7-bin.jar - is in directory -

C:Program FilesJasperSoftiReport-nb-3.1.2ide8modulesext

Why is iReport not able to access a suitable driver for mysql?

Please help!!

Regards

vmustafa

 

 

Post Edited by Mustafa Vadnagarwala at 02/06/09 11:32

[sjeg]

Place the driver .jar in the ext folder of your JDK, that is the only way for now, i've tried everything else.

[bob007]

Hi,

 

I had the same problem as vmustafa when trying to use Hibernate Connection ("Cannot open connection") and i tried your solution.

"Place the driver .jar in the ext folder of your JDK"

 

Now i got a new message error :

"No data type for node : org.hibernate.hql.ast.IdentNode -[iDENT] IdentNode 'adress' {originalText=adress}"

ITS VERY ODD because I don't have any adress in my hibernate mapping...

I see some other peoples on the forum with a similar problem but no solution to it ...

 

What can i do about it ?

Is iReport really suppose to work with hibernate connection ?

 

thanks,

 

 

Post Edited by Philippe Yelle at 04/06/09 14:48