iReport to DB2 connection ERRORCODE=-4499, SQLSTATE=08001

db2 ireport
Yebach picture Yebach · May 25, 2012 · Viewed 13.1k times · Source

I am using Jasper iReport. When I try to connect to IBM DB2 I get an error: "Permission denied: ERRORCODE=-4499, SQLSTATE=08001"

I am using the same driver to connect as Razor which I also use and there it works ok (same settings, username, password, etc).

This problem started to occur lately.

Any suggestions?

Thank you

Answer

Amit Bhatnagar picture Amit Bhatnagar · Jun 21, 2013

Please make sure that any firewalls and/or proxy servers in between have been configured to let your requests through. We had a similar error & it turned out to be that the firewall between our appserver & db2 did not have the required port open.

Related questions

SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

What does sqlcode -302 means? Where do i get the sqlcode definitions? Please advice Thanks,

Read More
How to view DB2 Table structure

How to view the table structure in DB2 database

Read More
DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the …

Read More