[
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.
