#68 Which database is used, where is the text content located?

[Anonymous]

I'd like to use Zocalo for a university study project in Oldenburg, Germany.
Can anyone tell me what kind of database is used by Zocalo?
I'd also like to translate the project into German.
Can anyone tell me, where the text content that shows up on a running Zocalo is located (f.e. "Please type an account name and password")

Kind regards,
Cornelius

[Chris Hibbert]

Zocalo uses hibernate on top of hsqldb.

Unfortunately, the text is all in the java code. I haven't done anything to extract localized text. The good news, such as it is, is that most of that is in specific jsp-generating files in /src/net/commerce/zocalo/JspSupport and a few other directories that isolate most of the web-page generating code.

[Anonymous]

Thanks, in this case I will translate the necessary parts into German and compile the code.

As I plan to get access to the database via a graphical interface (using HSQL and DbVisualizer), to enable comfortable data evaluation whilst the experiment, can you tell me, which port(s) the database uses? This is needed for the setup via DbVisualizer.

[Chris Hibbert]

The default port for hsqldb is 9001. You can change it by editing the zocalo.conf file.

database.url.base: jdbc:hsqldb:hsql://localhost/

The format would change to

database.url.base: jdbc:hsqldb:hsql://localhost:9005/

if you need to specify port 9005.