Skip to Content
Former Member
Oct 20, 2006 at 08:24 AM

JDBC Problem Part III (SQL error?)



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?