I tried to add a column to a working JDBC request. I received an error that predicated, that the column does not exist:
<i>Error when executing statement for table/stored proc. 'dbo.myTable' (structure 'STATEMENT'): java.sql.SQLException: FATAL ERROR: Column 'softwareSubID' does not exist in table 'dbo.myTable'</i>
But I checked the the table and the column exists and is also correct written (case sensitiv).
The column type is smallint, but it works also with another column of this type. I tested the field with the tool "SQL Query Analyser" with this statement:
<i>Select * from dbo.myTable where softwareSubID = 1</i>
and it response correct data.
Does anyone has experience with this problem?