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 | |
Post date | 2014-09-05T17:48:02Z |
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>
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>