Install MySQL

  1. Install the ODBC Connector
  2. Install the MySQL Server and everything needed: http://dev.mysql.com/downloads/installer/
    You can see the instructions to set up the server.
  3. Create an empty database named "sdb". It can be done using MySQL Workbench. Database tab > Query Database > Connect > Click on the button "Create a new schema in the connected server".

MySQL Server must be up for the next step.

Configure the SDB

  1. Download the latest distribution from here. Release 1.3.6 was used.
  2. Set the environment variables (need to use cygwin) as stated here.
  3. Edit accordingly the file
    $SDBROOT/Store/sdb-mysql-innodb.ttl
    Rename it to sdb.ttl and move it to
    $SDBROOT/bin
  4. Move the MySql Driver (jar file downloaded here) in
    $SDBROOT/lib
  5. Run the command
    $SDBROOT/bin/sdbconfig --sdb=sdb.ttl --create
  6. Follow the instructions on Jena Website (Initialising the database)

Jena SDB Documentation

http://jena.apache.org/documentation/sdb/index.html

  • No labels