Unix Technical Forum

setObject(col, blob) throws PSQLException

This is a discussion on setObject(col, blob) throws PSQLException within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> So does setObject(col, blob, Types.Blob). Whereas setBlob(col, blob) works fine in the same test case. This case is like ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces jdbc

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 11:39 PM
Marc Herbert
 
Posts: n/a
Default setObject(col, blob) throws PSQLException


So does setObject(col, blob, Types.Blob).

Whereas setBlob(col, blob) works fine in the same test case.

This case is like missing in the big switch found in the code.
Is this on purpose?


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-15-2008, 11:39 PM
Kris Jurka
 
Posts: n/a
Default Re: setObject(col, blob) throws PSQLException



On Thu, 29 Sep 2005, Marc Herbert wrote:

> So does setObject(col, blob, Types.Blob).
>
> Whereas setBlob(col, blob) works fine in the same test case.
>
> This case is like missing in the big switch found in the code.
> Is this on purpose?


No, that's an oversight which I'll fix. Perhaps we were concerned about
trying to do a conversion for something like setObject(col, "string data",
Types.BLOB)?

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-15-2008, 11:39 PM
Kris Jurka
 
Posts: n/a
Default Re: setObject(col, blob) throws PSQLException



On Thu, 29 Sep 2005, Marc Herbert wrote:

> [setObject(col, blob, Types.Blob) throw Exception]
>


I've commited a fix to cvs for both the 8.0 and 8.1 branches. Types.CLOB
and Types.ARRAY also suffered the same problem.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-15-2008, 11:39 PM
Marc Herbert
 
Posts: n/a
Default Re: setObject(col, blob) throws PSQLException

Kris Jurka <books@ejurka.com> writes:

> On Thu, 29 Sep 2005, Marc Herbert wrote:
>
>> [setObject(col, blob, Types.Blob) throw Exception]
>>

>
> I've commited a fix to cvs for both the 8.0 and 8.1 branches.
> Types.CLOB and Types.ARRAY also suffered the same problem.
>


I just had a look at it (did not try it yet) and it seems you fixed:

setObject(int parameterIndex, Object x)

But not:

setObject(int parameterIndex, Object x, int targetSqlType)


Am I missing something ? (besides an actual test :-/







---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-15-2008, 11:39 PM
Kris Jurka
 
Posts: n/a
Default Re: setObject(col, blob) throws PSQLException



On Mon, 3 Oct 2005, Marc Herbert wrote:

> I just had a look at it (did not try it yet) and it seems you fixed:
>
> setObject(int parameterIndex, Object x)
>
> But not:
>
> setObject(int parameterIndex, Object x, int targetSqlType)
>


Actually I did it the other way around, I fixed setObject(int, Object,
int), but not setObject(int, Object). I've fixed this now as well.

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:29 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com