Gente, onde tem de ficar o arquivo hibernate.properties ?
Hibernate
2 Respostas
ok… consegui a primeira parte, mas agora estou com dificuldades para montar corretamente meu arquivo hibernate.properties para acessar o postgress. Eu já baixei o driver e já o coloquei no classpath da minha app.
Mas a duvida eh… como eu devo informar as propriedade para acessar o postgree com hibernate.
Segue meu arquivo hibernate.properties
hibernate.dialect org.hibernate.dialect.PostgreSQLDialect
hibernate.connetion.driver_class org.postgresql.Driver
hibernate.connection.username postgres
hibernate.connection.password postgres
hibernate.connection.url jdbc:postgresql://localhost:5432/sistema
Quando eu tento executar minha classe ExportSchema(ela que cria as tabelas no bd) eu recebo uma mensagem de erro de que não conseguiu encontrar o driver.
[color=red]26/07/2006 23:23:42 org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.2.0.CR1
26/07/2006 23:23:42 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.1.3
26/07/2006 23:23:42 org.hibernate.cfg.Environment <clinit>
INFO: loaded properties from resource hibernate.properties: {hibernate.connection.username=postgres, hibernate.connection.password=<strong><strong>, hibernate.connetion.driver_class=org.postgresql.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect, hibernate.connection.url=jdbc:postgresql://localhost:5432/sistema}
26/07/2006 23:23:42 org.hibernate.cfg.Environment <clinit>
INFO: using CGLIB reflection optimizer
26/07/2006 23:23:42 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
26/07/2006 23:23:43 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
26/07/2006 23:23:43 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
26/07/2006 23:23:43 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
WARNING: no JDBC Driver class was specified by property hibernate.connection.driver_class
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: null at URL: jdbc:postgresql://localhost:5432/sistema
26/07/2006 23:23:43 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=postgres, password=</strong></strong>}
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at br.com.caelum.util.HibernateUtil.<clinit>(HibernateUtil.java:17)
at br.com.caelum.util.ExportSchema.main(ExportSchema.java:16)
26/07/2006 23:23:43 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.PostgreSQLDialect
26/07/2006 23:23:43 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
26/07/2006 23:23:43 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
26/07/2006 23:23:43 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
26/07/2006 23:23:43 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.EhCacheProvider
Exception in thread “main” java.lang.NoClassDefFoundError: net/sf/ehcache/CacheException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:327)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:219)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at br.com.caelum.util.HibernateUtil.<clinit>(HibernateUtil.java:17)
at br.com.caelum.util.ExportSchema.main(ExportSchema.java:16)[/color]
Como deve ficar meu arquivo hibernate.properties?
o nome do driver esta certo?
a porta que o postgre usa esta certa?
tem algum campo faltando?
pq há tão pouco material sobre postgre e java na net?
abraços
I
Ve se isso te ajuda.
Criado 26 de julho de 2006
Ultima resposta 26 de jul. de 2006
Respostas 2
Participantes 2
Alura O que é Python? — um guia completo para iniciar nessa linguagem de programação Acesse agora o guia sobre Python e inicie sua jornada nessa linguagem de programação: o que é e para que serve, sua sintaxe e como iniciar nela!
Casa do Codigo Engenharia de Prompt para Devs: Um guia para aprender a... Por Ricardo Pupo Larguesa — Casa do Codigo