Hi Pekka, I looked into this and think I found the issue, the type name comparison in the code expects to get an upper-case type name from the JDBC driver, but your driver is reporting it in lower-case. The fix is simple and obvious -- normalize case before comparing. We'll squeeze the fix in for the upcoming v0.8.1 release, which should be out any minute now.
We're tracking this issue here: https://github.com/d2rq/d2rq/issues/145 As a temporary workaround, you should be able to add something like this to the d2rq:Database block in your mapping file: d2rq:textColumn "dbo.PlateCategories.Category"; Best, Richard On 25 Apr 2012, at 10:18, Pekka Aarnio wrote: > 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 ------------------------------------------------------------------------------ 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
