Boa tarde caros amigos, estou aqui apanhando um bocado no JPA.
Estou tentando fazer um teste, e não está inserindo.
@Test
public void testInserirUsuario(){
String login = System.getProperty("user.name");
UsuarioDAO usuarioDAO = new UsuarioDAO();
UsuarioLocalDAO instance = new UsuarioLocalDAO();
UsuarioLocal user = new UsuarioLocal();
Usuario usuario = new Usuario();
usuario = usuarioDAO.buscarUsuario(login);
user = instance.obterUsuario(usuario);
instance.inserirUsuario(user);
}
aqui está meus métodos:
public Usuario buscarUsuario(String login){
return JPAUtil.getInstance("BDSERV").getEntity(Usuario.class,login);
}
public UsuarioLocal obterUsuario(Usuario usuario){
usuarioLocal.setNome(usuario.getNome());
usuarioLocal.setCodigoSetor(1);
usuarioLocal.setTipoDeUsuario(1);
usuarioLocal.setId(1);
return usuarioLocal;
}
public void inserirUsuario(UsuarioLocal usuarioLocal){
EntityManager em = JPAUtil.getInstance("bancoLocal").getEntityManager();
em.persist(usuarioLocal);
em.getTransaction().commit();
em.close();
}
… dae da o seguinte erro:
javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at teste.UsuarioLocalDAOTest.testInserirUsuario(UsuarioLocalDAOTest.java:63)
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:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [entity.UsuarioLocal]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
... 25 more
Caused by: java.sql.SQLException: Invalid object name 'teste.tbsisc_usuario'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2265)
... 36 more
Dae já explico , a tabela teste.tbsisc_usuario existe sim ! …
e tem um detalhe se eu trocar meu teste para o seguinte:
@Test
public void testInserirUsuario(){
String login = System.getProperty("user.name");
UsuarioDAO usuarioDAO = new UsuarioDAO();
UsuarioLocalDAO instance = new UsuarioLocalDAO();
UsuarioLocal user = new UsuarioLocal();
Usuario usuario = new Usuario();
user.setCodigoSetor(codigoSetor);
user.setId(id);
user.setNome(nome);
user.setTipoDeUsuario(tipoDeUsuario)
instance.inserirUsuario(user);
}
Dessa forma a inserção funciona, já da outra não funciona. Gostaria de uma ajuda. Alguém para dar uma força ?