[firebird-support] Exceptioin when using connection in distributed transaction in Java Application server

2014-09-18 Thread doyc...@dsoft-bg.com [firebird-support]
Hi, This exception I get when I try to close connection that I get from a Datasource that I lookup from JNDI. I use try { // Some code that uses connection } finally { connection.close(); } 11:58:47,160 ERROR [STDERR] Caused by: org.firebirdsql.jdbc.FBSQLException: Connection enlisted

[firebird-support] Re: Exceptioin when using connection in distributed transaction in Java Application server

2014-09-18 Thread doyc...@dsoft-bg.com [firebird-support]
This is with jaybird 2.2.5 JDK 7. I use JBoss App server 4.2.3 on JDK 1.7.0-40 My datasource definition is: ?xml version=1.0 encoding=UTF-8? connection-factories tx-connection-factory jndi-nameDSoftDS/jndi-name xa-transaction/ track-connection-by-tx/

Re: [firebird-support] Exceptioin when using connection in distributed transaction in Java Application server

2014-09-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18 Sep 2014 02:03:34 -0700, doyc...@dsoft-bg.com [firebird-support] firebird-support@yahoogroups.com wrote: Hi, This exception I get when I try to close connection that I get from a Datasource that I lookup from JNDI. I use try { // Some code that uses connection } finally {

[firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
Hi-- I've got a FB 2.5 app that uses IBO components and Delphi The instance has perhaps 40 concurrent users. Someone would potentially have a record in 'edit' mode. Another user does a read-only (tIBOQuery.RequestLive := False) select from the same table. Not always, but once

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
thanks for the quick reply i'll create another IBOTransaction and use it for the one query that is doing the 'read-only' simple select that is resulting in the error. would you expect that error to occur every time a 2nd user does a readonly select that includes the 1st users record in

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

[firebird-support] Firebird 2.5.3 SS Tuning

2014-09-18 Thread Tiziano tmdevelo...@yahoo.com [firebird-support]
Hello, this is my first topic, I have a complex (for me) configuration and I hope that I'll explain correctly the problem (English is not my native language, please excuse me for grammatical or typing errors). I have a virtual server with this specs: Windows Server 2008 Standard (Build:

Odp: [firebird-support] Firebird 2.5.3 SS Tuning

2014-09-18 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, Your big problem is low RAM with 32bit os an FB. Esspecially your sweep can take very very long time if some of your index is bigger than avaiable RAM. And yes upgrade to new server with minimum 16 GB RAM. Your DB is 50GB then the best will be 64. Then backup your db an restore with 16k