Re: error getString() --> decodeUTF8 /
От | Pedro Salazar |
---|---|
Тема | Re: error getString() --> decodeUTF8 / |
Дата | |
Msg-id | 1050314979.998.34.camel@vitoria.intra.cet.pt обсуждение исходный текст |
Ответ на | Re: error getString() --> decodeUTF8 / (Barry Lind <blind@xythos.com>) |
Ответы |
setCatalog
("Patrik Lundgren" <patrik@mensa.se>)
Re: error getString() --> decodeUTF8 / (Daniel Serodio <daniel@checkforte.com.br>) Re: error getString() --> decodeUTF8 / (Barry Lind <blind@xythos.com>) |
Список | 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
Вложения
В списке pgsql-jdbc по дате отправления: