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??_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
