title: TopLink with JPA taking more connections
body: <p>In my application we are using Toplink with Jpa.
  Here the problem is we are using stored procedures in this application, we are taking the connection using Jndi connection for Stored Procedure calling, and we are using EntityManger for remaining queries. But here if we launching the application it is taking two connections from connection pool. After the application launching I am calling the Stored Procedure(sp)
  one sp I am taking one connection but in websphere connection pool it is creating two connections?
  can U plese help me how to overcome this problem.....</p>
  
  <p>I won't using JTA, to get the JDBC connection I am using</p>
  
  <p>EntityManager em = getJpaTemplate().getEntityManagerFactory().createEntityManager();</p>
  
  <p>this way I am getting the JDBC Connection...and I configured the persitence.xml file following code...</p>
  
  <pre><code>&lt;properties&gt;
      &lt;property name="toplink.logging.level" value="OFF"/&gt;
      &lt;property name="toplink.cache.type.default" value="NONE"/&gt;
      &lt;property name="com.thoughtinc.runtime.persistence.sql.syntax" value="db2" /&gt;
  &lt;/properties&gt;
  </code></pre>
  
  <p>So, please kindly look into this and tell me any if I am doing any wrong here.</p>