How do I debug HSQL connection in Harvest?

drumeng's picture
drumeng asked on July 1, 2011 - 8:33am | Replies (2).

We have Windows clients connecting fine to the broker through the GUI. Attempts to run hsql in a command window get past the login and provide a prompt for the SQL Command.

Any select command then hangs. There is no output in the log.

How to debug ?

2 Answers

Tom Cameron's picture

Are you terminating the input?

On Windows, after typing the SQL statement, hit <enter> so the your cursor is on a new blank line, then hit <control>-z. That signals the EOF and hsql should continue. On Unix/Linux, you don't need to be on a blank line, and it's <control>-d instead.

-Tom

drumeng's picture
drumeng replied on July 1, 2011 - 1:16pm.

Thanks..that was the problem....

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.