[firebird-support] RE: Why is this setup not working?

2013-12-11 Thread talker3333
Hey Mark. Thanks for your reply. The firebird DB is running SuperClassic. The config kan be found on pastebin http://pastebin.com/ZzxL4xVc http://pastebin.com/ZzxL4xVc

Re: [firebird-support] RE: Why is this setup not working?

2013-12-11 Thread Alexey Kovyazin
Hi, There are some things in the config which could be tuned, but not many - I would increase size of lock table to 10Mb and number of page buffers to 512 pages. But in general it looks like typical problems are not in place here, i.e. your problem is not obvious and it requires professional

[firebird-support] RE: Why is this setup not working?

2013-12-11 Thread talker3333
Hi Alexey. Thanks for your respons. I acknowledge your thoughts. I would like to address the issue of scale-ability. What are our options of scaling the environments. For now we have sharded the database into two separate servers(on psychical hardware). That helped for a while but bow

[firebird-support] CASCADE option in FK declaration doesn#39;t work - after some time

2013-12-11 Thread respektive
Hi, I'm using - ON UPDATE CASCADE, or ON DELETE CASCADE options in FK declarations - when I create the FK it works - but sometimes - after backup/restore or some undefined time - I don't know - it doesn't work. I'm using FB 2.5.2 64b on windows server 2008 R2 Example - today I wanted to

[firebird-support] Firebird and JBoss/Hibernate: LockAcquisitionException: could not update error raised

2013-12-11 Thread Leyne, Sean
All, I realize that this is more of an JBoss/Hibernate issue, but web details on the error are sketchy so I thought I would reach out to see if anyone in the FB community had run into this error/exception. The exact message/error stack is: 15:25:02.349 [ActiveMQ Session Task-2276] ERROR