Subject How long a statement in firebird can be?
Author Doychin
hi guys,

What is the max allowed size for SQL statement for firebird?

I'm using Firebird 2.1.2 + Jaybird 2.1.6

The reason I'm asking this is that one of the production systems I have crashed this morning and started to act very strange.

The reason was a statement that was more then 32KB in size.

It was an automatically generated statement by JBoss CMP engine.

I just want to know how to proceed from here. Should I make changes to JBoss to partition such statements or there is another approach?

Thanks in advance