Details
-
Task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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!