[kepler-dev] [Bug 4430] New: - hsql database name and port in Kepler should be configurable

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4430

           Summary: hsql database name and port in Kepler should be
                    configurable
           Product: Kepler
           Version: 1.x dev
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: core
        AssignedTo: berkley at nceas.ucsb.edu
        ReportedBy: jianwu at sdsc.edu
         QAContact: kepler-dev at kepler-project.org


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.