Tabela muito grande Vraptor + Hibernate

0 respostas
juniorsatanas

Pessoal esta critéria :

public List<Solicitacao> listaTudo(){
        return this.session.createCriteria(Solicitacao.class)
               .addOrder(Order.asc("soliNegociacao"))
                .setMaxResults(1)
                .list();
    }

Ta retornando este erro :

INFO: 16:24:22,606  WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 54000

INFO: 16:24:22,607 ERROR JDBCExceptionReporter:101 - ERRO: listas de alvo podem ter no máximo 1664 entradas

INFO: Fecha session, a anotação é do vRaptor

o meu hibernate cfg . xml ta assi :

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
    <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
    <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/nutec</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">debian23</property>
    <property name="hibernate.default_schema">sigi1</property>
   
   
   
 <!-- Configuração de teste  -->
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="current_session_context_class">thread</property>

<!--
 Configuração para mostrar as instruções SQL gerado e formatado
-->
<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Configuração para o pool de conecções  -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">300</property>
<property name="hibernate.c3p0.max_statements">50</property>
<property name="hibernate.c3p0.idle_test_period">1000</property>


    <!--<mapping class="br.com.catequese.to.Aluno"/>
    <mapping class="br.com.catequese.to.Turma"/>
    <mapping class="br.com.catequese.to.Professor"/>
    <mapping class="br.com.catequese.to.Trabalho"/>
    <mapping class="br.com.catequese.to.TrabalhoEntrega"/>
    <mapping class="br.com.catequese.to.Etapa"/>
    <mapping class="br.com.catequese.to.Disciplina"/>
    <mapping class="br.com.catequese.to.Decanato"/>
    <mapping class="br.com.catequese.to.GrauInstrucao"/>
    <mapping class="br.com.catequese.to.Paroquia"/>
    <mapping class="br.com.catequese.to.ChamadaItem"/>
    <mapping class="br.com.catequese.to.Chamada"/>
    <mapping class="br.com.catequese.to.EstadoCivil"/>-->
    <mapping class="br.com.catequese.to.Usuario"/>

<mapping class="br.com.catequese.to.Acesso"/>
<!--<mapping class="br.com.catequese.to.AcompanhamentoPd"/>-->
<mapping class="br.com.catequese.to.AmostraDimat"/>
<mapping class="br.com.catequese.to.AmostraDimee"/>
<mapping class="br.com.catequese.to.AmostraDitalq"/>
<mapping class="br.com.catequese.to.AmostraNit"/>
<!--<mapping class="br.com.catequese.to.ApresentacaoMarca"/>
<mapping class="br.com.catequese.to.Bancos"/>
<mapping class="br.com.catequese.to.Caixa"/>
<mapping class="br.com.catequese.to.CaixaEntradaDivisao"/>
<mapping class="br.com.catequese.to.CaixaEntradaSaida"/>
<mapping class="br.com.catequese.to.Carteira"/>-->
<mapping class="br.com.catequese.to.Cidade"/>
<mapping class="br.com.catequese.to.ClienteFisica"/>
<mapping class="br.com.catequese.to.ClienteJuridica"/>
<!--<mapping class="br.com.catequese.to.Clientes"/>
<mapping class="br.com.catequese.to.ContasPagar"/>
<mapping class="br.com.catequese.to.ContasReceber"/>-->
<mapping class="br.com.catequese.to.Contrato"/>
<mapping class="br.com.catequese.to.Cores"/>
<!--<mapping class="br.com.catequese.to.DadosMarca"/>
<mapping class="br.com.catequese.to.DemandaLaboratorio"/>-->
<mapping class="br.com.catequese.to.Divisoes"/>
<!--<mapping class="br.com.catequese.to.EntradaMaterial"/>-->
<mapping class="br.com.catequese.to.Equipamentos"/>
<mapping class="br.com.catequese.to.Especialidade"/>
<mapping class="br.com.catequese.to.EstadoCivil"/>
<mapping class="br.com.catequese.to.EstadoUf"/>
<mapping class="br.com.catequese.to.FormaContato"/>
<!--<mapping class="br.com.catequese.to.FormaPagamento"/>-->
<mapping class="br.com.catequese.to.Funcionario"/>
<!--<mapping class="br.com.catequese.to.Imagem"/>
<mapping class="br.com.catequese.to.ItensNotaFiscal"/>
<mapping class="br.com.catequese.to.ItensPedidoDespesa"/>-->
<mapping class="br.com.catequese.to.Laboratorio"/>
<!--<mapping class="br.com.catequese.to.Laudo"/>-->
<mapping class="br.com.catequese.to.LocalColetaAmostra"/>
<!--<mapping class="br.com.catequese.to.LogAcesso"/>
<mapping class="br.com.catequese.to.LogAcompanhamentoPd"/>
<mapping class="br.com.catequese.to.LogAmostraDimat"/>
<mapping class="br.com.catequese.to.LogAmostraDimee"/>
<mapping class="br.com.catequese.to.LogAmostraDitalq"/>
<mapping class="br.com.catequese.to.LogAmostraNit"/>
<mapping class="br.com.catequese.to.LogApresentacaoMarca"/>
<mapping class="br.com.catequese.to.LogBancos"/>
<mapping class="br.com.catequese.to.LogCaixa"/>
<mapping class="br.com.catequese.to.LogCaixaEntradaDivisao"/>
<mapping class="br.com.catequese.to.LogCaixaEntradaSaida"/>
<mapping class="br.com.catequese.to.LogCarteira"/>
<mapping class="br.com.catequese.to.LogCidade"/>
<mapping class="br.com.catequese.to.LogClienteFisica"/>
<mapping class="br.com.catequese.to.LogClienteJuridica"/>
<mapping class="br.com.catequese.to.LogClientes"/>
<mapping class="br.com.catequese.to.LogContasPagar"/>
<mapping class="br.com.catequese.to.LogContasReceber"/>
<mapping class="br.com.catequese.to.LogContrato"/>
<mapping class="br.com.catequese.to.LogCores"/>
<mapping class="br.com.catequese.to.LogDadosMarca"/>
<mapping class="br.com.catequese.to.LogDemandaLaboratorio"/>
<mapping class="br.com.catequese.to.LogDivisoes"/>
<mapping class="br.com.catequese.to.LogEntradaMaterial"/>
<mapping class="br.com.catequese.to.LogEquipamentos"/>
<mapping class="br.com.catequese.to.LogEspecialidade"/>
<mapping class="br.com.catequese.to.LogEstadoCivil"/>
<mapping class="br.com.catequese.to.LogEstadoUf"/>
<mapping class="br.com.catequese.to.LogFormaContato"/>
<mapping class="br.com.catequese.to.LogFormaPagamento"/>
<mapping class="br.com.catequese.to.LogFuncionario"/>
<mapping class="br.com.catequese.to.LogImagem"/>
<mapping class="br.com.catequese.to.LogItemsPedidoDespesa"/>
<mapping class="br.com.catequese.to.LogItensNotaFiscal"/>
<mapping class="br.com.catequese.to.LogLaboratorio"/>
<mapping class="br.com.catequese.to.LogLaudo"/>
<mapping class="br.com.catequese.to.LogLocalColetaAmostra"/>
<mapping class="br.com.catequese.to.LogMarca"/>
<mapping class="br.com.catequese.to.LogMedidas"/>
<mapping class="br.com.catequese.to.LogNaturezaMarca"/>
<mapping class="br.com.catequese.to.LogNotaFiscal"/>
<mapping class="br.com.catequese.to.LogObservacao"/>
<mapping class="br.com.catequese.to.LogOrigemSolicitacao"/>
<mapping class="br.com.catequese.to.LogPagamento"/>
<mapping class="br.com.catequese.to.LogParcela"/>
<mapping class="br.com.catequese.to.LogPedidoDespesa"/>
<mapping class="br.com.catequese.to.LogPessoa"/>
<mapping class="br.com.catequese.to.LogProcessos"/>
<mapping class="br.com.catequese.to.LogProcuracao"/>
<mapping class="br.com.catequese.to.LogRamoAtividade"/>
<mapping class="br.com.catequese.to.LogRequesitoServicosDimat"/>
<mapping class="br.com.catequese.to.LogRequesitoServicosDimee"/>
<mapping class="br.com.catequese.to.LogRequesitoServicosDitalq"/>
<mapping class="br.com.catequese.to.LogSabor"/>
<mapping class="br.com.catequese.to.LogServicosDimat"/>
<mapping class="br.com.catequese.to.LogServicosDimee"/>
<mapping class="br.com.catequese.to.LogServicosDitalq"/>
<mapping class="br.com.catequese.to.LogSolicitacao"/>
<mapping class="br.com.catequese.to.LogStatusSolicitacao"/>
<mapping class="br.com.catequese.to.LogTipoAmostra"/>
<mapping class="br.com.catequese.to.LogTipoCliente"/>
<mapping class="br.com.catequese.to.LogTipoServico"/>
<mapping class="br.com.catequese.to.LogUnidadeProducao"/>
<mapping class="br.com.catequese.to.LogUsuarios"/>-->
<mapping class="br.com.catequese.to.Medidas"/>
<mapping class="br.com.catequese.to.NaturezaMarca"/>
<!--<mapping class="br.com.catequese.to.NotaFiscal"/>
<mapping class="br.com.catequese.to.Observacao"/>
<mapping class="br.com.catequese.to.OrigemSolicitacao"/>
<mapping class="br.com.catequese.to.Pagamento"/>
<mapping class="br.com.catequese.to.Parcela"/>
<mapping class="br.com.catequese.to.PedidoDespesa"/>
<mapping class="br.com.catequese.to.Pessoa"/>-->
<mapping class="br.com.catequese.to.Processos"/>
<mapping class="br.com.catequese.to.Procuracao"/>
<mapping class="br.com.catequese.to.RamoAtividade"/>
<mapping class="br.com.catequese.to.RequesitosServicosDimat"/>
<mapping class="br.com.catequese.to.RequesitosServicosDimee"/>
<mapping class="br.com.catequese.to.RequesitosServicosDitalq"/>
<!--<mapping class="br.com.catequese.to.Sabor"/>-->
<mapping class="br.com.catequese.to.ServicosDimat"/>
<mapping class="br.com.catequese.to.ServicosDimee"/>
<mapping class="br.com.catequese.to.ServicosDitalq"/>
<mapping class="br.com.catequese.to.Solicitacao"/>
<mapping class="br.com.catequese.to.StatusSolicitacao"/>
<mapping class="br.com.catequese.to.TipoAmostra"/>
<mapping class="br.com.catequese.to.TipoCliente"/>
<mapping class="br.com.catequese.to.TipoServico"/>
<!--<mapping class="br.com.catequese.to.UnidadeProducao"/>
<mapping class="br.com.catequese.to.Usuario"/>
<mapping class="br.com.catequese.to.Usuarios"/>-->

  </session-factory>
</hibernate-configuration>
Criado 10 de janeiro de 2011
Respostas 0
Participantes 1