--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/database.properties Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,3 @@
+host = localhost
+user = root
+password =
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/ddl.txt Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,3 @@
+CREATE TABLE Employee (empid INT, PRIMARY KEY (empid), lastName STRING, birthday DATE, manager INT, FOREIGN KEY (manager) REFERENCES Employee(empid));
+CREATE TABLE Tasks (taskid INT, PRIMARY KEY (taskid), name STRING, lead INT, FOREIGN KEY (lead) REFERENCES Employee(empid));
+CREATE TABLE TaskAssignments (id INT PRIMARY KEY, PRIMARY KEY (id), task INT, FOREIGN KEY (task) REFERENCES Tasks(taskid), employee INT, FOREIGN KEY (employee) REFERENCES Employee(empid));
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/default-sparql-query.txt Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,17 @@
+PREFIX empP : <http://hr.example/DB/Employee#>
+PREFIX task : <http://hr.example/DB/Tasks#>
+PREFIX tass : <http://hr.example/DB/TaskAssignments#>
+PREFIX xsd : <http://www.w3.org/2001/XMLSchema#>
+SELECT ?name ?bday
+ WHERE { { ?above tass:employee ?who .
+ ?above tass:task ?atask .
+ ?atask task:lead ?taskLead .
+ ?taskLead empP:lastName ?name }
+ UNION
+ { ?below tass:task ?btask .
+ ?btask task:lead ?who .
+ ?below tass:employee ?managed .
+ ?managed empP:lastName ?name .
+ ?managed empP:birthday ?bday }
+ ?who empP:lastName "Smith"^^xsd:string .
+ ?who empP:birthday ?bday }
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/rdb2rdf.properties Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,1 @@
+default-stemuri = http://hr.example/DB/
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/webapp/WEB-INF/web.xml Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,10 @@
+<web-app xmlns="http://java.sun.com/xml/ns/javaee" version="2.5">
+ <servlet>
+ <servlet-name>sparqlendpoint</servlet-name>
+ <servlet-class>org.w3.sparql2sql.servlet.SparqlEndpoint</servlet-class>
+ </servlet>
+ <servlet-mapping>
+ <servlet-name>sparqlendpoint</servlet-name>
+ <url-pattern>/sparql/*</url-pattern>
+ </servlet-mapping>
+</web-app>
--- a/src/main/resources/database.properties Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-host = localhost
-user = root
-password =
--- a/src/main/resources/ddl.txt Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-CREATE TABLE Employee (empid INT, PRIMARY KEY (empid), lastName STRING, birthday DATE, manager INT, FOREIGN KEY (manager) REFERENCES Employee(empid));
-CREATE TABLE Tasks (taskid INT, PRIMARY KEY (taskid), name STRING, lead INT, FOREIGN KEY (lead) REFERENCES Employee(empid));
-CREATE TABLE TaskAssignments (id INT PRIMARY KEY, PRIMARY KEY (id), task INT, FOREIGN KEY (task) REFERENCES Tasks(taskid), employee INT, FOREIGN KEY (employee) REFERENCES Employee(empid));
--- a/src/main/resources/default-sparql-query.txt Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-PREFIX empP : <http://hr.example/DB/Employee#>
-PREFIX task : <http://hr.example/DB/Tasks#>
-PREFIX tass : <http://hr.example/DB/TaskAssignments#>
-PREFIX xsd : <http://www.w3.org/2001/XMLSchema#>
-SELECT ?name ?bday
- WHERE { { ?above tass:employee ?who .
- ?above tass:task ?atask .
- ?atask task:lead ?taskLead .
- ?taskLead empP:lastName ?name }
- UNION
- { ?below tass:task ?btask .
- ?btask task:lead ?who .
- ?below tass:employee ?managed .
- ?managed empP:lastName ?name .
- ?managed empP:birthday ?bday }
- ?who empP:lastName "Smith"^^xsd:string .
- ?who empP:birthday ?bday }
--- a/src/main/resources/rdb2rdf.properties Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-default-stemuri = http://hr.example/DB/
\ No newline at end of file
--- a/src/main/webapp/WEB-INF/web.xml Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,10 +0,0 @@
-<web-app xmlns="http://java.sun.com/xml/ns/javaee" version="2.5">
- <servlet>
- <servlet-name>sparqlendpoint</servlet-name>
- <servlet-class>org.w3.sparql2sql.servlet.SparqlEndpoint</servlet-class>
- </servlet>
- <servlet-mapping>
- <servlet-name>sparqlendpoint</servlet-name>
- <url-pattern>/sparql/*</url-pattern>
- </servlet-mapping>
-</web-app>