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(at)postgresql(dot)org)