Re: error getString() --> decodeUTF8 / - Mailing list pgsql-jdbc

From Pedro Salazar
Subject Re: error getString() --> decodeUTF8 /
Date
Msg-id 1050314979.998.34.camel@vitoria.intra.cet.pt
Whole thread Raw
In response to Re: error getString() --> decodeUTF8 /  (Barry Lind <blind@xythos.com>)
Responses setCatalog
Re: error getString() --> decodeUTF8 /
Re: error getString() --> decodeUTF8 /
List pgsql-jdbc
Barry,

Besides the improved message issue, I tried with a database with the
default locale (C), but I also tried to restore the database to the
cluster with portuguese locale (pt_PT) (initdb --locale=pt_PT
--lc-colate=pt_PT --lc-ctype=pt_PT --lc-message=pt_PT), and I still have
the same error in JDBC (not the improved message, but the error).

What configurations should I have to support portuguese locale in my
database/JDBC?

thanks,
Pedro Salazar.

On Fri, 2003-04-11 at 16:46, Barry Lind wrote:
> Pedro,
>
> If you were running the latest build from http://jdbc.postgresql.org you
> would see the following improved error message:
>
> Invalid character data was found.  This is most likely caused by stored
> data containing characters that are invalid for the character set the
> database was created in.  The most common example of this is storing
> 8bit data in a SQL_ASCII database.
>
> thanks,
> --Barry
>
>
> Pedro Salazar wrote:
> > Hi,
> >
> > I forgot to tell that I'm using the JDBC driver build from postgresql
> > 7.3.2.
> >
> > PS
> >
> > On Fri, 2003-04-11 at 11:19, Pedro Salazar wrote:
> >
> >>Greetings,
> >>
> >>I have function that returns a refcursor. When I call it in plpgsql
> >>shell, it returns all the rows correctly. But, When I call it in JDBC,
> >>when it tries to decode a string in specific row (7) it throws the
> >>following exception:
> >>
> >>java.lang.ArrayIndexOutOfBoundsException: 5
> >>        at org.postgresql.core.Encoding.decodeUTF8(Encoding.java:254)
> >>        at org.postgresql.core.Encoding.decode(Encoding.java:165)
> >>        at org.postgresql.core.Encoding.decode(Encoding.java:181)
> >>        at
> >>org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:97)
> >>
> >>My refcursor returns the following list (the characters are in
> >>portuguese language):
> >>
> >> id |    class
> >>----+-------------
> >>  1 | Avenida
> >>  2 | Bairro
> >>  3 | Cais
> >>  4 | Estrada
> >>  5 | Largo
> >>  6 | Lugar
> >>  7 | Praça
> >>  8 | Rotunda
> >>  9 | Rua
> >> 10 | Sítio
> >> 11 | Travessa
> >> 12 | Urbanização
> >>
> >>The row number 7 (Praça) [character 'C' with cedilla] is throwing the
> >>above exception. How should I retrieve my string which has portuguese
> >>characters, in JDBC?
> >>
> >>thanks,
> >>Pedro Salazar.
--
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61

Attachment

pgsql-jdbc by date:

Previous
From: Pedro Salazar
Date:
Subject: Re: tomcat/postgres problem
Next
From: "Patrik Lundgren"
Date:
Subject: setCatalog