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.
