Does this sql also include the scripts required for the jyve (New accounts)
functionality. As I recall, with MySQL, I had to execute a
*_users_role_permissions.sql and some .schema file from jyve. Have these all
been wrapped into the single .sql now? Or is there also a hypersonic.schema
file to load?
I ask because I would like to switch from MySQL to hypersonicSQL, but do not
want to cripple my system by "learning the hard way".Is anybody working on
the including of a fully configure HypersonicSQL setup? If not, I will
volunteer - I just figured that since it is an old thread someone may
already be on the verge of releasing it.
Steve B.
Steve B.
----- Original Message -----
From: "Rapha�l Luta" <[EMAIL PROTECTED]>
To: "JetSpeed" <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 2:49 AM
Subject: Re: Jetspeed and HyperSonic : ==> org.hsql.jdbcDrivernotimpleme
nted.
> > NABETH Thierry wrote:
> >
> > >> I inialialized HyperSonic with the Turbine tables as recommended
> > in the Turbine docs.
> >
> > Which doc ?
> > http://java.apache.org/turbine/install.txt ?
> > ----
> > mysqladmin create turbine
> > mysql turbine < tables.schema
> > ----
> >
> > if it is the case you have to download turbine.
> >
>
> No, I found it in
>
> docs/schemas/HypersonicSQL_users_role_permissions.sql
>
> in the Turbine distribution.
>
> Extract:
>
> -- This is a schema for Hypersonic SQL for the concept of
Users/Roles/Permissions
> -- (Note: These instructions are written to conform with v. 1.42.)
> --
> -- Note: The process for creating a database in Hypersonic SQL is a tad
> -- convoluted. These instructions are written to match. ;)
> --
> -- The following steps use the DatabaseManger program harness contained in
> -- the HypersonicSQL distribution.
> --
> -- 1. Create a directory to store the database files (e.g., C:\TurbineDB).
> -- 2. Launch the Hypersonic Database Manager. See the Hypersonic SQL
> -- documentation for details.
> -- 3. In the Connect dialog box, choose 'HypersonicSQL Standalone' for the
> -- Type and set the URL to 'jdbc:HypersonicSQL:C:\TurbineDB\turbine'.
> -- 4. Paste the contents of this file (after these comments) into the
Database
> -- Manager Command Area (the upper right part of the main window) and
click
> -- the Execute button.
> -- 5. Set the following in TurbineResources.properties:
> -- database.default.driver=org.hsql.jdbcDriver
> -- database.default.url=jdbc:HypersonicSQL:C:\TurbineDB\turbine
> -- database.default.username=sa
> -- database.default.password=
> -- 6. Make sure the Hypersonic SQL jar is in the CLASSPATH of your servlet
> -- engine.
>
> --
> Rapha�l Luta - [EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
