Hello,
I have defined a D2RQ mapping with MySQL Database. It works well in TBCME
(TBCME - Version: 4.3.0.v20130605-1444B-master , Windows 7). When I open
the XXXX-DataView.ttl graph with the "SWA default application", I can
display classes but I get an error when I try to display instances. I have
attached the error log file.
Thanks for your help
Jamal
--
-- You received this message because you are subscribed to the Google
Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary
Network (EVN), TopBraid Composer, TopBraid Live,
TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-users?hl=en
---
You received this message because you are subscribed to the Google Groups
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
eclipse.buildId=unknown
java.version=1.6.0_26
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=fr_FR
Command-line arguments: -os win32 -ws win32 -arch x86
Error
Thu Aug 01 09:53:25 CEST 2013
Exception in SWP Servlet
java.io.IOException: Failed to execute SWP engine
at org.topbraid.spin.swp.engine.XMLEngine.run(XMLEngine.java:103)
at
org.topbraid.spin.swp.servlet.SWPServletUtil.runUncached(SWPServletUtil.java:677)
at
org.topbraid.spin.swp.servlet.SWPServletUtil.run(SWPServletUtil.java:474)
at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:162)
at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:140)
at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:123)
at org.topbraidlive.swp.servlet.SWPServlet.doPost(SWPServlet.java:69)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at
org.topbraid.eclipsex.servlet.TBHttpServlet.service(TBHttpServlet.java:115)
at
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:586)
Caused by: java.lang.IllegalArgumentException: Failed to construct SWP argument
http://uispin.org/letrs#results at template
<ui:group let:queryGraph="{= spl:object(?search, search:queryGraph) }"
letrs:results="{#
SELECT ?result ?totalCount
WHERE {
( ?search ?startIndex ?rows ?sortProperty ?desc ) search:result (
?result ?totalCount ) .
} }">
<swon:Object let:totalCount="{= spr:cell(?results, 0, 1) }">
<ui:setContext let:floor="{= floor((?totalCount / ?rows)) }"
ui:queryGraph="{= ?queryGraph }">
<swon:NameValuePair arg:comma="true" arg:name="page" arg:value="{=
?page }"/>
<swon:NameValuePair arg:comma="true" arg:name="records"
arg:value="{= ?totalCount }"/>
<swon:NameValuePair arg:comma="true" arg:name="total" arg:value="{=
IF(((?floor * ?rows) < ?totalCount), (?floor + 1), ?floor) }"/>
"rows" : [
<ui:if ui:condition="{= ?totalCount
> 0 }">
<ui:forEach ui:resultSet="{= ?results }" ui:separator=",">
<swon:Object>
<swon:NameValuePair arg:comma="true" arg:name="id"
arg:value="{= IF(isIRI(?result), ?result, swa:bnodeId(?result)) }"/>
"cell" :
<ui:if ui:condition="{= EXISTS {
GRAPH ?searchGraph {
?search spin:column ?anyColumn .
} .
} }">
<swon:RSArray arg:resultSet='{#
SELECT ?label
WHERE {
{
BIND (ui:label(?result) AS ?label) .
BIND (-1 AS ?columnIndex) .
}
UNION
{
GRAPH ?searchGraph {
?search spin:column ?column .
?column spin:columnIndex
?columnIndex .
?column search:columnProperty
?keyProperty .
} .
BIND (spl:object(?result,
?keyProperty) AS ?value) .
BIND (IF(bound(?value),
ui:label(?value), "") AS ?label) .
} .
}
ORDER BY (?columnIndex) }'/>
</ui:if>
<ui:else>
<swon:RSArray arg:resultSet="{#
SELECT ?label
WHERE {
BIND (ui:label(?result) AS ?label) .
} }"/>
</ui:else>
</swon:Object>
</ui:forEach>
</ui:if>
]</ui:setContext>
</swon:Object>
</ui:group>
in query SELECT ?result ?totalCount
WHERE
{ _:b0 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?search .
_:b0 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest> _:b1 .
_:b1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?startIndex .
_:b1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest> _:b2 .
_:b2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?rows .
_:b2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest> _:b3 .
_:b3 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?sortProperty .
_:b3 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest> _:b4 .
_:b4 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?desc .
_:b4 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#nil> .
_:b0 <http://topbraid.org/search#result> _:b5 .
_:b5 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?result .
_:b5 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest> _:b6 .
_:b6 <http://www.w3.org/1999/02/22-rdf-syntax-ns#first> ?totalCount .
_:b6 <http://www.w3.org/1999/02/22-rdf-syntax-ns#rest>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#nil>
}
at
org.topbraid.spin.swp.engine.SWPEngine.evaluateQueryArguments(SWPEngine.java:850)
at
org.topbraid.spin.swp.engine.SWPEngine.evaluateArguments(SWPEngine.java:741)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:499)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:488)
at
org.topbraid.spin.swp.engine.SWPEngine.addChildNodes(SWPEngine.java:288)
at
org.topbraid.spin.swp.engine.control.internal.GroupControlElement.run(GroupControlElement.java:20)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:529)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:488)
at
org.topbraid.spin.swp.engine.SWPEngine.addChildNodes(SWPEngine.java:288)
at
org.topbraid.spin.swp.engine.control.internal.SetContextControlElement.run(SetContextControlElement.java:81)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:529)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodesFromPrototype(SWPEngine.java:610)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:524)
at
org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:488)
at org.topbraid.spin.swp.engine.SWPEngine.run(SWPEngine.java:1107)
at org.topbraid.spin.swp.engine.XMLEngine.run(XMLEngine.java:97)
... 27 more
Caused by: de.fuberlin.wiwiss.d2rq.D2RQException: Streaming result set
com.mysql.jdbc.RowDataDynamic@11c3b04 is still active. No statements may be
issued when any streaming result sets are open and in use on a given
connection. Ensure that you have called .close() on any active streaming result
sets before attempting more queries.: SELECT `journalarticle`.`id_` FROM
`journalarticle` WHERE (`journalarticle`.`id_` = 10584 AND
`journalarticle`.`id_` IS NOT NULL) (E0)
at
de.fuberlin.wiwiss.d2rq.sql.SQLIterator.ensureQueryExecuted(SQLIterator.java:165)
at de.fuberlin.wiwiss.d2rq.sql.SQLIterator.hasNext(SQLIterator.java:54)
at
de.fuberlin.wiwiss.d2rq.engine.QueryIterTableSQL.hasNextBinding(QueryIterTableSQL.java:90)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterConcat.hasNextBinding(QueryIterConcat.java:83)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
de.fuberlin.wiwiss.d2rq.find.TripleQueryIter.hasNext(TripleQueryIter.java:31)
at
com.hp.hpl.jena.util.iterator.NiceIterator$1.hasNext(NiceIterator.java:104)
at
com.hp.hpl.jena.util.iterator.WrappedIterator.hasNext(WrappedIterator.java:76)
at
com.hp.hpl.jena.util.iterator.WrappedIterator.hasNext(WrappedIterator.java:76)
at
com.hp.hpl.jena.util.iterator.FilterIterator.hasNext(FilterIterator.java:55)
at
com.hp.hpl.jena.util.iterator.NiceIterator$1.hasNext(NiceIterator.java:104)
at
org.topbraid.jenax.iterator.TellStopIterator.hasNext(TellStopIterator.java:31)
at
com.hp.hpl.jena.util.iterator.WrappedIterator.hasNext(WrappedIterator.java:76)
at
com.hp.hpl.jena.util.iterator.FilterIterator.hasNext(FilterIterator.java:55)
at
com.hp.hpl.jena.graph.compose.CompositionBase$2.hasNext(CompositionBase.java:98)
at
com.hp.hpl.jena.util.iterator.NiceIterator$1.hasNext(NiceIterator.java:104)
at
com.hp.hpl.jena.util.iterator.WrappedIterator.hasNext(WrappedIterator.java:76)
at org.topbraid.spin.swp.util.LabelUtil.getLabel(LabelUtil.java:49)
at
org.topbraid.spin.swp.functions.LabelFunction.getResourceLabel(LabelFunction.java:114)
at
org.topbraid.spin.swp.functions.LabelFunction.getLabel(LabelFunction.java:107)
at
org.topbraid.spin.swp.functions.LabelFunction.exec(LabelFunction.java:78)
at
com.hp.hpl.jena.sparql.expr.E_Function.evalSpecial(E_Function.java:71)
at
com.hp.hpl.jena.sparql.expr.ExprFunctionN.eval(ExprFunctionN.java:102)
at com.hp.hpl.jena.sparql.core.VarExprList.get(VarExprList.java:82)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterAssign.accept(QueryIterAssign.java:68)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterProcessBinding.hasNextBinding(QueryIterProcessBinding.java:64)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
org.openjena.atlas.data.AbstractDataBag.addAll(AbstractDataBag.java:74)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort$SortedBindingIterator.initializeIterator(QueryIterSort.java:89)
at
org.openjena.atlas.iterator.IteratorDelayedInitialization.init(IteratorDelayedInitialization.java:37)
at
org.openjena.atlas.iterator.IteratorDelayedInitialization.hasNext(IteratorDelayedInitialization.java:47)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterPlainWrapper.hasNextBinding(QueryIterPlainWrapper.java:54)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterConvert.hasNextBinding(QueryIterConvert.java:59)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterDistinctReduced.hasNextBinding(QueryIterDistinctReduced.java:54)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:40)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:40)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.ResultSetStream.hasNext(ResultSetStream.java:72)
at
org.topbraid.spin.swp.search.engine.sparql.SPARQLSearchEngine.executeSearch(SPARQLSearchEngine.java:79)
at
org.topbraid.spin.swp.search.functions.SearchResultPFunction.exec(SearchResultPFunction.java:75)
at
com.hp.hpl.jena.sparql.pfunction.PropertyFunctionBase$RepeatApplyIteratorPF.nextStage(PropertyFunctionBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:113)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:65)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterProcedure.hasNextBinding(QueryIterProcedure.java:74)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIterConvert.hasNextBinding(QueryIterConvert.java:59)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:40)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:40)
at
com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:108)
at
com.hp.hpl.jena.sparql.engine.ResultSetStream.hasNext(ResultSetStream.java:72)
at
org.topbraid.spin.swp.internal.sprn.SPRNTable.<init>(SPRNTable.java:37)
at
org.topbraid.spin.swp.internal.sprn.SPRNTables.register(SPRNTables.java:101)
at
org.topbraid.spin.swp.engine.SWPEngine.addSPRTable(SWPEngine.java:395)
at
org.topbraid.spin.swp.engine.SWPEngine.evaluateQueryArguments(SWPEngine.java:819)
... 42 more
