Erro em tentar hibernate + SQLServer

3 respostas
EuclidesFilizola

Boa tarde pessoal, eu baixei jtds-1.2.2-dist.zip, e então tentei configurar meu persistence.xml para acessar o banco de dados SQL Server, porém não está funcionando.

aqui está minha classe de teste:

/**
 * 
 */
package br.gov.ce.srh.siscontv.model;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

import br.gov.ce.srh.siscontv.model.entity.Pessoa;
import br.gov.ce.srh.siscontv.model.entity.Usuario;

/**
 * @author euclides filizola
 * 
 *  SRH - Secretaria de Recursos Hídricos
 * 
 */
public class JPAUtil {
	
	
	
	public static void main(String[] args) {
		
/*	

	EntityManagerFactory emf = Persistence
	.createEntityManagerFactory("bancoLocal");
EntityManager em = emf.createEntityManager();
em.getTransaction().begin();


People pl = em.find(People.class, 1);
pl.setName("Euclies Filizola ");



Address add = em.find(Address.class, 1);
add.setAddress("Endereço alterado");


Usuario usuario = em.find(Usuario.class, 1);

System.out.println("Nome do usuario: "+usuario.getNomeUsuario());

em.getTransaction().commit();
em.close();
emf.close();

*/

EntityManagerFactory emf2 = Persistence
.createEntityManagerFactory("BDSERV");
EntityManager em2 = emf2.createEntityManager();
em2.getTransaction().begin();

Pessoa p = em2.find(Pessoa.class, 1);
System.out.println("Nome da pessoa: "+p.getNome());

em2.getTransaction().commit();
em2.close();
emf2.close();

}

}

aqui está meu persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
	xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
	
	<persistence-unit name="BDSERV" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>br.gov.ce.srh.siscontv.model.entity.Pessoa</class>
		
		<properties>
			<property name="hibernate.connection.driver_class" value="net.sourceforge.jtds.jdbc.Driver" />
			<property name="hibernate.connection.username" value="user_sicf" />
			<property name="hibernate.connection.password" value="systemsicf" />
			<property name="hibernate.connection.url" value="jdbc:jtds:sqlserver://172.31.128.25/bdserv;" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" />
		</properties>
	</persistence-unit>
</persistence>

aqui minha classe pessoa:

package br.gov.ce.srh.siscontv.model.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="[DADOS DO SERVIDOR]")
public class Pessoa implements java.io.Serializable{

	
	private static final long serialVersionUID = 1L;
	
	@Id
	@Column(name="MATRÍCULA")
	private Integer matricula;
	
	@Column(name="NOME")
	private String nome;

	/**
	 * 
	 */
	public Pessoa() {
		
	}

	/**
	 * @param nome
	 */
	public Pessoa(String nome) {
	
		this.nome = nome;
	}

	/**
	 * @return the nome
	 */
	public String getNome() {
		return nome;
	}

	/**
	 * @param nome the nome to set
	 */
	public void setNome(String nome) {
		this.nome = nome;
	}

	/**
	 * @param matricula the matricula to set
	 */
	public void setMatricula(Integer matricula) {
		this.matricula = matricula;
	}

	/**
	 * @return the matricula
	 */
	public Integer getMatricula() {
		return matricula;
	}

	
	
	
	
	

}

Alguém poderia me da uma força ?

3 Respostas

EuclidesFilizola

Faltou só o erro né ?

KKKKKKKKKKKKKK

aqui está:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" javax.persistence.PersistenceException: [PersistenceUnit: BDSERV] Unable to build EntityManagerFactory
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)
	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
	at br.gov.ce.srh.siscontv.model.JPAUtil.main(JPAUtil.java:53)
Caused by: org.hibernate.HibernateException: JDBC Driver class not found: net.sourceforge.jtds.jdbc.Driver
	at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:89)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:137)
	at org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:29)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:89)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
	at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
	... 4 more
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:123)
	at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:84)
	... 11 more
EuclidesFilizola

Já resolvi pessoal.

Agradeço a todos !

Roberley_Cristiano

Euclides

Como que você resolveu este problema ?

Obrigado

Att

Criado 12 de agosto de 2009
Ultima resposta 20 de ago. de 2009
Respostas 3
Participantes 2