|
From: Edwi F. <edw...@gm...> - 2011-11-17 14:16:51
|
Hi, Robert! Finally I solved the problem and now I will share with you the solution that I found. When I created the JDBC URL Connection using an IBM Database Tool, called "IBM Data Studio" (based on Eclipse platform) I saw a little difference between the same JDBC URL created by Squirrel SQL. See it below: jdbc:db2://x.x.x.x:50000/DATABASEDB2:* retrieveMessagesFromServerOnGetMessage=true*; The text marked in bold shows what was different. Now error codes and error messages are displayed successfully! Thanks for helping. Edwi Oliveira Santos Feitoza São Paulo - Brasil 2011/11/10 Edwi Feitoza <edw...@gm...> > Hi, Robert! > > Reading the Squirrel SQL Official site I noticed that I had installed > without DB2 plugin. Then I uninstalled him and I installed again with DB2 > plugin. But the format of error messages remains the same. > > Thank you for answer and sorry for any english mistakes. > > > > > 2011/11/9 Robert Manning <rob...@gm...> > >> 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 >>> >>> >> > > > -- > Edwi Oliveira Santos Feitoza > > Ubi Dubium Ibi Libertas > -- Edwi Oliveira Santos Feitoza Ubi Dubium Ibi Libertas |
