Discussoes de Programacao e Tecnologia

Banco de dados Oracle

3 respostas
javaoracle
J
Josewalter408

Boa tarde! Pessoal eu estou com esse erro no console e não estou conseguindo me conectar ao banco alguém já teve este erro tb estou entrando com a minha de acesso e não consigo me conectar ao banco e ontem eu estava com tudo certinho estava conectando não havia nenhum erro

java.lang.ExceptionInInitializerError

at br.com.teste.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:24)

at br.com.teste.util.HibernateUtil.(HibernateUtil.java:14)

at br.com.teste.dao.AlunoDao.Salvar(AlunoDao.java:13)

at br.com.teste.testar.AlunoDaoTeste.Salvar(AlunoDaoTeste.java:25)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)

at org.junit.runners.ParentRunner.run(ParentRunner.java:309)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)

Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:267)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:231)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)

at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)

at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:240)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)

at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)

at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)

at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)

at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)

at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:691)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)

at br.com.teste.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:19)

… 26 more

Caused by: org.hibernate.boot.registry.classloading.spi.ClassLoadingException: Unable to load class [oracle.jdbc.driver.OracleDriver]

at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:348)

at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.loadDriverIfPossible(DriverManagerConnectionProviderImpl.java:160)

at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildCreator(DriverManagerConnectionProviderImpl.java:116)

at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:100)

at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:72)

at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:240)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)

at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)

at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:257)

… 40 more

Caused by: java.lang.ClassNotFoundException: Could not load requested class : oracle.jdbc.driver.OracleDriver

at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl$AggregatedClassLoader.findClass(ClassLoaderServiceImpl.java:336)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:345)

… 52 more

estou usando o SQL Developer Outra dúvida alguém sabe qual a dependência do Oracle11g que que funciona perfeito no Maven que as dependências que eu fiz o teste todas deram erro.

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

3 Respostas

I
igor_ks

Nao carregou o driver corretamente. Posta seu código pra poder ajudar melhor

J
Josewalter408

Oi Igor boa tarde qual classe vc quer a classe hobernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?> 
<session-factory name="java:hibernate/SessionFactory">

	<!-- Configurações de conexão -->
	<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
	<property name="connection.url">jdbc:oracle:thin:@localhost:1521:cadastro alunos</property>
	<property name="connection.username">josewalter</property>
	<property name="connection.password">conhecimento</property>

	<!-- JDBC pool de conexão) -->
	<property name="connection.pool_size">1</property>

	<!-- Dialeto SQL -->
	<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

	<!-- Gerenciamento de sesão -->
	<property name="current_session_context_class">thread</property>

	<!-- Desabilita cache -->
	<property name="cache.provider_class">org.hibernate.dialect.Oracle11gDialect</property>

	<!-- Exibi os comandos SQL -->
	<property name="show_sql">true</property>

	<!-- Cria as tabelas -->
	<property name="hbm2ddl.auto">create</property>
	
	<property name="hibernate.default_shema">josewalter</property>
	
	<mapping class="br.com.teste.domain.Aluno"/>
	<mapping class="br.com.teste.domain.Curso"/>

</session-factory>

=======================================================
classe pom.xml


4.0.0

teste1
0.0.1-SNAPSHOT
war

<dependencies>
	
<!-- Depenências do Prime Faces -->
<dependency>
	<groupId>org.primefaces</groupId>
	<artifactId>primefaces</artifactId>
	<version>6.0</version>
	<scope>compile</scope>
</dependency>

<!-- Depenências do jUnit -->
<dependency>
	<groupId>junit</groupId>
	<artifactId>junit-dep</artifactId>
	<version>4.11</version>
</dependency>

<!-- Depenências do Hibernate -->
<dependency>
	<groupId>org.hibernate</groupId>
	<artifactId>hibernate-core</artifactId>
	<version>5.2.6.Final</version>
</dependency>
org.apache.maven.plugins maven-compiler-plugin 3.6.1 1.8 1.8 
</build>
S
Stiglitz88

Pelo que da pra perceber seu pom falta a dependência do driver do oracle.
Até aonde sei, não ha nenhum padrão no maven.
Você tem que baixar o jar e instalar no seu repositório local
ou adicionar manualmente as libs do projeto.

Criado 17 de fevereiro de 2017
Ultima resposta 17 de fev. de 2017
Respostas 3
Participantes 3

Topicos relacionados

Primeira Certificação Java 1 respostas Mapear relacionamento 'aninhado' 22 respostas Consultar jpql com o createQuery do EntityManager retornando erro Resolvido 9 respostas [RESOLVIDO]Chamar procedure oracle com java passando parametro nested table 1 respostas Erro Hibernate 4 Tipo de coluna inválido: getCLOB not implemented for class? 6 respostas
Alura O que são algoritmos e lógica de programação e como aprender? Entenda o que são algoritmos e lógica de programação e qual é a importância desses conceitos para começar a programar
Casa do Codigo Deixe seu codigo limpo e brilhante: Desmistificando Clean... Por Jose Yoshiriro — Casa do Codigo