JPA - Limitar número de conexões quando cria EntityManagerFactory

Assuntos Gerais
#1

Olá Pessoal,

Estou fazendo uma aplicação desktop, quando crio a fábrica de objetos e abro uma transação, ele cria um monte de conexões com o banco.
Preciso apenas de uma, alguém sabe como limitar.

Agradeço a atenção

[TopLink Config]: 2009.09.22 09:36:55.792--ServerSession(23255990)--Connection(24392121)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:55.917--ServerSession(23255990)--Connection(3916915)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:55.917--ServerSession(23255990)--Connection(31365828)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.042--ServerSession(23255990)--Connection(3686501)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:56.042--ServerSession(23255990)--Connection(17547166)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.182--ServerSession(23255990)--Connection(5324129)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:56.182--ServerSession(23255990)--Connection(26530674)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.307--ServerSession(23255990)--Connection(29752800)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:56.307--ServerSession(23255990)--Connection(27165481)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.432--ServerSession(23255990)--Connection(28652556)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:56.432--ServerSession(23255990)--Connection(23860799)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.573--ServerSession(23255990)--Connection(19432672)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
        Driver: Oracle JDBC driver  Version: 10.1.0.2.0
[TopLink Config]: 2009.09.22 09:36:56.573--ServerSession(23255990)--Connection(19647819)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>OraclePlatform
        user name=> "CONFERENCIAOS"
        datasource URL=> "jdbc:oracle:thin:@ip:global"
))
[TopLink Config]: 2009.09.22 09:36:56.698--ServerSession(23255990)--Connection(24061351)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@10.1.0.44:1521:globalph
        User: CONFERENCIAOS
        Database: Oracle  Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
#2

Coloca a classe ae rapaz.Senão n tem como te falar oque fazer.Cada caso um caso.

#3

Olá, não tem uma classe, o metódo é o seguinte

public EntityManager getEntityManager(){
        EntityManager toReturn = emf.createEntityManager();
        return toReturn;
    }

e o persistence.xml é o seguinte


<?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="jConferenciaOSPU" transaction-type="RESOURCE_LOCAL">
    <provider>oracle.toplink.essentials.PersistenceProvider</provider>
    <class>br.com.servimed.jconferenciaos.entidades.negocio.CosUsuarioCoordenador</class>
    <properties>
      <property name="toplink.jdbc.user" value="CONFERENCIAOS"/>
      <property name="toplink.jdbc.password" value="conferenciaos"/>
      <property name="toplink.jdbc.url" value="jdbc:oracle:thin:@99.9.0.99:1521:gljeg"/>
      <property name="toplink.jdbc.driver" value="oracle.jdbc.OracleDriver"/>
      <property name="toplink.logging.level" value="FINE"/>
      <property name="toplink.logging.exceptions" value="true"/>    
    </properties>
  </persistence-unit>
</persistence>
#4

Olá tenta assim.nAO ENTENDI ESTA CLASS…ae dentro…mas vc pode tirar, que a conexao vai funcionar tranquila



   1. <?xml version="1.0" encoding="UTF-8"?>  
   2. <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">  
   3.   <persistence-unit name="jConferenciaOSPU" transaction-type="JTA">  
   4.      <jta-data-source>jdbc/SUAFONTEDEDADOS</jta-data-source>
   5.     <class>br.com.servimed.jconferenciaos.entidades.negocio.CosUsuarioCoordenador</class>  
   6.     <properties>  
   7.       <property name="toplink.jdbc.user" value="CONFERENCIAOS"/>  
   8.       <property name="toplink.jdbc.password" value="conferenciaos"/>  
   9.       <property name="toplink.jdbc.url" value="jdbc:oracle:thin:@99.9.0.99:1521:gljeg"/>  
  10.       <property name="toplink.jdbc.driver" value="oracle.jdbc.OracleDriver"/>  
  11.       <property name="toplink.logging.level" value="FINE"/>  
  12.       <property name="toplink.logging.exceptions" value="true"/>      
  13.     </properties>  
  14.   </persistence-unit>  
  15. </persistence>
#5