Lucas_Cavalcanti 13 de jan. de 2011
qual é o banco de dados?
as chaves estrangeiras estão configuradas corretamente no hibernate?
radafit 14 de jan. de 2011
O banco de dados é Postgres
o hibernate.cfg.xml tá assim....
& lt ;? xml version =& quot ; 1 . 0 & quot ; encoding =& quot ; UTF-8 & quot ;?& gt ;
& lt ;! DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" & gt ;
& lt ; hibernate-configuration & gt ;
& lt ; session-factory & gt ;
& lt ; property name = "hibernate.dialect" & gt ; org . hibernate . dialect . PostgreSQLDialect & lt ;/ property & gt ;
& lt ; property name = "hibernate.connection.driver_class" & gt ; org . postgresql . Driver & lt ;/ property & gt ;
& lt ; property name = "hibernate.connection.url" & gt ; jdbc : postgresql :// localhost : 5432 / nutec & lt ;/ property & gt ;
& lt ; property name = "hibernate.connection.username" & gt ; root & lt ;/ property & gt ;
& lt ; property name = "hibernate.connection.password" & gt ; debian23 & lt ;/ property & gt ;
& lt ; property name = "hibernate.default_schema" & gt ; sigi & lt ;/ property & gt ;
& lt ;! -- Configuração de teste -- & gt ;
& lt ; property name = "transaction.factory_class" & gt ; org . hibernate . transaction . JDBCTransactionFactory & lt ;/ property & gt ;
& lt ; property name = "current_session_context_class" & gt ; thread & lt ;/ property & gt ;
& lt ;! --
Configuração para mostrar as instruções SQL gerado e formatado
-- & gt ;
& lt ; property name = "hibernate.show_sql" & gt ; true & lt ;/ property & gt ;
& lt ; property name = "hibernate.format_sql" & gt ; true & lt ;/ property & gt ;
& lt ; property name = "hibernate.hbm2ddl.auto" & gt ; update & lt ;/ property & gt ;
& lt ;! -- Configuração para o pool de conecções -- & gt ;
& lt ; property name = "hibernate.connection.provider_class" & gt ; org . hibernate . connection . C3P0ConnectionProvider & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.acquire_increment" & gt ; 10 & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.min_size" & gt ; 0 & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.max_size" & gt ; 10 & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.timeout" & gt ; 100 & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.max_statements" & gt ; 10 & lt ;/ property & gt ;
& lt ; property name = "hibernate.c3p0.idle_test_period" & gt ; 10 & lt ;/ property & gt ;
& lt ; mapping class = "br.com.catequese.to.Acesso" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.AcompanhamentoPd" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.AmostraDimat" /& gt ;
& lt ; mapping class = "br.com.catequese.to.AmostraDimee" /& gt ;
& lt ; mapping class = "br.com.catequese.to.AmostraDitalq" /& gt ;
& lt ; mapping class = "br.com.catequese.to.AmostraNit" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.ApresentacaoMarca" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Bancos" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Caixa" /& gt ;
& lt ; mapping class = "br.com.catequese.to.CaixaEntradaDivisao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.CaixaEntradaSaida" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Carteira" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Cidade" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ClienteFisica" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ClienteJuridica" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.Clientes" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ContasPagar" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ContasReceber" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Contrato" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Cores" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.DadosMarca" /& gt ;
& lt ; mapping class = "br.com.catequese.to.DemandaLaboratorio" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Divisoes" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.EntradaMaterial" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Equipamentos" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Especialidade" /& gt ;
& lt ; mapping class = "br.com.catequese.to.EstadoCivil" /& gt ;
& lt ; mapping class = "br.com.catequese.to.EstadoUf" /& gt ;
& lt ; mapping class = "br.com.catequese.to.FormaContato" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.FormaPagamento" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Funcionario" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Imagem" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ItensNotaFiscal" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ItensPedidoDespesa" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Laboratorio" /& gt ;
& lt ;& lt ; mapping class = "br.com.catequese.to.Laudo" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.LocalColetaAmostra" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Medidas" /& gt ;
& lt ; mapping class = "br.com.catequese.to.NaturezaMarca" /& gt ;
& lt ; mapping class = "br.com.catequese.to.NotaFiscal" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Observacao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.OrigemSolicitacao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Pagamento" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Parcela" /& gt ;
& lt ; mapping class = "br.com.catequese.to.PedidoDespesa" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Pessoa" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.Processos" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Procuracao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.RamoAtividade" /& gt ;
& lt ; mapping class = "br.com.catequese.to.RequesitosServicosDimat" /& gt ;
& lt ; mapping class = "br.com.catequese.to.RequesitosServicosDimee" /& gt ;
& lt ; mapping class = "br.com.catequese.to.RequesitosServicosDitalq" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.Sabor" /& gt ; -- & gt ;
& lt ; mapping class = "br.com.catequese.to.ServicosDimat" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ServicosDimee" /& gt ;
& lt ; mapping class = "br.com.catequese.to.ServicosDitalq" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Solicitacao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.StatusSolicitacao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.TipoAmostra" /& gt ;
& lt ; mapping class = "br.com.catequese.to.TipoCliente" /& gt ;
& lt ; mapping class = "br.com.catequese.to.TipoServico" /& gt ;
& lt ;! -- & lt ; mapping class = "br.com.catequese.to.UnidadeProducao" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Usuario" /& gt ;
& lt ; mapping class = "br.com.catequese.to.Usuarios" /& gt ; -- & gt ;
& lt ;/ session-factory & gt ;
& lt ;/ hibernate-configuration & gt ;
Lucas_Cavalcanti 14 de jan. de 2011
tenta copiar a query que ele gerou e rodar diretamente no banco, e veja se dá o mesmo erro
