title: Problem with SQL Connection
body: <p>I am working on a project which uses Java,Spring and Hibernate.
  I just came across a situaition like this.</p>
  
  <p>bean 1 :</p>
  
  <pre><code>&lt;bean id="cat" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"&gt;
      &lt;property name="proxyInterfaces"&gt;
          &lt;list&gt;
              &lt;value&gt;cat&lt;/value&gt;
          &lt;/list&gt;
      &lt;/property&gt;
      &lt;property name="transactionManager"&gt;
          &lt;ref bean="transactionManager"/&gt;
      &lt;/property&gt;
      &lt;property name="transactionAttributeSource"&gt;
          &lt;ref bean="attributeSource"/&gt;
      &lt;/property&gt;                          
  &lt;/bean&gt;
  </code></pre>
  
  <p>bean 2:</p>
  
  <pre><code>&lt;bean id="dog" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"&gt;
      &lt;property name="proxyInterfaces"&gt;
          &lt;list&gt;
              &lt;value&gt;dog&lt;/value&gt;
          &lt;/list&gt;
      &lt;/property&gt;
      &lt;property name="transactionManager"&gt;
          &lt;ref bean="transactionManager"/&gt;
      &lt;/property&gt;
      &lt;property name="transactionAttributeSource"&gt;
          &lt;ref bean="attributeSource"/&gt;
      &lt;/property&gt;                          
  &lt;/bean&gt;
  </code></pre>
  
  <p>but while executing a getting the following exception</p>
  
  <pre><code>org.springframework.jdbc.support.SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes 
  org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data;
      nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;
      nested exception is java.sql.SQLException: Connection has already been created in this tx context for pool  Illegal attempt to create connection from another pool
  Caused by: 
      at weblogic.jdbc.jts.Driver.getExistingConnection(Driver.java:613)
  </code></pre>
  
  <p>Assume cat and dog are two differnt interfaces</p>
  
  <p>cant we have two transaction manager opened ?? </p>