Erro while commit transaction

[Euclides Filizola]

So, good afternoon guys, i'm have a little problem. I'm trying to access 2 different databases. One is PostgreSQL and is localhost, the other is SQLServer and is in address 172.31.128.25. Here is my code.

my 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="bancoLocal" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>entity.Grupo</class>
		<class>entity.AndamentoSolicitacao</class>
		<class>entity.Solicitacao</class>
		<class>entity.Estado</class>
		<class>entity.Viagem</class>
		<class>entity.UsuarioLocal</class>
		
		<properties>
			<property name="hibernate.connection.driver_class" value="org.postgresql.Driver" />
			<property name="hibernate.connection.username" value="postgres" />
			<property name="hibernate.connection.password" value="1234" />
			<property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/SISCONTV" />
			<property name="hibernate.show_sql" value="true" /><!--
			<property name="hibernate.format_sql" value="true" />
			--><property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
		</properties>
	</persistence-unit>
	
	<persistence-unit name="BDSERV" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>entity.Usuario</class>
		<properties>
			<property name="hibernate.connection.driver_class" value="net.sourceforge.jtds.jdbc.Driver" />
			<property name="hibernate.connection.username" value="User_SICV" />
			<property name="hibernate.connection.password" value="systemsicv" />
			<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-unit name="BDINTR" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>entity.Setor</class>
		<properties>
			<property name="hibernate.connection.driver_class" value="net.sourceforge.jtds.jdbc.Driver" />
			<property name="hibernate.connection.username" value="User_SICV" />
			<property name="hibernate.connection.password" value="systemsicv" />
			<property name="hibernate.connection.url" value="jdbc:jtds:sqlserver://172.31.128.25/bdintr;" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" />
		</properties>
	</persistence-unit>
</persistence>

So, i have many tables into my db. And i'm testing one that. But it isn't work.

Here my test

	
	@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);
		
		
	}

Here my methods.

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();

	}

.. The StackTrace

javax.persistence.RollbackException: Error while commiting the transaction
	at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
	at br.gov.ce.srh.siscontv.model.DAO.UsuarioLocalDAO.inserirUsuario(UsuarioLocalDAO.java:35)
	at teste.UsuarioLocalDAOTest.testInserirUsuario(UsuarioLocalDAOTest.java:58)
	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)
	... 26 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)
	... 37 more

Here says " Caused by: java.sql.SQLException: Invalid object name 'teste.tbsisc_usuario'. "

But this table "teste.tbsisc_usuario" exist.

Anyone understand my problem ?

Just to complet. If i use

@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);  
    }  

...

It work !!! ...

i don´t know ... why !!