<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Turns out that DBConnectionFactory gets it's path from
DotKeplerManager. Here are the files/lines I had to change to make this
work:<br>
<ul>
<li>build-area/src/org/kepler/build/CleanCache.java: 39> File
keplerCache = new File(userDir, ".kepler");</li>
<li>core/src/org/ecoinformatics/util/Config.java: 76>
private static final String settingsdir = ".kepler";</li>
<li>core/src/org/kepler/util/DotKeplerManager.java 26> +
File.separator + ".kepler" + File.separator;</li>
<li>core/src/org/kepler/util/DotKeplerManager.java: 122> +
".kepler" + File.separator + "cache"</li>
</ul>
As it now stands, my production version uses ${user.home}\.kepler and
my dev version uses ${user.home}\.kepler-dev<br>
<br>
Rick<br>
<br>
ben leinfelder wrote:
<blockquote
cite="mid:06C2FEE6-8613-449D-8003-2985AE4804FC@nceas.ucsb.edu"
type="cite">Rick,
<br>
The path is specified in DBConnectionFactory but should probably be
moved into the config.xml file so that it is more readily changed.
<br>
I'm fearful that simply changing the HSQL database path will not be a
viable option as there are many other cache-specific files in the
~/.kepler directory that may interfere with this mix of old and new
databases/cache files.
<br>
Certainly give it a try (strongly recommend backing up your existing
.kepler beforehand) to see if you have satisfactory results.
<br>
You might be happier running the different Kepler versions as a
different user on the same computer - that will allow you to keep the
~/.kepler directories distinct since they will be under different user
directories.
<br>
-ben
<br>
<br>
On Aug 25, 2009, at 10:33 AM, Rick Moore wrote:
<br>
<br>
<blockquote type="cite">Thanks for the prompt response Ben.
<br>
<br>
This seems to indicate that the path to the HSQL database is hardcoded
somewhere in the Kepler src base. If that is the case, would someone
please help me find where that is ? I haven't had any luck with
cygwin/grep or Windows file search.
<br>
<br>
I need to be able to run both the prod and dev instances on a daily
basis. The prod version to run/maintain existing workflows and the dev
version to build/debug new actors. We will eventually go to the newest
source base for both, but that may take a couple of months.
<br>
<br>
Rick
<br>
<br>
ben leinfelder wrote:
<br>
<blockquote type="cite">Rick,
<br>
Unfortunately we do not currently have an "upgrade" approach for going
from Kepler 1.0 to the development trunk (though it is something we are
attempting to support in the future).
<br>
To preserve your existing HSQL database (say, if you plan on using
Kepler 1.0 again after you successfully run Kepler from the trunk) I'd
recommend copying your ~/.kepler directory to a safe location and then
re-running Kepler from the trunk. There have been substantial changes
to the cache database (the HSQL version was upgraded and various tables
have had their schema altered). Your new ~/.kepler (automatically
created when you launch Kepler from the trunk) will allow you to use
the trunk version. If/when you want to go back to Kepler 1.0, you'll
need to swap in your old ~/.kepler and launch 1.0.
<br>
Thanks,
<br>
-ben
<br>
<br>
On Aug 25, 2009, at 9:38 AM, Rick Moore wrote:
<br>
<br>
<blockquote type="cite">I just tried to run Kepler 1.0.0 and it
failed. This extract from the stack trace suggests that the problem is
a corrupt HSQL database.
<br>
<br>
java.sql.SQLException: Wrong database file version
<br>
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
<br>
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
<br>
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
<br>
at org.hsqldb.jdbcDriver.connect(Unknown Source)
<br>
<br>
I think this happened because I recently downloaded and built Kepler
from the dev tree and it stomped on my production database.
<br>
<br>
Is there any way to tell one of these instances to look for the HSQL
database in a different location than my home directory ?
<br>
<br>
Thanks,
<br>
<br>
Rick Moore
<br>
Content Management Specialist
<br>
Information Science
<br>
Cornell University
<br>
email: rem63 at cornell dot edu
<br>
<br>
"Once in a while you will be shown the light in the strangest of
places, if you look at it right"
<br>
from Scarlet Begonias by the Grateful Dead
<br>
_______________________________________________
<br>
Kepler-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Kepler-users@kepler-project.org">Kepler-users@kepler-project.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users">http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users</a>
<br>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>