Do you have the DB2 plugin installed ? If not, then you might see more
descriptive error messages if you install the DB2 plugin.
Rob
On Wed, Nov 9, 2011 at 2:28 PM, Edwi Feitoza <edw...@gm...> wrote:
> Hi everyone!
>
> I am Edwi Feitoza, from São Paulo, Brazil!
>
> Recently I have used Squirrel SQL as my primary SQL Editor, but I am
> having problems with error messages.
>
> For example, when I execute a query with some error on Squirrel SQL, the
> error log shows me the following message:
>
> "*Error: DB2 SQL Error: SQLCODE=-203, SQLSTATE=42702,
> SQLERRMC=PERSONGROUP, DRIVER=3.62.56
> SQLState: 42702
> ErrorCode: -203
> Error:DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,
> SQLERRMC=2;-203;42702;PERSONGROUP, DRIVER=3.62.56
> SQLState: 56098
> ErrorCode: -727*"
>
> But when I execute the same query on Eclipse, it shows the same error,
> however with its description. Like this:
>
> "*A reference to column "PERSONGROUP" is ambiguous.. SQLCODE=-203,
> SQLSTATE=42702, DRIVER=3.62.56*"
>
> Look that the presence of error description helps to know the reason of
> failure quickly.
>
> I'd like to know why Squirrel SQL does not show the SQL description erros
> in log. Detail: the JDBC jar file used in Squirrel SQL and Eclipse are the
> same.
>
> Thanks a lot.
>
> --
> Edwi Oliveira Santos Feitoza
>
> Ubi Dubium Ibi Libertas
>
>
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|