Skip to Content
author's profile photo Former Member
Former Member

JDBC Problem Part III (SQL error?)

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 20, 2006 at 08:29 AM

    Hi,

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

    Regards

    Suraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.