Hibernate version:
3.2.5

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
12:06:51,641 INFO org.hibernate.type.StringType[1]:144 - could not bind value '' to parameter: 2; Invalid column index.

Name and version of the database you are using:
firebird 2.0.3

The generated SQL (show_sql=true):
/* FindFirstRow */ /* cri first ?teria query */ select
this_.ID as ID1_0_,
this_.CODE as CODE1_0_,
this_.NAME as NAME1_0_
from
ROLE this_
where
this_.CODE>=?
order by
this_.CODE asc

IT SHOULD BE:
/* FindFirstRow */ /* criteria query */ select
this_.ID as ID1_0_,
this_.CODE as CODE1_0_,
this_.NAME as NAME1_0_
from
ROLE this_
where
this_.CODE>=?
order by
this_.CODE asc

Debug level Hibernate log excerpt:


----
This error only happens when I use .
I use a criteria query with setMaxResults(1).
Observe "first ?" inside comment generated
As I set use_sql_comments to false, everithing works again as expected.
If I suppress setMaxResults(1) the query works also as such a query.

Well, I've been looking around the code for a while and found the solution in adding a little modification to org/hibernate/dialect/FirebirdDialect.java


to look like this:

It was already working on HSQLDialect, actually.

Hope this change will appear in next release cause comments are a really interesting thing in order to debug a program.