BocaDatabaseSupport-2.x

From IBM Semantic Layered Research Platform

Jump to: navigation, search

Contents

[edit]

Derby

Boca has been tested on Derby version 10.2.2.0.

  • Edit the start-derby.sh script, or the boca-derby.bat file, and update the DB_LIBS configuration to point to the directory containing the derby jars.
  • Modify Boca database server properties in BocaServer.properties.derby to connect to your database. 
 com.ibm.boca.repository.database.user=boca
 com.ibm.boca.repository.database.password=
 com.ibm.boca.repository.database.url=jdbc:derby:/tmp/bocaDerby;create=true;upgrade=true
 com.ibm.boca.repository.database.clear=false
 com.ibm.boca.repository.database.type=BocaDerby
  • Start the Boca server using the BocaServer.properties.derby configuration file.
[edit]

MySql

Boca has been tested on Mysql version 5.1.14. You will need a MySQL server, and the MySQL java connector 5.0.4.

  • Edit the start-mysql.sh script, or the boca-mysql.bat file, and update the DB_LIBS configuration to point to the directory containing the MySQL connector jars.
  • Modify Boca database server properties in BocaServer.properties.mysql to connect to your database. 
 com.ibm.boca.repository.database.user=boca
 com.ibm.boca.repository.database.password=boca
 com.ibm.boca.repository.database.url=jdbc:mysql://localhost/boca
 com.ibm.boca.repository.database.clear=false
 com.ibm.boca.repository.database.type=BocaMySQL
  • Create a database called boca or the name you set in the properties
  • Start the Boca server using the BocaServer.properties.msql configuration file.
[edit]

PostgreSQL

Boca has been tested on PostgreSQL version 8.2.2. You will need a PostgreSQL server and PostgreSQL jdbc jar.

  • Edit the start-postgres.sh script, or the boca-postgres.bat file, and update the DB_LIBS configuration to point to the directory containing the PostgreSQL jdbc jars.
  • Modify Boca database server properties in BocaServer.properties.postgres to connect to your database. 
 com.ibm.boca.repository.database.user=postgres
 com.ibm.boca.repository.database.password=
 com.ibm.boca.repository.database.url=jdbc:postgresql:boca
 com.ibm.boca.repository.database.clear=false
 com.ibm.boca.repository.database.type=BocaPostgres
  • Create a database called boca or the name you set in the properties file.
  • Start the Boca server using the BocaServer.properties.postgres configuration file.
[edit]

HSQLDB

Boca has been tested on HSQLDB version 1.8.0.

  • Edit the start-hsql.sh script, or the boca-hsql.bat file, and update the DB_LIBS configuration to point to the directory containing the HSQLDB jars.
  • Modify Boca database server properties in BocaServer.properties.hsql to connect to our database. 
 com.ibm.boca.repository.database.user=sa
 com.ibm.boca.repository.database.password=
 com.ibm.boca.repository.database.url=jdbc:hsqldb:mem:bocadb
 com.ibm.boca.repository.database.clear=false
 com.ibm.boca.repository.database.type=BocaHSQL
  • Start the Boca server using the BocaServer.properties.hsql configuration file. The configuration file uses an in memory database which is good for testing, but a persisisted database should work as well.
Retrieved from "http://ibm-slrp.sourceforge.net/wiki/index.php/BocaDatabaseSupport-2.x"
Personal tools