search

ontopia / ontopia

The open source tools for building, maintaining and deploying Topic Maps-based applications.
https://ontopia.net
Apache License 2.0
54 stars 12 forks source link

SQL server and RDBMS tolog produces error: Descriptor for type class java.lang.String not found. #431

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
1. Re-tested this using the Opera TM. The query:

Using SQL Server 2008 with the following config:
net.ontopia.topicmaps.impl.rdbms.Database=sqlserver
net.ontopia.topicmaps.impl.rdbms.ConnectionString=jdbcspy:jdbc:sqlserver://bisvm
s40;databaseName=italianopera;integratedSecurity=true;lockTimeout=60000;
net.ontopia.topicmaps.impl.rdbms.DriverClass=com.microsoft.sqlserver.jdbc.SQLSer
verDriver
net.ontopia.topicmaps.impl.rdbms.ConnectionPool=true
net.ontopia.topicmaps.impl.rdbms.BatchUpdates=true
net.ontopia.infoset.fulltext.impl.rdbms.RDBMSSearcher.type=sqlserver
net.ontopia.topicmaps.query.core.QueryProcessorIF=rdbms

The query used:

name($topic, $value, $type) :-
topic-name($topic, $name)
, type($name, $type)
, value($name, $value)
.

select $character, $voice, $appearsInNameValue
from direct-instance-of($character, i"http://psi.ontopedia.net/Character")
, i"http://psi.ontopedia.net/has_voice"($character: 
i"http://psi.ontopedia.net/Character", $voice: 
i"http://psi.ontopedia.net/Voice_type")
, i"http://psi.ontopedia.net/appears_in"($character: 
i"http://psi.ontopedia.net/Character", $appearsIn: 
i"http://psi.ontopedia.net/Work")
, name($appearsIn, $appearsInNameValue, 
i"http://psi.topicmaps.org/iso13250/model/topic-name")
, $appearsInNameValue = "La battaglia di Legnano"
, $voice = i"http://psi.ontopedia.net/Tenor"
?

Expected a result set, received an error.

Error log:

Stack Trace of root cause is:
net.ontopia.utils.OntopiaRuntimeException: Descriptor for type class 
java.lang.String not found.
          at net.ontopia.persistence.proxy.RDBMSMapping.getClassInfo(RDBMSMapping.java:44)
          at net.ontopia.persistence.query.sql.SQLBuilder$BuildInfo.createNamedValueTable(SQLBuilder.java:156)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceVariable(SQLBuilder.java:1632)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceValue(SQLBuilder.java:1310)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceEquals(SQLBuilder.java:949)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceExpression(SQLBuilder.java:769)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceExpressions(SQLBuilder.java:917)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceAnd(SQLBuilder.java:888)
          at net.ontopia.persistence.query.sql.SQLBuilder.produceExpression(SQLBuilder.java:812)
          at net.ontopia.persistence.query.sql.SQLBuilder.makeQuery(SQLBuilder.java:531)
          at net.ontopia.persistence.proxy.RDBMSStorage.createQuery(RDBMSStorage.java:531)
          at net.ontopia.persistence.proxy.RDBMSAccess.createQuery(RDBMSAccess.java:423)
          at net.ontopia.persistence.proxy.AbstractTransaction.createQuery(AbstractTransaction.java:478)
          at net.ontopia.topicmaps.query.impl.rdbms.ParsedQuery.compileQuery(ParsedQuery.java:250)
          at net.ontopia.topicmaps.query.impl.rdbms.ParsedQuery.(ParsedQuery.java:113)
          at net.ontopia.topicmaps.query.impl.rdbms.QueryProcessor.parseQuery(QueryProcessor.java:139)
          at net.ontopia.topicmaps.query.impl.rdbms.QueryProcessor.parse(QueryProcessor.java:116)
          at org.apache.jsp.plugins.query.query_jsp._jspService(query_jsp.java:203)
          at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
          at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
          at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
          at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
          at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
          at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
          at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
          at java.lang.Thread.run(Thread.java:662)

Original issue reported on code.google.com by Combal...@gmail.com on 18 Nov 2011 at 1:47

GoogleCodeExporter commented 9 years ago

Original comment by qsieb...@gmail.com on 18 Nov 2011 at 1:59

GoogleCodeExporter commented 9 years ago

Original comment by qsieb...@gmail.com on 18 Nov 2011 at 2:00