romarcio 26 de mar. de 2011
Posta a sua configuração do hibernate.
fernandogodoy18 26 de mar. de 2011
To postando o Utility intero por que neim sei mais o que pode ser!
package br.com.sigcom.util ;
import br.com.sigcom.models.cadastros.Cidade ;
import br.com.sigcom.models.cadastros.Cliente ;
import br.com.sigcom.models.cadastros.Email ;
import br.com.sigcom.models.movimentos.Compra ;
import br.com.sigcom.models.movimentos.ContasPagar ;
import br.com.sigcom.models.movimentos.ContasReceber ;
import br.com.sigcom.models.movimentos.Devolucao ;
import br.com.sigcom.models.movimentos.DevolucaoPeca ;
import br.com.sigcom.models.movimentos.DevolucaoPecaPk ;
import br.com.sigcom.models.cadastros.Empresa ;
import br.com.sigcom.models.cadastros.Estado ;
import br.com.sigcom.models.movimentos.Expedicao ;
import br.com.sigcom.models.movimentos.ExpedicaoVenda ;
import br.com.sigcom.models.movimentos.ExpedicaoVendaPk ;
import br.com.sigcom.models.cadastros.Fornecedor ;
import br.com.sigcom.models.cadastros.Funcao ;
import br.com.sigcom.models.cadastros.Funcionario ;
import br.com.sigcom.models.cadastros.Maquina ;
import br.com.sigcom.models.cadastros.Marca ;
import br.com.sigcom.models.cadastros.MatPrima ;
import br.com.sigcom.models.movimentos.MatPrimaCompra ;
import br.com.sigcom.models.movimentos.MatPrimaProd ;
import br.com.sigcom.models.movimentos.MatPrimaCompraPk ;
import br.com.sigcom.models.movimentos.OrdemProd ;
import br.com.sigcom.models.cadastros.Peca ;
import br.com.sigcom.models.movimentos.PecaOrdemProd ;
import br.com.sigcom.models.movimentos.PecaVenda ;
import br.com.sigcom.models.movimentos.PecaVendaPk ;
import br.com.sigcom.models.cadastros.Pessoa ;
import br.com.sigcom.models.movimentos.PgContasPagar ;
import br.com.sigcom.models.movimentos.PgContasReceber ;
import br.com.sigcom.models.movimentos.Producao ;
import br.com.sigcom.models.cadastros.Setor ;
import br.com.sigcom.models.cadastros.Telefone ;
import br.com.sigcom.models.cadastros.Usuario ;
import br.com.sigcom.models.movimentos.Venda ;
import org.hibernate.Session ;
import org.hibernate.SessionFactory ;
import org.hibernate.Transaction ;
import org.hibernate.cfg.AnnotationConfiguration ;
public class HibernateUtility {
private static final SessionFactory factory ;
private static final ThreadLocal sessionThread = new ThreadLocal ();
private static final ThreadLocal transactionThread = new ThreadLocal ();
public static Session getSession () {
Session session = ( Session ) sessionThread . get ();
if (( session == null ) || ( ! ( session . isOpen ()))) {
session = factory . openSession ();
sessionThread . set ( session );
}
return (( Session ) sessionThread . get ());
}
public static void closeSession () {
Session session = ( Session ) sessionThread . get ();
if (( session != null ) && ( session . isOpen ())) {
sessionThread . set ( null );
session . close ();
}
}
public static void beginTransaction () {
Transaction transaction = getSession (). beginTransaction ();
transactionThread . set ( transaction );
}
public static void commitTransaction () {
Transaction transaction = ( Transaction ) transactionThread . get ();
if (( transaction != null ) && ( ! ( transaction . wasCommitted ())) && ( ! ( transaction . wasRolledBack ()))) {
transaction . commit ();
transactionThread . set ( null );
}
}
public static void rollbackTransaction () {
Transaction transaction = ( Transaction ) transactionThread . get ();
if (( transaction != null ) && ( ! ( transaction . wasCommitted ())) && ( ! ( transaction . wasRolledBack ()))) {
transaction . rollback ();
transactionThread . set ( null );
}
}
static {
try {
factory = new AnnotationConfiguration ()
/***POSTGRESQL***/
. setProperty ( "hibernate.dialect" , "org.hibernate.dialect.PostgreSQLDialect" )
. setProperty ( "hibernate.connection.driver_class" , "org.postgresql.Driver" )
. setProperty ( "hibernate.connection.url" , "jdbc:postgresql://localhost:5432/sigcom" )
. setProperty ( "hibernate.connection.username" , "postgres" )
. setProperty ( "hibernate.connection.password" , "postgres" )
/***MYSQL***/
// .setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLInnoDBDialect")
// .setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver")
// .setProperty("hibernate.connection.url", "jdbc:mysql://localhost:3306/sigcom")
// .setProperty("hibernate.connection.username", "root")
// .setProperty("hibernate.connection.password", "root")
. setProperty ( "hibernate.c3p0.max_size" , "10" )
. setProperty ( "hibernate.c3p0.min_size" , "2" )
. setProperty ( "hibernate.c3p0.timeout" , "5000" )
. setProperty ( "hibernate.c3p0.max_statements" , "10" )
. setProperty ( "hibernate.c3p0.idle_test_period" , "3000" )
. setProperty ( "hibernate.c3p0.acquire_increment" , "2" )
. setProperty ( "show_sql" , "true" )
. setProperty ( "use_outer_join" , "true" )
. setProperty ( "hibernate.generate_statistics" , "true" )
. setProperty ( "hibernate.use_sql_comments" , "true" )
. setProperty ( "hibernate.format_sql" , "true" )
//CADASTROS
. addAnnotatedClass ( Marca . class )
. addAnnotatedClass ( Setor . class )
. addAnnotatedClass ( Cidade . class )
. addAnnotatedClass ( Estado . class )
. addAnnotatedClass ( Funcao . class )
. addAnnotatedClass ( Pessoa . class )
. addAnnotatedClass ( MatPrima . class )
. addAnnotatedClass ( Telefone . class )
. addAnnotatedClass ( Empresa . class )
. addAnnotatedClass ( Fornecedor . class )
. addAnnotatedClass ( Cliente . class )
. addAnnotatedClass ( Funcionario . class )
. addAnnotatedClass ( Usuario . class )
. addAnnotatedClass ( Peca . class )
. addAnnotatedClass ( Maquina . class )
. addAnnotatedClass ( Email . class )
//MOVIMENTOS
. addAnnotatedClass ( OrdemProd . class )
. addAnnotatedClass ( Producao . class )
. addAnnotatedClass ( Venda . class )
. addAnnotatedClass ( Compra . class )
. addAnnotatedClass ( Expedicao . class )
. addAnnotatedClass ( Devolucao . class )
. addAnnotatedClass ( ContasPagar . class )
. addAnnotatedClass ( ContasReceber . class )
. addAnnotatedClass ( PgContasPagar . class )
. addAnnotatedClass ( PgContasReceber . class )
. addAnnotatedClass ( PecaVenda . class )
. addAnnotatedClass ( PecaVendaPk . class )
. addAnnotatedClass ( MatPrimaCompra . class )
. addAnnotatedClass ( PecaOrdemProd . class )
. addAnnotatedClass ( ExpedicaoVenda . class )
. addAnnotatedClass ( ExpedicaoVendaPk . class )
. addAnnotatedClass ( MatPrimaProd . class )
. addAnnotatedClass ( MatPrimaCompraPk . class )
. addAnnotatedClass ( DevolucaoPeca . class )
. addAnnotatedClass ( DevolucaoPecaPk . class )
. buildSessionFactory ();
} catch ( RuntimeException e ) {
e . printStackTrace ();
throw e ;
}
}
public static void main ( String [] args ) {
}
}
romarcio 26 de mar. de 2011
Faltou setar a configuração para gerar as tabelas:
Se nã oder certo, crie o banco de dados antes, para depois ele gerar as tabelas.
fernandogodoy18 26 de mar. de 2011
eu ja tinha feito isso,
Fiz de novo agora e deu certo com o postgres,
no mysql ele continuou não gerando!
mais isso eu vejo depois.
Com isso ja resolve meu problema, qualquer um dos bancos funcionando ja posso da sequência no meu TCC
obrigado!