java application uses hsql to store data, can I .net application odbc to that?
See this answer.
You can with HSQLDB version 2 and the ODBC driver