Hi,
If I need to access the database that Zocalo updates how should I go about it? Essentially I need to use Zocalo as backend in my system and hence, I want to be able to modify the database by some other program that I am planning to write.
Thank you.
Zocalo uses the JDBC API to access a hibernate OODB using hsqldb. From Java, you should be able to use JDBC calls. The goal of JDBC was to enable pluggable replacement of the specific database used. My experience is that this is not as straightforward in practice as you'd want, because every database makes minor variations in the SQL interpretations. Hibernate supposedly covers up some of that, and makes it easier. There are some configuration options available in hibernate.properties that you could experiment with.