Ok..Gabreil was spot on about the problem of using Phoenix-client.jar when its not present in the lib directory of Squirell.
I had an old jar of phoenix-client in lib folder of Squirell and i also added new phoenix-client in extra classpath and i was under impression that client jar in extra classpath is being used. However, in reality client jar under lib folder was being used. After updating the client jar under lib folder, i can set the Unsigned_date correctly. The trick works. :) . I'll create the patch and submit it. On Wed, May 7, 2014 at 4:31 PM, anil gupta <[email protected]> wrote: > Hi James, > > I tried the trick that you told me and still Squirell is complaining > about "<UnknownType (19)>". I only modified PDataType for UNSIGNED_DATE. Do > i need to modify any other class? Would you mind checking a UNSIGNED_DATE > column in Squirell on your setup. Maybe, i am doing something wrong. > > Thanks, > Anil > > > On Thu, May 1, 2014 at 7:01 PM, James Taylor <[email protected]>wrote: > >> Hi Anil, >> The reason is that there is no standard unsigned date SQL type that >> Phoenix can map to, so Squirrel does not know how to interpret this type. >> An easy fix should be to override the following method in PDataType for >> UNSIGNED_DATE, UNSIGNED_TIME, and UNSIGNED_TIMESTAMP like this (returning >> the corresponding regular type which SQuirrel will understand): >> >> >> @Override >> public int getResultSetSqlType() { >> return DATE.getResultSetSqlType(); >> } >> >> Would you mind giving this a try and if successful send us a patch? We >> should be able to get it into our upcoming 3.1/4.1 release. >> >> Thanks, >> James >> >> >> On Thu, May 1, 2014 at 4:58 PM, anil gupta <[email protected]> wrote: >> >>> Hi All, >>> >>> I have Unsigned_Date Type columns in my phoenix tables. Squirell is >>> unable >>> to display the values. Instead of value it displays : "<UnknownType >>> (19)>" >>> What is the reason Squirell is unable to show that column? Can anyone >>> tell >>> me how to fix this problem(without changing the columns to Date)? >>> >>> -- >>> Thanks & Regards, >>> Anil Gupta >>> >> >> > > > -- > Thanks & Regards, > Anil Gupta > -- Thanks & Regards, Anil Gupta
