Skip site navigation (1) Skip section navigation (2)

Re: Search content within a bytea field

From: Kris Jurka <books(at)ejurka(dot)com>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: Kris Jurka <books(at)ejurka(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Damiano Bolzoni <damiano(dot)bolzoni(at)gmail(dot)com>, Sylvain Leroux <sl20(at)wanadoo(dot)fr>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Search content within a bytea field
Date: 2009-09-05 14:26:53
Message-ID: 4AA2752D.60709@ejurka.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Florian Weimer wrote:
> * Kris Jurka:
> 
>> Use setObject(int, object, Types.OTHER);
> 
> I get a PSQLException with "Cannot cast an instance of
> java.lang.String to type Types.OTHER".  Other types (such as Integer)
> don't work, either.
> 
> I look rather hard at Debian's 8.2-504-3 source but couldn't find a
> straightforward way to make this work, beyond specifying
> stringtype=unspecified for the whole connection.
> 

This is new functionality in 8.3 and newer drivers.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Anjani Kumar SahuDate: 2009-09-07 07:29:46
Subject: Need help to download jdbc driver in Dspace windows
Previous:From: Florian WeimerDate: 2009-09-05 14:06:07
Subject: Re: Search content within a bytea field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group