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/Eclipse Workspace/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/Eclipse Workspace/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

Reply via email to