Dileepa, If you run dump-ref like this, it will set up a temporary in-memory HSQLDB database. This will only work if your SQL dump is compatible with HSQLDB. If it’s a MySQL dump or an Oracle dump, for example, then most likely it won’t work because of syntax differences.
I can’t say for sure if that is the problem in your case. If you could tell us how you produced the SQL dump, and what’s on line 22, then maybe I can help better. But the best thing is probably to run dump-rdf against a real database server, using the JDBC connection option, rather than with the -l option. Best, Richard On 12 Dec 2013, at 10:17, Dileepa Jayakody <dileepajayak...@gmail.com> wrote: > Hi All, > > I'm Dileepa, a Sri Lankan research student interested in linked-data and > semantic web domains and currently testing D2R server to convert relational > data into RDF. > > I have downloaded d2rq-0.8.1 server [1] and tried running dump-rdf tool to > convert my sql dump to rdf. > > The command I ran : d2rq-0.8.1/dump-rdf -l org_data.sql -o output.nt > When I execute above I always get an error like this : > > Error importing org_data.sql in line 22: unknown token: (E79) > > I noticed that when I remove the ";" (semi-colon) characted of the sql > statements, the tool skips to the next line which has a ";" to give the same > error. > > I downloaded the iswc-mysql.sql[2] example sql-dump and got the same error > during execution. > > Is this a bug in the tool? Can someone please suggest the way forward to > convert a sql dump to rdf? > > Thanks, > Dileepa > > [1] https://github.com/downloads/d2rq/d2rq/d2rq-0.8.1.tar.gz > [2] http://d2rq.org/example/iswc-mysql.sql > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk_______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
