DB2 JDBC Connection failed under iReport 3.7.4

[azh]

I need to use a DB2 JDBC connection using iReport, the driver suggested is "IBM DB2 (COM.ibm.db2.jdbc.app.DB2Driver)"

Ireport is not packaged with db2 jdbc driver , so I've done the followng steps with out succès.

1. Menu Tools->Options->Classpath

     Add JAR:              db2java.zip, 

                                    db2jcc.jar, 

                                     db2jcc_license_cu.jar

2. Create new report with Database JDBC connection option and typed the following parameters:

      Name:                  DB2 JDBC Test

      JDBC Driver:       IBM DB2 (COM.ibm.db2.jdbc.app.DB2Driver)

      JDBC URL:         jdbc:db2:localhost/SampleDB

      username:         sample_user

      password:           1234567890

     Save password: checked

3. Click on Test Button to check the connection:

 

               SQL problems: [iBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009

                jdbc:db2:localhost/SampleDB

 

 

4. The port number of DB2 is 50000, the database is OK since I'm using it in my application.

 

 The ultimate Guide documentation suggest another way using the iReport command menu Windows->Services.  This faild with COM.ibm.db2.jdbc.app.DB2Driver 

After the driver added abd database configured with  COM.ibm.db2.jdbc.jcc.DB2Driver The tables tree is displayed. again  I tried to create a new report with this JDBC driver and I get the message even if I checked the password saving.

IBM DB2 SampleDB

General problem: null

Please check your username and password. The DBMS is running?

 

Please help

 

Post Edited by azh at 06/24/2011 10:33

Post Edited by azh at 06/24/2011 10:52

Post Edited by azh at 06/24/2011 12:37

[tunisian_zou]

 I have the same issue . can I have any idea about this problem.

Thank you

[krishrocks.rocks]

 

 I have the same issue . can I have any idea about this problem.

Thank you

[imran.syed15]

Same problem with msg:      General problem: null

Please check your username and password. The DBMS is running?!

 

"please help"