Hello,
Thanks, first, for taking up such a major work of building d2rq as a
running rdb-to-rdf processor.
I am trying to get used to it, and trying first to auto-generate the
mapping. However, some issues start popping up in the beginning.
I have a database on MS SQL Server (I ported it to MS SQL Server 2012).
1. The query
generate-mapping -u sa -p xx -d
com.microsoft.sqlserver.jdbc.SQLServerDriver -o outfileX.ttl
jdbc:sqlserver://AAA;databaseName=Bāze
works fine, with lots of "sorry tables", what is perfectly understandable.
Running the server I get:
11:29:16 WARN WebAppContext :: Failed startup of context
o.e.j.w.WebAppContext{,file:/C:/K/SemDB/ToolsPlus/d2rq-0.8.1/webapp/},webapp
de.fuberlin.wiwiss.d2rq.D2RQException: Relation name "dbo.Zi“ojumi" is
not in "[schema.]table" notation (E44)
at de.fuberlin.wiwiss.d2rq.sql.SQL.parseRelationName(SQL.java:132)
at de.fuberlin.wiwiss.d2rq.sql.SQL.parseAlias(SQL.java:151)
at
de.fuberlin.wiwiss.d2rq.map.ResourceMap.aliases(ResourceMap.java:159)
at
de.fuberlin.wiwiss.d2rq.map.ResourceMap.buildNodeMaker(ResourceMap.ja
va:206)
at
de.fuberlin.wiwiss.d2rq.map.ResourceMap.nodeMaker(ResourceMap.java:19
3)
...
dbo.Ziņojumi is actually a table, and when I edit out the table itself
and all references to it, the error message changes.
2. Trying to pin the issue down, the following script gives empty
mapping (just prefixes and database connection information)
generate-mapping -u sa -p xx -d
com.microsoft.sqlserver.jdbc.SQLServerDriver --tables Ziņojumi -o
outfileX1.ttl jdbc:sqlserver://AAA;databaseName=Bāze
(this behaviour seems to be independent from what table/tables I write
down, including ones that do not depend on anything else, and the tables
without any specific symbols in the name; the --skip-tables seems to be
likewise ignored (I get the full mapping)).
Does anyone have experience/examples of --tables parameter working?
Any ideas/workarounds regarding the special character 'ņ' (the mapping
file should be in UTF-8) not liked by d2rq-server?
P.S. Manually editing small fragments out of the mapping file, it is
possible to obtain at least snorql-browsable dataset.
Thanks a lot in advance!
Kārlis Čerāns
Institute of Mathematics and Computer Science, University of Latvia
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
