Gerar banco com o hibernate+eclipse

4 de novembro de 2009 10 respostas

Guguuu 4 de novembro de 2009

Estou tentando criar o banco pelo eclipse...ja criei a classe responsavel por gerar... e ta dando a seguinte msg qndo eu rodo ela

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version).
log4j:WARN Please initialize the log4j system properly.
Msg do syso..: executada toda a classe

vai abaixo o xml e depois a classe

<?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.connection.url">jdbc:mysql://127.0.0.1/agenda</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">root</property>
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.format_sql">true</property>

		<mapping class="br.com.projeto.modelo.Agenda"></mapping>
		<mapping class="br.com.projeto.modelo.Cidade"></mapping>
		<mapping class="br.com.projeto.modelo.Cliente"></mapping>
		<mapping class="br.com.projeto.modelo.Endereco"></mapping>
		<mapping class="br.com.projeto.modelo.Estado"></mapping>
		<mapping class="br.com.projeto.modelo.Funcionario"></mapping>
		<mapping class="br.com.projeto.modelo.Servico"></mapping>

	</session-factory>


</hibernate-configuration>

-----------------------------
Class
-------------------------------

package br.com.projeto.util;

import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.tool.hbm2ddl.SchemaExport;


public class GeraBancoUtil {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		AnnotationConfiguration configuration = new AnnotationConfiguration();
		configuration.configure();
		SchemaExport se = new SchemaExport(configuration);
		se.create(true, true);
		
		
		System.out.println("Msg do syso..: executada toda a classe");
	}

}

Obrigado pela ajuda!

10 Respostas

JAVADRIANO 4 de nov. de 2009

Cara comigo também aconteceu este problema…
Tu tem que baixar e adicionar o jar log4j no teu projeto

Espero ter ajudado…

zoren 4 de nov. de 2009

JAVADRIANO:
Cara comigo também aconteceu este problema…
Tu tem que baixar e adicionar o jar log4j no teu projeto

Espero ter ajudado…

apenas isso não resolve, tem que colocar o log4j.properties na raiz do projeto (fora dos pacotes)

Gerson_da_S_Lima 4 de nov. de 2009

Cara eu faço desse jeito e funciona sem configurar o log4j.

AnnotationConfiguration cfg = new AnnotationConfiguration();
cfg.configure("hibernate.cfg.xml");
cfg.createMappings();
SchemaExport schema = new SchemaExport(cfg);
schema.create(true, true);
schema.execute(true, true, true, true);

Guguuu 4 de nov. de 2009

agora ta dando esse erro…

2009-11-04 12:23:38,099 [main] INFO  org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.4.0.GA
   2009-11-04 12:23:38,114 [main] INFO  org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1
   2009-11-04 12:23:38,114 [main] INFO  org.hibernate.cfg.Environment - hibernate.properties not found
   2009-11-04 12:23:38,130 [main] INFO  org.hibernate.cfg.Environment - Bytecode provider name : javassist
   2009-11-04 12:23:38,130 [main] INFO  org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
   2009-11-04 12:23:38,224 [main] INFO  org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.1.0.GA
   2009-11-04 12:23:38,224 [main] INFO  org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml
   2009-11-04 12:23:38,224 [main] INFO  org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml
   2009-11-04 12:23:38,520 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
   2009-11-04 12:23:38,520 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
   2009-11-04 12:23:38,520 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.url=jdbc:mysql://localhost/xxx
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.driver_class=com.mysql.jdbc.Driver
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.username=root
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.password=root
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.show_sql=true
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.format_sql=true
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.c3po.min_size=5
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.c3po.max_size=20
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.c3po.timeout=180
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.c3po.idle_test_period=100
   2009-11-04 12:23:38,567 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@f0eed6 [Attribute: name class value "br.com.projeto.modelo.Agenda"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1174b07 [Attribute: name class value "br.com.projeto.modelo.Cidade"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ac1fe4 [Attribute: name class value "br.com.projeto.modelo.Cliente"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ef8cf3 [Attribute: name class value "br.com.projeto.modelo.Endereco"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@15a3d6b [Attribute: name class value "br.com.projeto.modelo.Estado"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ef9f1d [Attribute: name class value "br.com.projeto.modelo.Funcionario"]
   2009-11-04 12:23:38,582 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@2c84d9 [Attribute: name class value "br.com.projeto.modelo.Servico"]
   2009-11-04 12:23:38,598 [main] INFO  org.hibernate.cfg.Configuration - Configured SessionFactory: foo
   2009-11-04 12:23:38,598 [main] DEBUG org.hibernate.cfg.Configuration - properties: {hibernate.connection.password=root, java.runtime.name=Java(TM) SE Runtime Environment, hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=14.2-b01, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=BR, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\Java\workspace\AgendaDeServicos, java.runtime.version=1.6.0_16-b01, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.c3po.timeout=180, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Users\Guguuu\AppData\Local\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 7, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre6\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;C:\Program Files\Common Files\ArcSoft\Bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\Users\Guguuu, user.timezone=America/Sao_Paulo, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, hibernate.format_sql=true, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=Guguuu, java.class.path=D:\Java\workspace\AgendaDeServicos\build\classes;D:\Java\apache-tomcat-6.0.20\lib\annotations-api.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-ant.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-ha.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-tribes.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina.jar;D:\Java\apache-tomcat-6.0.20\lib\el-api.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper-el.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper-jdt.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper.jar;D:\Java\apache-tomcat-6.0.20\lib\jsp-api.jar;D:\Java\apache-tomcat-6.0.20\lib\org.eclipse.jst.server.tomcat.runtime.60.loader.jar;D:\Java\apache-tomcat-6.0.20\lib\servlet-api.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-coyote.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-dbcp.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-es.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-fr.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-ja.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-antlr-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-launcher-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\antlr-2.7.6.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-swing-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\asm.jar;D:\Java\workspace\AgendaDeServicos\arq\asm-attrs.jar;D:\Java\workspace\AgendaDeServicos\arq\c3p0-0.9.1.jar;D:\Java\workspace\AgendaDeServicos\arq\cglib-2.1.3.jar;D:\Java\workspace\AgendaDeServicos\arq\checkstyle-all.jar;D:\Java\workspace\AgendaDeServicos\arq\cleanimports.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-beanutils-1.7.0.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-collections-2.1.1.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-collections-3.2.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-digester-1.8.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-logging-1.0.4.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-logging-1.1.jar;D:\Java\workspace\AgendaDeServicos\arq\concurrent-1.3.2.jar;D:\Java\workspace\AgendaDeServicos\arq\connector.jar;D:\Java\workspace\AgendaDeServicos\arq\dom4j-1.6.1.jar;D:\Java\workspace\AgendaDeServicos\arq\ehcache-1.2.3.jar;D:\Java\workspace\AgendaDeServicos\arq\ejb3-persistence.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate3.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate-annotations.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate-commons-annotations.jar;D:\Java\workspace\AgendaDeServicos\arq\jaas.jar;D:\Java\workspace\AgendaDeServicos\arq\jacc-1_0-fr.jar;D:\Java\workspace\AgendaDeServicos\arq\javassist.jar;D:\Java\workspace\AgendaDeServicos\arq\jaxen-1.1-beta-7.jar;D:\Java\workspace\AgendaDeServicos\arq\jsf-api-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jsf-impl-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jstl-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jta.jar;D:\Java\workspace\AgendaDeServicos\arq\log4j-1.2.11.jar;D:\Java\workspace\AgendaDeServicos\arq\mysql-connector-java-5.0.7-bin.jar;D:\Java\workspace\AgendaDeServicos\arq\oscache-2.1.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-api-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-impl-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-ui-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\servlet-api.jar;D:\Java\workspace\AgendaDeServicos\arq\versioncheck.jar;D:\Java\workspace\AgendaDeServicos\arq\xerces-2.6.2.jar;D:\Java\workspace\AgendaDeServicos\arq\xml-apis.jar, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, hibernate.c3po.min_size=5, java.home=C:\Program Files\Java\jre6, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect, hibernate.connection.url=jdbc:mysql://localhost/xxx, user.language=pt, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_16, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes, java.vendor=Sun Microsystems Inc., hibernate.c3po.max_size=20, file.separator=\, hibernate.session_factory_name=foo, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.c3po.idle_test_period=100, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
   2009-11-04 12:23:38,629 [main] INFO  org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
   2009-11-04 12:23:38,677 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Execute first pass mapping processing
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process hbm files
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process annotated classes
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
   2009-11-04 12:23:38,833 [main] INFO  org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Execute first pass mapping processing
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process hbm files
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process annotated classes
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
   2009-11-04 12:23:38,833 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
   2009-11-04 12:23:38,849 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export
   2009-11-04 12:23:38,849 [main] DEBUG org.hibernate.tool.hbm2ddl.SchemaExport - import file not found: /import.sql
   2009-11-04 12:23:38,849 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database
   2009-11-04 12:23:38,849 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
   2009-11-04 12:23:38,849 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
   2009-11-04 12:23:38,849 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
   2009-11-04 12:23:38,864 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/xxx
   2009-11-04 12:23:38,864 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=root}
   2009-11-04 12:23:38,864 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
   2009-11-04 12:23:38,895 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - schema export unsuccessful
   java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/xxx
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:52)
	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
	at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
	at br.com.projeto.util.GeraBancoUtil.main(GeraBancoUtil.java:26)
2009-11-04 12:23:38,895 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export
   2009-11-04 12:23:38,895 [main] DEBUG org.hibernate.tool.hbm2ddl.SchemaExport - import file not found: /import.sql
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/xxx
   2009-11-04 12:23:38,895 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=root}
   2009-11-04 12:23:38,895 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
   2009-11-04 12:23:38,895 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - schema export unsuccessful
   java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/xxx
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:52)
	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
	at br.com.projeto.util.GeraBancoUtil.main(GeraBancoUtil.java:27)
executado

Gerson_da_S_Lima 4 de nov. de 2009

Cara bem no finalzinho ele mostra esse erro:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/xxx

A configuração do banco tá certa?

E como tá a configuração dos jars?

Tá usando annotations, certo?

Guguuu 6 de nov. de 2009

bom…o erro eu consegui resolver.
mais nao ta gerando o banco.
Olhem o q ta dando no console agora

os importes nas classes do @entity tem q ser do hibernate ou do javax ou tanto faz?

2009-11-06 10:30:02,549 [main] INFO  org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.4.0.GA
   2009-11-06 10:30:02,565 [main] INFO  org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1
   2009-11-06 10:30:02,565 [main] INFO  org.hibernate.cfg.Environment - hibernate.properties not found
   2009-11-06 10:30:02,565 [main] INFO  org.hibernate.cfg.Environment - Bytecode provider name : javassist
   2009-11-06 10:30:02,580 [main] INFO  org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
   2009-11-06 10:30:02,643 [main] INFO  org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.1.0.GA
   2009-11-06 10:30:02,643 [main] INFO  org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
   2009-11-06 10:30:02,643 [main] INFO  org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
   2009-11-06 10:30:02,923 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
   2009-11-06 10:30:02,923 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
   2009-11-06 10:30:02,923 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.url=jdbc:mysql://127.0.0.1/xxx
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.driver_class=com.mysql.jdbc.Driver
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.username=root
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.connection.password=root
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.show_sql=true
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.format_sql=true
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.Configuration - hibernate.hbm2ddl.auto=create-drop
   2009-11-06 10:30:02,986 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@f0eed6 [Attribute: name class value "br.com.projeto.modelo.Agenda"]
   2009-11-06 10:30:03,001 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1174b07 [Attribute: name class value "br.com.projeto.modelo.Cidade"]
   2009-11-06 10:30:03,001 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ac1fe4 [Attribute: name class value "br.com.projeto.modelo.Cliente"]
   2009-11-06 10:30:03,001 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ef8cf3 [Attribute: name class value "br.com.projeto.modelo.Endereco"]
   2009-11-06 10:30:03,001 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@15a3d6b [Attribute: name class value "br.com.projeto.modelo.Estado"]
   2009-11-06 10:30:03,001 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@1ef9f1d [Attribute: name class value "br.com.projeto.modelo.Funcionario"]
   2009-11-06 10:30:03,017 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - foo <- org.dom4j.tree.DefaultAttribute@2c84d9 [Attribute: name class value "br.com.projeto.modelo.Servico"]
   2009-11-06 10:30:03,017 [main] INFO  org.hibernate.cfg.Configuration - Configured SessionFactory: foo
   2009-11-06 10:30:03,017 [main] DEBUG org.hibernate.cfg.Configuration - properties: {hibernate.connection.password=root, java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=14.2-b01, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=BR, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\Java\workspace\AgendaDeServicos, java.runtime.version=1.6.0_16-b01, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Users\Guguuu\AppData\Local\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 7, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre6\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;C:\Program Files\Common Files\ArcSoft\Bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\Users\Guguuu, user.timezone=America/Sao_Paulo, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, hibernate.format_sql=true, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=Guguuu, java.class.path=D:\Java\workspace\AgendaDeServicos\build\classes;D:\Java\apache-tomcat-6.0.20\lib\annotations-api.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-ant.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-ha.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina-tribes.jar;D:\Java\apache-tomcat-6.0.20\lib\catalina.jar;D:\Java\apache-tomcat-6.0.20\lib\el-api.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper-el.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper-jdt.jar;D:\Java\apache-tomcat-6.0.20\lib\jasper.jar;D:\Java\apache-tomcat-6.0.20\lib\jsp-api.jar;D:\Java\apache-tomcat-6.0.20\lib\org.eclipse.jst.server.tomcat.runtime.60.loader.jar;D:\Java\apache-tomcat-6.0.20\lib\servlet-api.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-coyote.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-dbcp.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-es.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-fr.jar;D:\Java\apache-tomcat-6.0.20\lib\tomcat-i18n-ja.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-antlr-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-launcher-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\antlr-2.7.6.jar;D:\Java\workspace\AgendaDeServicos\arq\ant-swing-1.6.5.jar;D:\Java\workspace\AgendaDeServicos\arq\asm.jar;D:\Java\workspace\AgendaDeServicos\arq\asm-attrs.jar;D:\Java\workspace\AgendaDeServicos\arq\c3p0-0.9.1.jar;D:\Java\workspace\AgendaDeServicos\arq\cglib-2.1.3.jar;D:\Java\workspace\AgendaDeServicos\arq\checkstyle-all.jar;D:\Java\workspace\AgendaDeServicos\arq\cleanimports.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-beanutils-1.7.0.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-collections-2.1.1.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-collections-3.2.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-digester-1.8.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-logging-1.0.4.jar;D:\Java\workspace\AgendaDeServicos\arq\commons-logging-1.1.jar;D:\Java\workspace\AgendaDeServicos\arq\concurrent-1.3.2.jar;D:\Java\workspace\AgendaDeServicos\arq\connector.jar;D:\Java\workspace\AgendaDeServicos\arq\dom4j-1.6.1.jar;D:\Java\workspace\AgendaDeServicos\arq\ehcache-1.2.3.jar;D:\Java\workspace\AgendaDeServicos\arq\ejb3-persistence.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate3.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate-annotations.jar;D:\Java\workspace\AgendaDeServicos\arq\hibernate-commons-annotations.jar;D:\Java\workspace\AgendaDeServicos\arq\jaas.jar;D:\Java\workspace\AgendaDeServicos\arq\jacc-1_0-fr.jar;D:\Java\workspace\AgendaDeServicos\arq\javassist.jar;D:\Java\workspace\AgendaDeServicos\arq\jaxen-1.1-beta-7.jar;D:\Java\workspace\AgendaDeServicos\arq\jsf-api-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jsf-impl-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jstl-1.2.jar;D:\Java\workspace\AgendaDeServicos\arq\jta.jar;D:\Java\workspace\AgendaDeServicos\arq\log4j-1.2.11.jar;D:\Java\workspace\AgendaDeServicos\arq\oscache-2.1.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-api-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-impl-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\richfaces-ui-3.1.0-rc3.jar;D:\Java\workspace\AgendaDeServicos\arq\servlet-api.jar;D:\Java\workspace\AgendaDeServicos\arq\versioncheck.jar;D:\Java\workspace\AgendaDeServicos\arq\xerces-2.6.2.jar;D:\Java\workspace\AgendaDeServicos\arq\xml-apis.jar;C:\Program Files\Java\jre6\lib\ext\mysql-connector-java-5.0.7-bin.jar, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre6, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect, hibernate.connection.url=jdbc:mysql://127.0.0.1/xxx, user.language=pt, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_16, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.session_factory_name=foo, hibernate.hbm2ddl.auto=create-drop, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
   2009-11-06 10:30:03,033 [main] INFO  org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
   2009-11-06 10:30:03,095 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Execute first pass mapping processing
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process hbm files
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process annotated classes
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
   2009-11-06 10:30:03,158 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
   2009-11-06 10:30:03,168 [main] INFO  org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Execute first pass mapping processing
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process hbm files
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - Process annotated classes
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
   2009-11-06 10:30:03,168 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export
   2009-11-06 10:30:03,168 [main] DEBUG org.hibernate.tool.hbm2ddl.SchemaExport - import file not found: /import.sql
   2009-11-06 10:30:03,168 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database
   2009-11-06 10:30:03,168 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
   2009-11-06 10:30:03,178 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
   2009-11-06 10:30:03,178 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
   2009-11-06 10:30:03,199 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://127.0.0.1/xxx
   2009-11-06 10:30:03,199 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=root}
   2009-11-06 10:30:03,199 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
   2009-11-06 10:30:03,479 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:mysql://127.0.0.1/xxx, Isolation Level: 4
   2009-11-06 10:30:03,479 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - schema export complete
   2009-11-06 10:30:03,479 [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://127.0.0.1/xxx
   executado

Gerson_da_S_Lima 9 de nov. de 2009

Cara eu sempre fiz com javax, mas acho que não tem problema em usar os do hibernate.

Seguinte, no teu xml falta uma propriedade

create

Essa propriedade diz pra criar as estruturas no banco, só deve ser usada na hora de criar, depois que estiver criada você pode comentá-la ou colocar como none.

Eu vi também que no código faltou você colocar no final o seguinte trecho

se.execute(true, true, true, true);

comigo só funcionou desse jeito.

Guguuu 11 de nov. de 2009

ja fiz todas essas alterações que o Gerson da S. Lima solicitou e ate agora nada…

continua executando normal…mais nao cria as tabelas do banco de dados!!!

help please!

Gerson_da_S_Lima 12 de nov. de 2009

Cara, tô te enviando parte do meu código pra ver se tu consegue alguma coisa.
É desse jeito que tá meu código e funciona, cria todas as estruturas sem problema algum.

hibernate.hbm.xml

<?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>
		<!-- Propriedades -->
		<property name="connection.driver_class">org.postgresql.Driver</property>
		<property name="connection.url">jdbc:postgresql://localhost:5432/sistema</property>
		<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
		<property name="show_sql">true</property>
		<property name="connection.username">postgres</property>
		<property name="connection.password">postgres</property>
		<property name="hbm2ddl.auto">create</property>
		
		<!-- Mapeamento de Classes -->
		<mapping class="br.com.gersonlima.autotrade.model.Produto" />
		<mapping class="br.com.gersonlima.autotrade.model.Categoria" />
	</session-factory>
</hibernate-configuration>

classes java

//package
//imports

@Entity @Table(name="produto", schema="cadastro")
public class Produto implements IModel {
	
	@Id @Column(name="pro_id")
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Integer id;
	
	@Column(name="pro_codigo_de_barras", unique=true)
	private String codigoDeBarras;
	
	@Column(name="pro_referencia", unique=true)
	private String referencia;
	
	@Column(name="pro_descricao")
	private String descricao;
	
	@Column(name="pro_preco_venda")
	private Double precoVenda;
	
	@Column(name="pro_quantidade")
	private int quantidade;
	
	@Column(name="pro_quantidade_minima")
	private int quantidadeMin;
	
	@Column(name="pro_observacoes", length=500)
	private String observacoes;
	
	@ManyToOne(fetch=FetchType.LAZY)
	@JoinColumn(name="cat_id", insertable=true, updatable=true)
	@Fetch(FetchMode.SELECT)
	private Categoria categoria;
	
	@OneToMany(mappedBy="produto", fetch=FetchType.LAZY)
	private List<ItemCompra> itensCompra;
	
	@OneToMany(mappedBy="produto", fetch=FetchType.LAZY)
	private List<ItemVenda> itensVenda;

	//Contrutor

	//getters ans setters

	//Outros métodos
}

//package
//imports

@Entity @Table(name="categoria", schema="cadastro")
public class Categoria implements IModel {

	@Id @Column(name="cat_id")
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	@OrderBy(value="cat_id")
	private Integer id;
	
	@Column(name="cat_descricao", unique=true)
	private String descricao;
	
	@OneToMany(mappedBy="categoria", fetch=FetchType.LAZY)
	@Cascade(CascadeType.EVICT)
	private List<Produto> produtos;

	//contrutor

	//getters and setters

	//Outros métodos
}

Classe com método main.

//imports
public class GerarBancoMain {

	public static void main(String[] args) throws Exception {		
		AnnotationConfiguration cfg = new AnnotationConfiguration();
		cfg.configure("hibernate.cfg.xml");
		cfg.createMappings();
		SchemaExport schema = new SchemaExport(cfg);
		schema.create(true, true);
		schema.execute(true, true, true, true);
	}
}

Guguuu 12 de nov. de 2009

Ufa… obrigadao,…

acho q os import’s tem q ser do javax mesmo…
eu alterei todas as minhas classes e deu certo.

Obrigado por todas as resposta pois tinha alguns erro q fui corrigindo mais o final
era alterar os importes mesmo. obrigado mesmo.

Criado 4 de novembro de 2009

Ultima resposta 12 de nov. de 2009

Respostas 10

Participantes 4

10 Respostas

Topicos relacionados