Hy people,
I was always wondering if there was any way to add some kind of
listener to a firebird connection to detect if the connection gets broken?

Neither java.sql.Connection nor FirebirdConnection class does define
such a method

Or do I have to poll the connection? If so, will isClosed() return
true, if the connection broke because of a physical condition?

Other:
I need some help/info about an sql command

"select count(distinct id),datum from aTable group by datum having
count(distinct id)>1"

I was wondering if there was any easier why to reference the first
column in the having clause.
For example:
select count(distinct id) as firstCol,datum from aTable group by datum
having firstCol>1

Thanks
John