Hibernate+Wizard:Cannot Open Connection

[2006 IR Open Dicussion]

By: mloudon - mloudon

Hibernate+Wizard:Cannot Open Connection

2006-05-04 01:42

I'm trying to use the Report Wizard in iReport 1.2.2 . I can add a hibernate data source, and when I press 'test' the test is successful. However when I enter a query I get the message 'General Problem:Cannot Open Connection'

 

If anyone can help, I'd really appreciate it.

 

Melissa

 

 

 

 

By: mloudon - mloudon

RE:FIXED Cannot Open Connection

2006-05-05 06:07

Fixed it - the problem was that the relevant jdbc driver (postgresql, in my case) needed to be copied into the lib/ directory of iReport

 

 

 

 

By: abioye - abioye

RE: Hibernate+Wizard:Cannot Open Connection

2006-05-18 08:02

i am getting the same error but i am using sqlserver and i have copied the 3 jar files: mssqlserver, msbase and msutil to the lib directory. however, the error persists! Please, any help, anyone? i need to sort this out quickly.

 

 

 

 

By: Andrea Gioia - drjey

RE: Hibernate+Wizard:Cannot Open Connection

2006-06-13 03:36

I faced the same problem just today. I noticed that ireport is unable to build the hibernate connection just when it is started up from the exe file. Try to start it up from the bat file and the problem should be fixed. Probably this is juat a bug of ireport exe file but i'm not sure about that.

 

Obviusly you have to check that your class path is properly configured before doing this try.

 

Bye

 

 

 

 

By: Giulio Toffoli - gt78

RE: Hibernate+Wizard:Cannot Open Connection

2006-06-15 05:25

It's a limitation of the wrapper that is not able to fill dynamically the static classpath

 

Using iReport.bat should fix the problem.

 

Giulio