Thanks! Comments below.
On Tue, 13 Feb 2001, sbelt wrote:
> Hypersonic automatically creates the database if it does not already exist.
> I was able to use TDK10(?) with hypersonic sql.
>
> To use HypersonicSQL with the TDK, I had to do the following:
>
> 1) the file "jdbcStatement.java" of hypersonicSQL driver needs first to be
> patched (sorry, I do not ave diff on my Win2k box yet)
> replace:
> public ResultSet getResultSet() {
> if(Trace.TRACE) Trace.trace();
> return rSet;
> }
>
> with:
>
> public ResultSet getResultSet()
> {
> if(Trace.TRACE) Trace.trace();
> if (rSet != null && rSet.isResult())
> return rSet;
> return null;
> }
>
> If you like I can send you a patched hsql.jar.
I think it will work now without a patched jar. If printing
is on in the <sql> task it seems to break with most of
the JDBC drivers. I turned the printing off and all the
problems went away. But I will try to make sure.
> 2) update the hsql.jar file and put it in the share/tdk-lib folder
This is going in now.
> 3) Modify the share/conf/master/Turbine-schema.xml file.
> Remove from the "TURBINE_SCHEDULED_JOB" all attributes "default=-1"
> (hypersonic apparently does not support default values)
>
> (disclaimer: Does this break anything?)
I'm not sure, but I will fix torque and add the option to
suppress default values so that the turbine schema doesn't
have to be changed.
> 4) share/common/build/project.properties
> database=hypersonic
yup.
> 5) In TR.properties,
> database.default.driver=org.hsql.jdbcDriver
> database.default.url=jdbc.HypersonicSQL:<path where you want to put the
> db>/dbname
> database.default.username=sa
> database.default.password=
The path is a problem ... the jetspeed people handle this with
the VariableResources class.
> Or perhaps you already knew this ;)
Any tips are good, I've haven't tried Hypersonic so
your experience with it helps me a lot. Thanks for
the info :-)
jvz.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
