juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kurt T Stam (JIRA)" <juddi-...@ws.apache.org>
Subject [jira] Created: (JUDDI-442) Documentation on using HSQL DB
Date Wed, 15 Dec 2010 14:41:01 GMT
Documentation on using HSQL DB
------------------------------

                 Key: JUDDI-442
                 URL: https://issues.apache.org/jira/browse/JUDDI-442
             Project: jUDDI
          Issue Type: Task
            Reporter: Kurt T Stam
            Assignee: Kurt T Stam
             Fix For: 3.0.5


Michael Mikich contributed the following:

Hi, the documentations says:
"If you use another database, please document, and send us what you had to change to make
it work and we will include it here."

Here is what needs to be done for HSQL database support:

HSQL standalone server startup:
cd ../data
java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --port 1747 --database.0 file:juddi --dbname.0
juddi

HSQL client manager:
cd ..\data
@java -classpath ..\lib\hsqldb.jar org.hsqldb.util.DatabaseManagerSwing --driver org.hsqldb.jdbcDriver
--url jdbc:hsqldb:hsql://localhost:1747/juddi  -user JUDDI --password password

Initially one needs to connect to database as SA user with blank password to create JUDDI
user and schema:
CREATE USER JUDDI PASSWORD "password"  ADMIN;
CREATE SCHEMA JUDDI AUTHORIZATION JUDDI;
SET DATABASE DEFAULT INITIAL SCHEMA JUDDI;
ALTER USER juddi set initial schema juddi;

>From now on, one can connect as JUDDI user to that database. Database is now ready!

Next, take hsqldb.jar from HSQL lib directory and copy it to Tomcat lib directory.

Setup persistence and data source:
pesistence.xml changes:
ersistence xml: (zamjenio derby postavke sa postavkama za HSQL)
        <!--<non-jta-data-source>java:comp/env/jdbc/JuddiDS</non-jta-data-source>-->
        <non-jta-data-source>java:comp/env/jdbc/JuddiDSHSQL</non-jta-data-source>
   

          <!--<property name="openjpa.jdbc.DBDictionary" value="derby"/>-->
         <property name="openjpa.jdbc.DBDictionary" value="hsql"/>

Define new data source in context.xml:
<?xml version="1.0" encoding="UTF-8"?>

<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <!--  derby data source -->
    <Resource name="jdbc/JuddiDS" auth="Container"
            type="javax.sql.DataSource" username="" password=""
            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
            url="jdbc:derby:target/juddi-derby-test-db;create=true"
            maxActive="8"
            />
   
     <!-- HSQL data source -->
    <Resource name="jdbc/JuddiDSHSQL" auth="Container"
            type="javax.sql.DataSource" username="JUDDI" password="password"
            driverClassName="org.hsqldb.jdbcDriver"
            url="jdbc:hsqldb:hsql://localhost:1747/juddi"
            maxActive="8"
            />


    <!-- mysql
    <Resource name="jdbc/JuddiDS" auth="Container"
            type="javax.sql.DataSource" username="root" password=""
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/juddiv3"
            maxActive="8"
            />
        -->   
</Context>

And that is it ;)
cheers!


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message