Skip to content

Using Yamj3 with HSQL

Jump to bottom Edit New page
jluc2808 edited this page Jul 28, 2017 · 1 revision

Yamj3 could use several Database : MySql or HSQL

BEGINNER

For a brand new installation follow this THREAD

EXPERT

If you're more advertise, or if you have already installed Yamj3 you can modify to run with HSQL database.

with notepad++

  1. modify jetty.cmd or jetty.sh ==> use this starter to start jetty with HSQL db

java -Xms256m -Xmx1024m -Dspring.profiles.active=hsql -classpath .;lib/* org.yamj.jetty.Start %* with windows

java -Dspring.profiles.active=hsql -classpath .:./lib/* org.yamj.jetty.Start $@ with linux

  1. filescanner.cmd or filescanner.sh ==> use to start filescanner with windows , movie are stored under T:\video\Film (change this location to yours)

  2. create or modify yamj3-core-static.user.properties ==> to start with HSQL, with settings in this ex: French language, scrapped sites: Allocine, Tmdb, IMDB (+ TVDB for video)

    yamj3.database.url=jdbc:hsqldb:hsql://localhost:9001/yamj3 yamj3.language=fr yamj3.sourcedb.scanner.movie=allocine,tmdb,imdb yamj3.sourcedb.scanner.series=allocine,tvdb,tmdb,imdb yamj3.sourcedb.scanner.person=allocine,tmdb,imdb yamj3.sourcedb.scanner.filmography=allocine,tmdb,imdb

  3. yamj3-filescanner.user.properties ==> to add watched

filescanner.watch.default=true

**NOTA: if you don't run filescanner on the local machin, edit config/yamj3-filescanner.user.properties with wordpad or notepad++ and modify yamj3.core.host to your local IP again. Do not change the port.

HSQL Manager

  • download HSQL manager
  • to open HSQL manager , hsqldb/bin/runManagerSwing.bat
  • use : engine standalone
  • jdbc:hsqldb:file:D:\temp-yamjv3\yamj3_hsql_eversion_complet_install\database\yamj3
  • user : yamj3
  • password : yamj3
Add a custom footer
Add a custom sidebar
Clone this wiki locally