Johann Robette wrote:
> java.sql.SQLException: ERROR: cannot cast type text to
setArray has never worked particularly well; you're seeing another
The underlying problem here is that:
- setArray() is claiming that the type it is setting is a VARCHAR
- the parameter is being passed as a typed parameter via the V3
protocol, with type = 'text'
- apparently you can't cast directly from text -> text (although you
can interpret an untyped literal as text, which is why it worked before).
It seems possible to fix the driver to handle this case by making
setArray() derive a proper array type name i.e. ("_" +
Array.getBaseType()), and using that rather than 'text' as the parameter
I'll try to do this soon, but I'm a bit busy so it may be a few days.
A longer term fix is to properly implement array support in setArray()..
I've submitted patches in the past to do this but they've never made it
into the official driver.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2004-10-05 20:31:39|
|Subject: Re: Postgres 8.0 + JDBC|
|Previous:||From: Johann Robette||Date: 2004-10-05 16:25:52|
|Subject: Postgres 8.0 + JDBC|
pgsql-general by date
|Next:||From: Mike Morris||Date: 2004-10-05 20:15:39|
|Subject: SSL connection between PHP4 & PostgreSQL ???|
|Previous:||From: Frank Miles||Date: 2004-10-05 18:57:56|
|Subject: Re: Verifying Referential Integrity|