On 5-9-2014 19:48, [email protected] [firebird-support] wrote: > 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.
I'd start with obtaining a thread dump of the application when it is hanging. The stacktraces might hint at the cause. Also if you are using Firebird 2.5, use the trace facility for logging the activity. Also consider upgrading to Jaybird 2.2.5; I fixed several concurrency bugs which could cause livelock or deadlock (although most of those were in parts you aren't using). Other than that: investigate your code to make sure it isn't using long running transactions. > 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> -- Mark Rotteveel
