SQL Queries from netbeans on H2 database

[hesh]

Hi,
I have a connection on H2 database defined under Services->Databases. But when i try to execute query that has an aggregate function or some calculation included in the select clause (for example: select count(*) from REPORT_ABC_SUM), i don't get any result and netbeans reports only following (no detailed error information):
Line 1, column 1
Execution finished after 0 s, 1 error(s) occurred.

If i do a " select * ", or just enter column names, everything works fine.

Is there anything i need to set up for this to work?

[hesh]

Can at least someone confirm that this works on other databases? If that is the case, i'll post this on h2 forums as well .

[hesh]

Just to let everyone know. In netbeans 6.9 this works fine. 6.8 had problems