iReport hangs on testing connection

[bandellwork]

I recently downloaded iReport 4.5.0 an upgrade from 4.1.0. However when I imported the settings and try to run a report the report output would just say FILLING Report. So I went to test the connection and as soon as I click test the application freezes. I have the sqljdbc4.jar in the class path and all of the same jars as in the older version. I even went back to the old version and now it also freezes when test is click. Any ideas what the issue could be?

[bandellwork]

I found the problem. iReports was pointing to jdk1.6.0_29 which has a bug with the driver manager.

The line,

DriverManager.getConnection(theConnectionString, theUserName, thePassword);

get hung when running a java application. So I download jdk1.7.0_02 and pointed iReports to that jdk and now it is able to connect to the database.

 

[mmicali]

Hi, i have got the same problem, with Sql Server JDBC Drivers.

The problem is that some JDBC Drivers do not work correctly so, you can try to get another version on Drivers.

After i have installed new the comunity edition of JDBC Drivers ther iReport work Correctly.

 

Max-