Hi,
Just a quick update to let you know that a fix for this is in trunk, and will
be in the v0.8.1 release. Now, the mapping generator will generate two
different property bridge names for the two columns, for example:
map:MGMT_BSLN_DATASOURCES_TARGET_UID
map:MGMT_BSLN_DATASOURCES_TARGET__UID
Best,
Richard
On 22 May 2012, at 00:49, Richard Cyganiak wrote:
> Probably the D2RQ mapping generator accidentally generated the same property
> bridge ID for two different columns. This can happen when you have two
> different columns in two different tables with almost the same name, perhaps:
>
> MGMT_BSLN_DATASOURCES.TARGET_UID
> MGMT_BSLN_DATASOURCES_TARGET.UID
>
> The mapping generator apparently generates the same ID
> “map:MGMT_BSLN_DATASOURCES_TARGET_UID” for both.
>
> In D2RQ v0.8, the best you can do really is to find some way to open the
> mapping file in a text editor, find the two property bridge definitions, and
> change one of them to use a different ID, like
> “map:MGMT_BSLN_DATASOURCES_TARGET_UID2” for example.
>
> In the upcoming D2RQ v0.8.1 it will be possible to exclude selected tables
> and columns when running the mapping generator (using the --skip-tables
> option for example). But that's not yet released.
>
> Best,
> Richard
>
>
> On 21 May 2012, at 23:46, Young Soo Song wrote:
>
>> Hi,
>>
>>
>>
>> We autogenerate a mapping file from oracle db, whose size is about 50M.
>>
>> When we ran a server, the following error came out.
>>
>> I wonder why those errors occured. Does it mean that there are two
>> d2rq:column with the same value?
>>
>> Because the mapping file is over 50MB. It's hard to open it.
>>
>> I'm afraid that it's not working well after fixing those problems.
>>
>> Thanks.
>>
>>
>>
>> Young Soo Song
>>
>>
>>
>>
>>
>> 17:24:34 INFO Server :: jetty-8.1.1.v20120215
>> 17:24:35 INFO StandardDescriptorProcessor :: NO JSP Support for , did not
>> find org.apache.jasper.servlet.JspServlet
>> 17:24:35 INFO ContextHandler :: started
>> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
>> 17:24:35 INFO ContextHandler :: started
>> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
>> 17:24:35 INFO D2RServer :: using config file:
>> file:/var/d2rq/v0.8/oakoracle.ttl
>> 17:24:53 WARN WebAppContext :: Failed startup of context
>> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
>> de.fuberlin.wiwiss.d2rq.D2RQException: Duplicate d2rq:column for
>> d2rq:PropertyBridge map:MGMT_BSLN_DATASOURCES_TARGET_UID (E16)
>> at
>> de.fuberlin.wiwiss.d2rq.map.MapObject.assertNotYetDefined(MapObject.java:36)
>> at
>> de.fuberlin.wiwiss.d2rq.map.PropertyBridge.setColumn(PropertyBridge.java:55)
>> at
>> de.fuberlin.wiwiss.d2rq.parser.MapParser.parsePropertyBridge(MapParser.java:499)
>> at
>> de.fuberlin.wiwiss.d2rq.parser.MapParser.parsePropertyBridges(MapParser.java:486)
>> at de.fuberlin.wiwiss.d2rq.parser.MapParser.parse(MapParser.java:104)
>> 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.initD2RQDatasetGraph(AutoReloadableDataset.java:86)
>> at
>> de.fuberlin.wiwiss.d2rq.server.AutoReloadableDataset.forceReload(AutoReloadableDataset.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.callContextInitialized(ContextHandler.java:764)
>> at
>> org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
>> at
>> org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:756)
>> at
>> org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
>> at
>> org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1213)
>> at
>> org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:699)
>> at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:454)
>> at
>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
>> at
>> org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
>> at org.eclipse.jetty.server.Server.doStart(Server.java:263)
>> at
>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.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)
>> 17:24:53 INFO AbstractConnector :: Started
>> [email protected]:2020
>> 17:24:53 INFO ContextHandler :: stopped
>> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
>> 17:24:53 WARN server :: [[[ Server startup failed, see
>> messages above ]]]
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
------------------------------------------------------------------------------
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
