Re: Longvarbinary

Amit,

Patch applied.

thanks,
--Barry


Amit Gollapudi wrote:
> Since I have not heard back from anyone about this problem, I'm
> including the tiny patch that fixed the problem for us.  Can someone
> with commit rights to the code verify and commit the patch?  Please note
> that the patch was created against the source for 7.3.2.
>
> Thank you,
> Amit Gollapudi
> Demand Management, Inc.
>   Amit Gollapudi wrote:
>
>> We ran across this problem a couple of weeks ago.  Calling setObject
>> with a "longvarbinary" type on a statement was causing an "Unknown Types
>> value." SQLException.  Is there any reason why the case statements at
>> AbstractJdbc1Statement:1385 should not include Types.LONGVARBINARY?  I'm
>> fairly new to this codebase - so, it's possible I overlooked something
>> obvious.
>>
>> Thank you,
>> Amit Gollapudi
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>
>
> ------------------------------------------------------------------------
>
> --- AbstractJdbc1Statement.java 2002-11-20 01:54:27.000000000 -0600
> +++ /home/gollapudi/tmp/AbstractJdbc1Statement.java     2003-04-24 15:21:17.000000000 -0500
> @@ -1383,6 +1383,7 @@
>                                 break;
>                         case Types.BINARY:
>                         case Types.VARBINARY:
> +                       case Types.LONGVARBINARY:
>                                 setObject(parameterIndex, x);
>                                 break;
>                         case Types.OTHER:
> @@ -1433,7 +1434,7 @@
>                                 l_sqlType = Types.TIMESTAMP;
>                         else if (x instanceof Boolean)
>                                 l_sqlType = Types.OTHER;
> -                       else
> +                       else
>                                 l_sqlType = Types.OTHER;
>
>                         setNull(parameterIndex, l_sqlType);
>
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)