var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 jdbc error
I have a db2 table T_CNTRT_NOTES
When I run the following query through my java application :
SELECT TRANSACTION_NUMBER FROM DB2ADMIN.T_CNTRT_NOTES WHERE CONTRACT_NOTE_NUMBER = '111111'
I get the following error
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022
though the column already Exists
When I run the same query from db2 command line it works fine
I am using IBM DB2 version 8.1 on AIX 4.3
Any help would be greatly appreciated
Are you connected to the same database in both cases ...
In your application use the metadata apis and get information on the table columns and confirm the column exists in the database you connect to
Visit the new-look IDUG Website
, register to gain access to the excellent content.
I am connected to the same database and the column exists in the database
The query runs fine on DB2 command line but it fails in java application