Hi
For some reason d2rq does not understand 'nvarchar' datatypes in MS
SQLServer 2005 database. I get the following error message, when I run
dump-rdf command or start d2rq-server:
"Unsupported database type code (-9) or type name ('nvarchar') for
column dbo.PlateCategories.Category (E75)"
I have just started to evaluate d2rq, so maybe this is just some
configuration problem. I am using the new version 0.8 of d2rq and Java
1.6 on Windows 7 (64bit) operating system.
The whole error trace is as follows:
C:\Special_Programs\LOD\d2rq\d2rq-0.8>d2r-server plibmap_ed2.ttl
18:30:05 INFO Server :: jetty-8.1.1.v20120215
18:30:05 INFO StandardDescriptorProcessor :: NO JSP Support for , did
not find
org.apache.jasper.servlet.JspServlet
18:30:05 INFO ContextHandler :: started
o.e.j.w.WebAppContext{,file:/C:/S
pecial_Programs/LOD/d2rq/d2rq-0.8/webapp/},webapp
18:30:05 INFO ContextHandler :: started
o.e.j.w.WebAppContext{,file:/C:/S
pecial_Programs/LOD/d2rq/d2rq-0.8/webapp/},webapp
18:30:05 INFO D2RServer :: using config file:
file:/C:/Special_Progr
ams/LOD/d2rq/d2rq-0.8/plibmap_ed2.ttl
18:30:06 WARN WebAppContext :: Failed startup of context
o.e.j.w.WebAppC
ontext{,file:/C:/Special_Programs/LOD/d2rq/d2rq-0.8/webapp/},webapp
de.fuberlin.wiwiss.d2rq.D2RQException: Unsupported database type code
(-9) or ty
pe name ('nvarchar') for column dbo.Plates.Description (E75)
at
de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.columnType(ConnectedDB.java:4
69)
at
de.fuberlin.wiwiss.d2rq.map.Mapping$AttributeTypeValidator.validate(M
apping.java:189)
at de.fuberlin.wiwiss.d2rq.map.Mapping.validate(Mapping.java:100)
at de.fuberlin.wiwiss.d2rq.GraphD2RQ.<init>(GraphD2RQ.java:84)
at de.fuberlin.wiwiss.d2rq.GraphD2RQ.<init>(GraphD2RQ.java:73)
at de.fuberlin.wiwiss.d2rq.ModelD2RQ.<init>(ModelD2RQ.java:60)
at
de.fuberlin.wiwiss.d2rq.server.AutoReloadableDataset.initD2RQDatasetG
raph(AutoReloadableDataset.java:86)
at
de.fuberlin.wiwiss.d2rq.server.AutoReloadableDataset.forceReload(Auto
ReloadableDataset.java:58)
at
de.fuberlin.wiwiss.d2rq.server.D2RServer.start(D2RServer.java:224)
at
de.fuberlin.wiwiss.d2rq.server.WebappInitListener.contextInitialized(
WebappInitListener.java:36)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialize
d(ContextHandler.java:764)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialize
d(ServletContextHandler.java:406)
at
org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextH
andler.java:756)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletC
ontextHandler.java:242)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.jav
a:1213)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandle
r.java:699)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:454
)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLife
Cycle.java:59)
at
org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrappe
r.java:90)
at org.eclipse.jetty.server.Server.doStart(Server.java:263)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLife
Cycle.java:59)
at
de.fuberlin.wiwiss.d2rq.server.JettyLauncher.start(JettyLauncher.java
:72)
at d2rq.server.startServer(server.java:85)
at d2rq.server.main(server.java:56)
18:30:06 INFO AbstractConnector :: Started
[email protected]:20
20
18:30:06 INFO ContextHandler :: stopped
o.e.j.w.WebAppContext{,file:/C:/S
pecial_Programs/LOD/d2rq/d2rq-0.8/webapp/},webapp
18:30:06 WARN server :: [[[ Server startup failed, see
messages a
bove ]]]
Please, can somebody help me to get over this problem? Most of my DB
columns in SQLServer are of type 'nvarchar(255)'
Thanks
Pekka
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
