Hi David,
So that we can see what's happening, please substitute all relative paths
by absolute paths (starting with / and without ..).
Please also send along your e-mail the results of the commands "pwd" and
"ls -lah" (for your data directory).
Cheers
Pablo
On Jul 10, 2012 11:45 PM, "David Gösenbauer" <[email protected]>
wrote:
> Hey Folks!
>
> I seem to have correctly linked all the required data in my
> server.properties file:
> --------------------------
>
> *org.dbpedia.spotlight.web.rest.uri = http://localhost:2222/rest
> org.dbpedia.spotlight.index.dir = ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/index-withSF-withTypes-compressed/
> org.dbpedia.spotlight.spot.dictionary = ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/spotter.large.dict
> jcs.default.cacheattributes.MaxObjects = 5000
> org.dbpedia.spotlight.tagging.hmm = ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/pos-en-general-brown.HiddenMarkovModel
>
> org.dbpedia.spotlight.sparql.endpoint = http://dbpedia.org/sparql
> org.dbpedia.spotlight.sparql.graph = http://dbpedia.org
>
> # Configurations for the CoOccurrenceBasedSelector
> # From:
> http://spotlight.dbpedia.org/download/release-0.5/spot_selector.tgz
> org.dbpedia.spotlight.spot.cooccurrence.datasource = ukwac
> org.dbpedia.spotlight.spot.cooccurrence.database.jdbcdriver =
> org.hsqldb.jdbcDriver
> org.dbpedia.spotlight.spot.cooccurrence.database.connector = jdbc:hsqldb:
> file:/release-0.5-data/spotsel/ukwac_candidate;shutdown=true&readonly=true
> org.dbpedia.spotlight.spot.cooccurrence.database.user = sa
> org.dbpedia.spotlight.spot.cooccurrence.database.password =
> org.dbpedia.spotlight.spot.cooccurrence.classifier.unigram =
> ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/spotsel/ukwac_unigram.model
> org.dbpedia.spotlight.spot.cooccurrence.classifier.ngram =
> ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/spotsel/ukwac_ngram.model
>
> org.dbpedia.spotlight.spot.spotters =
> LingPipeSpotter,AtLeastOneNounSelector,CoOccurrenceBasedSelector,NESpotter
>
> org.dbpedia.spotlight.spot.opennlp.dir = ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/opennlp
>
> # Info for context searcher
> org.dbpedia.spotlight.language = English
> org.dbpedia.spotlight.lucene.analyzer = SnowballAnalyzer
> **
> # Choose between jdbc or lucene for DBpedia Resource creation. Also, if
> the jdbc throws an error, lucene will be used.
> org.dbpedia.spotlight.core.database = jdbc
> org.dbpedia.spotlight.core.database.jdbcdriver = org.hsqldb.jdbcDriver
> org.dbpedia.spotlight.core.database.connector = jdbc:hsqldb:
> file:/../../Work/EclipseWorkspace/DBpedia_Spotlight_0.5/release-0.5-data/spotlight-db;shutdown=true&readonly=true
> org.dbpedia.spotlight.core.database.user = sa
> org.dbpedia.spotlight.core.database.password =
>
> # From
> http://spotlight.dbpedia.org/download/release-0.5/candidate-index-full.tgz
> org.dbpedia.spotlight.candidateMap.dir = ../../Work/Eclipse
> Workspace/DBpedia_Spotlight_0.5/release-0.5-data/candidateIndexTitRedDis *
>
> --------------------------
> Nevertheless I get an SQL-Exception preventing the build to succeed:
> --------------------------
>
> *WARN 2012-07-10 23:34:10,162 main [SpotlightConfiguration] - Tried to
> use core
> database provided, but failed. Will use Lucene index as core database.
> java.sql.SQLException: Table not found in statement [select * from
> OntologyType]*
>
> --------------------------
> As I was told before I don't really need the spotlight-db and obviously it
> doesn't seem to be working after all but neither does Lucene. Somehow I
> can't figure out why this is so I have to ask you guys for help. Any advice
> is appreciated! Looking forward to it!
>
> Regards,
> David
>
> The whole log:
> --------------------------
> K:\dbpedia-spotlight-0.5\rest>mvn scala:run
> -DaddArgs=../conf/server.properties
> [INFO] Scanning for projects...
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Building DBpedia Spotlight RESTful API
> [INFO] task-segment: [scala:run]
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Preparing scala:run
> [INFO] [resources:resources {execution: default-resources}]
> [INFO] Using 'UTF-8' encoding to copy filtered resources.
> [INFO] skip non existing resourceDirectory
> K:\dbpedia-spotlight-0.5\rest\src\mai
> n\resources
> [INFO] [scala:add-source {execution: scala-compile-first}]
> [INFO] Add Source directory: K:\dbpedia-spotlight-0.5\rest\src\main\scala
> [INFO] Add Test Source directory:
> K:\dbpedia-spotlight-0.5\rest\src\test\scala
> [INFO] [scala:compile {execution: scala-compile-first}]
> [INFO] Checking for multiple versions of scala
> [INFO] includes = [**/*.scala,**/*.java,]
> [INFO] excludes = []
> [INFO] Nothing to compile - all classes are up to date
> [INFO] [compiler:compile {execution: default-compile}]
> [INFO] Nothing to compile - all classes are up to date
> [INFO] [resources:testResources {execution: default-testResources}]
> [INFO] Using 'UTF-8' encoding to copy filtered resources.
> [INFO] skip non existing resourceDirectory
> K:\dbpedia-spotlight-0.5\rest\src\tes
> t\resources
> [INFO] [compiler:testCompile {execution: default-testCompile}]
> [INFO] No sources to compile
> [INFO] [scala:run {execution: default-cli}]
> [INFO] Checking for multiple versions of scala
> [INFO] launcher 'Server' selected => org.dbpedia.spotlight.web.rest.Server
> WARN 2012-07-10 23:34:09,917 main [SpotlightConfiguration] - Cannot find
> stopwo
> rds file ''. Using default Lucene English StopWords.
> INFO 2012-07-10 23:34:10,062 main [SpotlightConfiguration] - Core
> database from
> JDBC:
> jdbc:hsqldb:file:/../../Work/EclipseWorkspace/DBpedia_Spotlight_0.5/rele
> ase-0.5-data/spotlight-db;shutdown=true&readonly=true
> WARN 2012-07-10 23:34:10,162 main [SpotlightConfiguration] - Tried to use
> core
> database provided, but failed. Will use Lucene index as core database.
> java.sql.SQLException: Table not found in statement [select * from
> OntologyType]
>
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
> at
> org.dbpedia.spotlight.model.DBpediaResourceFactorySQL.<init>(DBpediaR
> esourceFactory.scala:87)
> at
> org.dbpedia.spotlight.model.SpotlightConfiguration.createDBpediaResou
> rceFactory(SpotlightConfiguration.java:111)
> at
> org.dbpedia.spotlight.model.SpotlightConfiguration.<init>(SpotlightCo
> nfiguration.java:230)
> at org.dbpedia.spotlight.web.rest.Server.main(Server.java:70)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org_scala_tools_maven_executions.MainHelper.runMain(MainHelper.java:1
> 61)
> at
> org_scala_tools_maven_executions.MainWithArgsInFile.main(MainWithArgs
> InFile.java:26)
> INFO 2012-07-10 23:34:10,191 main [TermCache] - Setting the
> SurrogateCache.maxC
> acheSize to 5000
> INFO 2012-07-10 23:34:10,193 main [CompositeCacheManager] - Instance is
> null, c
> reating with provided config
> INFO 2012-07-10 23:34:10,193 main [CompositeCacheManager] - Instance is
> null, c
> reating with provided config
> INFO 2012-07-10 23:34:10,211 main [LRUMemoryCache] - initialized
> LRUMemoryCache
> for termCache
> INFO 2012-07-10 23:34:10,211 main [LRUMemoryCache] - initialized
> LRUMemoryCache
> for termCache
> INFO 2012-07-10 23:34:10,212 main [CompositeCache] - Constructed cache
> with nam
> e [termCache] and cache attributes [ useLateral = true, useRemote = true,
> useDis
> k = true, maxObjs = 100, maxSpoolPerRun = -1, diskUsagePattern = 0 ]
> INFO 2012-07-10 23:34:10,212 main [CompositeCache] - Constructed cache
> with nam
> e [termCache] and cache attributes [ useLateral = true, useRemote = true,
> useDis
> k = true, maxObjs = 100, maxSpoolPerRun = -1, diskUsagePattern = 0 ]
> DEBUG 2012-07-10 23:34:10,212 main [JCSTermCache] - Cache has been checked
> out 1
> times.
> INFO 2012-07-10 23:34:10,492 main [MergedOccurrencesContextSearcher] -
> Using in
> dex at: org.apache.lucene.store.SimpleFSDirectory@K:\Work\Eclipse
> Workspace\DBpe
> dia_Spotlight_0.5\release-0.5-data\index-withSF-withTypes-compressed
> DEBUG 2012-07-10 23:34:10,492 main [MergedOccurrencesContextSearcher] -
> Opening
> IndexSearcher and IndexReader for Lucene directory
> org.apache.lucene.store.Simpl
> eFSDirectory@K:\Work\Eclipse
> Workspace\DBpedia_Spotlight_0.5\release-0.5-data\in
> dex-withSF-withTypes-compressed ...
> DEBUG 2012-07-10 23:34:10,654 main [MergedOccurrencesContextSearcher] -
> Done.
> java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org_scala_tools_maven_executions.MainHelper.runMain(MainHelper.java:1
> 61)
> at
> org_scala_tools_maven_executions.MainWithArgsInFile.main(MainWithArgs
> InFile.java:26)
> Caused by: java.io.StreamCorruptedException: invalid stream header:
> 1F8B0808
> at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
> at java.io.ObjectInputStream.<init>(Unknown Source)
> at
> com.aliasi.util.AbstractExternalizable.readObject(AbstractExternaliza
> ble.java:309)
> at
> org.dbpedia.spotlight.spot.lingpipe.LingPipeSpotter.<init>(LingPipeSp
> otter.scala:53)
> at
> org.dbpedia.spotlight.model.SpotlightFactory$$anonfun$spotter$2.apply
> (SpotlightFactory.scala:82)
> at
> org.dbpedia.spotlight.model.SpotlightFactory$$anonfun$spotter$2.apply
> (SpotlightFactory.scala:82)
> at scala.collection.MapLike$class.getOrElse(MapLike.scala:122)
> at
> scala.collection.JavaConversions$JMapWrapper.getOrElse(JavaConversion
> s.scala:792)
> at
> org.dbpedia.spotlight.model.SpotlightFactory.spotter(SpotlightFactory
> .scala:82)
> at
> org.dbpedia.spotlight.model.SpotlightFactory$$anonfun$spotter$6.apply
> (SpotlightFactory.scala:98)
> at
> org.dbpedia.spotlight.model.SpotlightFactory$$anonfun$spotter$6.apply
> (SpotlightFactory.scala:97)
> at scala.collection.Iterator$class.foreach(Iterator.scala:660)
> at
> scala.collection.JavaConversions$JIteratorWrapper.foreach(JavaConvers
> ions.scala:573)
> at
> scala.collection.IterableLike$class.foreach(IterableLike.scala:73)
> at
> scala.collection.JavaConversions$JListWrapper.foreach(JavaConversions
> .scala:615)
> at
> org.dbpedia.spotlight.model.SpotlightFactory.spotter(SpotlightFactory
> .scala:97)
> at
> org.dbpedia.spotlight.model.SpotlightFactory.<init>(SpotlightFactory.
> scala:75)
> at org.dbpedia.spotlight.web.rest.Server.main(Server.java:81)
> ... 6 more
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] wrap: org.apache.commons.exec.ExecuteException: Process exited with
> an er
> ror: -10000(Exit value: -10000)
>
> [INFO]
> ------------------------------------------------------------------------
> [INFO] For more information, run Maven with the -e switch
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Total time: 2 seconds
> [INFO] Finished at: Tue Jul 10 23:34:10 CEST 2012
> [INFO] Final Memory: 25M/309M
> [INFO]
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> 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/
> _______________________________________________
> Dbp-spotlight-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dbp-spotlight-users
>
>
------------------------------------------------------------------------------
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/
_______________________________________________
Dbp-spotlight-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbp-spotlight-users