Exeption ao fazer conexão usando hibernate

13 de julho de 2012 4 respostas

thayson.silva 13 de julho de 2012

Ao tentar fazer uma conexão utilizando "hibernate-release-4.1.4.Final"
tive a seguinte exeption:

java.lang.unsupportedoperationexception the user must supply jdbc connections

Meu hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>

<!-- Definição padrão para configuração do hibernate -->
<!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.driver_class"> com.mysql.jdbc.Driver </property>
		<property name="hibernate.conenction.url"> jdbc:mysql://localhost:3306/db_loja </property>
		<property name="hibernate.connection.username"> root </property>
		<property name="hibernate.connection.password"> Thyson </property>
		<property name="hibernate.dialect"> org.hibernate.dialect.MySQLDialect </property>
		  
		
		<!-- serve para visualizar o codigo sql -->
		<property name="show_sql">true</property>
		
		<!-- Abaixo esta setada o mapeamento da classe Categoria -->
		<mapping resource="categoria.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

O mapeamento da minha classe:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="br.com.belecosmetico.model.Categoria" table="tbl_categoria">
		<id name="id_categoria" type="int" column="id_categoria"/>
		<property name="nome"/>
	</class>
</hibernate-mapping>

Esta a classe onde testo a conexão:

public class CategoriaDao {
	public static void main(String [] args){
		try {
			SessionFactory sf = new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();
			Session sessao = sf.openSession();
			
			Categoria c = new Categoria();
			c.setId_categoria(1);
			c.setNome("Livros");
			
			Transaction tx = sessao.beginTransaction();
			sessao.save(c);
			
			tx.commit();
			sessao.close();
			
		
		} catch (Exception e) {
			JOptionPane.showMessageDialog(null, "Erro ao conectar ao banco. erro : "+e);
		}
	}
}

Desde ja agradeço a todos.

4 Respostas

lele_vader 13 de jul. de 2012

Tente trocar o dialect para esse aqui

thayson.silva 13 de jul. de 2012

lele_vader,

Continua com o mesmo erro…

thayson.silva 16 de jul. de 2012

Para ver se fica mais fácil para poderem me ajudar, o eclipse gera o log abaixo,

25 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.2.GA
29 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
36 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
45 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
176 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml
177 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml
353 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : categoria.hbm.xml
446 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: br.com.belecosmetico.model.Categoria -> tbl_categoria
484 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
583 [main] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
624 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
631 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
635 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
636 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
636 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
644 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled
644 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
644 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
647 [main] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
647 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
647 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
648 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
648 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
648 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
652 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
653 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
653 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
653 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
653 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
653 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
654 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
654 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
663 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
664 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
664 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
665 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
665 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
758 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
1067 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured

Caso alguém possa me dar um help ficarei grato…

Mickdark 17 de jul. de 2012

Thayson!! Vc pode tentar tirar essa string do configure: “hibernate.cfg.xml”

new Configuration().configure().buildSessionFactory()

ou pode tentar salvar dentro da transação que vc abriu!!

//Ao inves disso
Transaction tx = sessao.beginTransaction();  
sessao.save(c);  

//Faca isso
Transaction tx = sessao.beginTransaction();  
tx.save(c);

Caso não de certo pode tentar no debug, ou colocar alguns sysouts após cada etapa da construção da configuração no main!

Criado 13 de julho de 2012

Ultima resposta 17 de jul. de 2012

Respostas 4

Participantes 3

4 Respostas

Topicos relacionados