* JENA/D2R sparql : * Set paths for jena/arq and add them in path in order to run sparql from command line (JENA) * Make d2rq server run : * Prequisites : * Java 1.4 or newer on the path OK * Supported DB (mysql) * Download a JDBC driver from your database vendor. Place the driver's JAR file into D2R Server's /lib directory. !jdbc:mysql://servername/database for MySQL) from the driver's documentation. Drivers for MySQL and PostgreSQL are already included with D2R Server. * Generate a mapping and an RDF file : DONE : * $ ./generate-mapping.bat -d com.mysql.jdbc.Driver -u molgenis -p molgenis [jdbc:!mysql://127.0.0.1/molgenis jdbc:mysql://127.0.0.1/molgenis] > molgenis.n3 * * $ ./dump-rdf.bat -u molgenis -p molgenis -d com.mysql.jdbc.Driver -j !jdbc:mysql://127.0.0.1/molgenis > molgenis.rdf * Start the server : $ ./d2r-server.bat mapping.n3 OK * http://localhost:2020/ (currently not working) * fix paths and start server again: * export D2R_ROOT="D:/..../d2r/d2r-server-0.7/" * export PATH=$PATH:$D2R_ROOT * * Potential problem cause : Alter the mapping file (molgenis.n3) in order to include SERVER configuration : * now on command line : * /cygdrive/d/despoina/d2r/d2r-server-0.7 $ ./d2r-server.bat molgenis.n3 * ERROR : molgenis.n3: Line 4, column 5: Unresolved prefixed name: rdfs:label * * The !rdfs:label is the server name displayed throughout the HTML interface.(see here :http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/#about) * '''alternative TODO 1''' : '''Running D2R Server as a service on Windows http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/#about''' * alternative TODO 2''' : [http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/#container Running D2R Server in an existing Servlet Container] ''' * '''(TODO pre: for now in order to do this we have to correct the server config inside molgenis.n3) ''' * Peregrine new version ...download? - the version installed in Peregrine_test3 is the latest! jar files are 0.3! * Added web content from Ontocat Rest service into '''molgenis distro . (locally) '''. Runs ok , but how will retrieve return results from ontocat rest service since molgenis is running, not ontocat. * SVN commit : Added Jena & d2r into SVN --> http://www.molgenis.org/svn/molgenis_projects/Jena * SVN commit :Added Peregrine test 3 into SVN --> http://www.molgenis.org/svn/molgenis_projects/PeregrineTest3 * * Disease Book: @umcg : source code from Mark : * Disease book * Molgenis 3_3 * Ontologiedatabasetest * First create database * run Actions: (project in SVN: http://www.molgenis.org/svn/molgenis_projects/molgenis_rdf_test) * '''copy the d2rq libs into molgenis_distr/WEB-INF/lib ..''' * OK do we have also to include in proporties-> java EE module depenencies? * '''copy line 9-134 from d2r/webapp/WEB-INF/web.xml into molgenis_distr/WebContent/WEB-INF/web.xml -->''' * Ok in \desp\workspace\molgenis_distro\WebContent\WEB-INF\web.xml lines 71 - 196 * (these are comments right? otherwise have to be removed! * '''change line 128 that says /index.html to /rdf.html''' * ok line 193 /rdf.html * '''copy a mapping file into molgenis_distro/WebContent/WEB-INF/ OK''' * run generate mapping (bat or sh)--> generate mapping for addressbook * $ ./generate-mapping.bat -d com.mysql.jdbc.Driver -u molgenis -p molgenis jdbc:!mysql://127.0.0.1/molgenis > molgenis.n3 OK * weirdly does not work for addressbook ... * [http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/#configuration We have to alter the mapping file] ()..adding in the beginning: * {{{ @prefix : <#> . @prefix ja: . @prefix d2rq: . <> ja:imports d2rq: . :myModel a d2rq:D2RQModel; d2rq:mappingFile ; d2rq:resourceBaseURI ; . }}} * {{{ @prefix d2rq Is this OUR installation of D2RQ????? ALSO : }}} * {{{ d2rq:resourceBaseURI ; this doesn't work . will this influence the servlet?? }}} * '''make sure the configFile in web.xml has same name as the file''' * '''Morris changes @ See commit messages http://www.molgenis.org/svn/molgenis_projects/molgenis_rdf_test); ended up hacking the D2RQ java class that loads the config file.'''