Subject Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
Author
I'm not sure it is locked table.

What I'm looking for is idea or advice how to find what the real problem is.

My data source definition is this:

<connection-factories>
  <tx-connection-factory>
    <jndi-name>PowerProDS</jndi-name>
    <xa-transaction/>
    <track-connection-by-tx/>
    <rar-name>jaybird-2.1.6.rar</rar-name>
    <connection-definition>javax.sql.DataSource</connection-definition>
    <config-property name="Database" type="java.lang.String">localhost/3050:powerpro</config-property>
    <user-name>sysdba</user-name>
    <password>masterkey</password>
    <config-property name="Encoding">UNICODE_FSS</config-property>
    <prepared-statement-cache-size>100</prepared-statement-cache-size>
    <min-pool-size>10</min-pool-size>
    <max-pool-size>50</max-pool-size>
      <metadata>
         <type-mapping>EuroPro</type-mapping>
      </metadata>
  </tx-connection-factory>
</connection-factories>