2009/1/9, Fabio Alves de Araujo Ebner - Dna <[email protected]>: > Pessoal estou com um problema no meu java.. > > tenho o meu banco postgres e criei o db com encoding LATIN1 > > > quando eu mando inserir no meu banco usando TOPLINK > recebo o seguinte erro: > > > > javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle > TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): > oracle.toplink.essentials.exceptions.DatabaseException > Internal Exception: org.postgresql.util.PSQLException: ERROR: character > 0xe28093 of encoding "UNICODE" has no equivalent in "LATIN1" > Error Code: 0 > Call: INSERT INTO db_notas.tb_imovel_documento (ds_tp_alienacao_imovel, > ds_circunscricao_imovel, nr_registro_imovel, vl_alienacao_aquisicao_imovel, > nr_registro_anterior_imovel, nm_area_imovel, ds_regiao_imovel, > nr_area_imovel, ds_tipo_imovel, nr_ato_imovel, nr_lote_imovel, > tp_construcao_imovel, nr_numero_imovel, nm_valor_consta_imovel, > nm_endereco_imovel, ds_itbi_consta_imovel, sg_estado_imovel, > ic_avaliacao_imovel, ds_indicador_fiscal_imovel, > nm_orgao_emissor_avaliacao_imovel, nm_alienacao_imovel, vl_avaliacao_imovel, > nr_gui_itbi_imovel, nm_complementro_registro_anterior_imovel, > nr_aliquota_imovel, cd_cep_imovel, vl_itbi_imovel, nm_bairro_imovel, > dt_vencimento_avaliacao_imovel, ds_complemento_imovel, > dt_recolimento_itbi_imovel, dt_alienacao_ivovel, vl_venal_imovel, tp_imovel, > ds_observacao_imovel, nm_cidade_imovel, nr_quadra_imovel, > nm_complementro_registro_imovel, tp_alienacao_imovel, cd_livro_imovel, > cd_documento, cd_livro_anterior_imovel) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?) > bind => [43534, 543, 5, 55, null, 1 - Nao, 1 - Urbano, 23.0, > Conjunto Comercial, 55, null, 0 - Construcao Averbada , 377, 0 - Sim, libero > badaro, 0 - Sim, SP, null, 43543, null, 15 - Adjudicacao , null, null, 5345, > 1.5, 212, null, centro, null, 2011, null, 2009-01-14, null, 67 - Casa , > null, sao paulo, 6, 52, 5 - A vista, 1, 1, 2] > Query: > InsertObjectQuery(br.com.dnasolution.entity.TbImovelDocumento[cdImovel=null]) > Call: INSERT INTO db_notas.tb_imovel_documento (ds_tp_alienacao_imovel, > ds_circunscricao_imovel, nr_registro_imovel, vl_alienacao_aquisicao_imovel, > nr_registro_anterior_imovel, nm_area_imovel, ds_regiao_imovel, > nr_area_imovel, ds_tipo_imovel, nr_ato_imovel, nr_lote_imovel, > tp_construcao_imovel, nr_numero_imovel, nm_valor_consta_imovel, > nm_endereco_imovel, ds_itbi_consta_imovel, sg_estado_imovel, > ic_avaliacao_imovel, ds_indicador_fiscal_imovel, > nm_orgao_emissor_avaliacao_imovel, nm_alienacao_imovel, vl_avaliacao_imovel, > nr_gui_itbi_imovel, nm_complementro_registro_anterior_imovel, > nr_aliquota_imovel, cd_cep_imovel, vl_itbi_imovel, nm_bairro_imovel, > dt_vencimento_avaliacao_imovel, ds_complemento_imovel, > dt_recolimento_itbi_imovel, dt_alienacao_ivovel, vl_venal_imovel, tp_imovel, > ds_observacao_imovel, nm_cidade_imovel, nr_quadra_imovel, > nm_complementro_registro_imovel, tp_alienacao_imovel, cd_livro_imovel, > cd_documento, cd_livro_anterior_imovel) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?) > bind => [43534, 543, 5, 55, null, 1 - Nao, 1 - Urbano, 23.0, > Conjunto Comercial, 55, null, 0 - Construcao Averbada , 377, 0 - Sim, libero > badaro, 0 - Sim, SP, null, 43543, null, 15 - Adjudicacao , null, null, 5345, > 1.5, 212, null, centro, null, 2011, null, 2009-01-14, null, 67 - Casa , > null, sao paulo, 6, 52, 5 - A vista, 1, 1, 2] > > > alguem sabe o pq??
Apesar da aparência similar o caracter 0xe28093 não é um simples hifen (0x2d). Tente convertê-lo antes de inserir. Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
