cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Problem Part III (SQL error?)

Former Member
0 Kudos
73

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member187339
Active Contributor
0 Kudos

Hi,

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

Regards

Suraj

Former Member
0 Kudos

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

10 points for you

thanks

chris

Answers (0)