JDBC Problem Part III (SQL error?)

[Former Member]

Hey,

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?

Thanks

chris

[former_member187339 · Accepted solution]

Hi,

Do a dummy change in the JDBC adapter and activate that. Also do a cache refresh.

Regards

Suraj

[Former Member · Accepted solution]

You are right. That works. Unbelievable that such bugs exists. I would have never tried this.

10 points for you

thanks

chris