Project

General

Profile

Actions

Bug #4430

closed

hsql database name and port in Kepler should be configurable

Added by jianwu jianwu about 15 years ago. Updated almost 14 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
core
Target version:
Start date:
09/30/2009
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
4430

Description

I can't start Kepler GUI when I have hadoop server running. It complains:

Caused by: java.sql.SQLException: Failed to connect to url "jdbc:hsqldb:hsql://localhost/hsqldb" as user "sa. Perhaps there was an error launching the db server. In addition, sometimes the database cache can become corrupt, so another solution is to remove the "/Users/jianwu/.kepler/cache/cachedata/hsqldb" directory.
[run] at org.kepler.util.DBConnectionFactory.getDBConnection(DBConnectionFactory.java:126)

With Dan's help, I found out it is because hadoop also have its hsql databases. Now I work it around by setting port of hsql server to another one (e.g. 9002)
1) add 'server.setPort(9002);' at launchDBServer() function.
2) change url to url = "jdbc:hsqldb:hsql://localhost:9002/" + dbName;

So I think hsql database name and port in Kepler should be configurable.

Other possible changes could be better exception handling, such as automatic port change, or mentioning this port is already in use.

Actions

Also available in: Atom PDF