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] Closed: (JUDDI-442) Documentation on using HSQL DB
Date Wed, 15 Dec 2010 15:19:00 GMT

     [ https://issues.apache.org/jira/browse/JUDDI-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kurt T Stam closed JUDDI-442.
-----------------------------

    Resolution: Fixed

Done, thank you Michael :)!

> 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