Loading error from command-line
I got a crash trying to load from command line , a simple .nt file that is used with no problems in many quotientSummary tests. The problem appears due to the presence of - in the file (thus database) name. I am wondering if the error is within quotientSummary or rdfdb (not sure).
[223-135:~/GITLAB/quotientSummary] ioanamanolescu% java -cp target/quotientSummaryWithDependencies-1.6-SNAPSHOT.jar fr.inria.cedar.quotientSummary.controller.BuilderCmd load src/test/resources/rdf-nt-files/test-8.nt false true
14:09:45,940 INFO BuilderCmd:242 - Loading graph to Postgres 14:09:45,968 INFO DataLoading:173 - Loading configuration... 14:09:45,971 INFO DataLoading:119 - Creating database test-8 and loading triples... 14:09:45,974 INFO DataLoading:173 - Loading configuration...
14:09:46,084 INFO LoadTriplesToDatabase:119 - Creating (or dropping and re-creating) database org.postgresql.util.PSQLException: ERROR: syntax error at or near "-"
Position: 21 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:33) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.createDatabase(LoadTriplesToDatabase.java:131) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.createDatabase(LoadTriplesToDatabase.java:83) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.process(LoadTriplesToDatabase.java:66) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:121) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:114) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.processWithoutPreProcessing(DataLoading.java:102) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:89) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.load(BuilderCmd.java:244) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.main(BuilderCmd.java:103) org.postgresql.util.PSQLException: FATAL: database "test-8" does not exist at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:582) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:185) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init (AbstractJdbc2Connection.java:144) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:29) at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:21) at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:31) at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:410) at org.postgresql.Driver.connect(Driver.java:280) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:99) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82) at fr.inria.cedar.ontosql.db.PostgresDataSource.getConnection(PostgresDataSource.java:47) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.start(LoadTriplesToDatabase.java:165) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.start(LoadTriplesToDatabase.java:181) at fr.inria.cedar.ontosql.rdfdb.dataloading.LoadTriplesToDatabase.process(LoadTriplesToDatabase.java:74) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:121) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:114) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.processWithoutPreProcessing(DataLoading.java:102) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:89) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.load(BuilderCmd.java:244) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.main(BuilderCmd.java:103) 14:09:46,096 INFO DataLoading:122 - Data loaded
14:09:46,096 INFO DataLoading:124 - Encoding dictionary...
14:09:46,101 ERROR Runner:57 - FATAL: database "test-8" does not exist
org.postgresql.util.PSQLException: FATAL: database "test-8" does not exist
at
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:582) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:185) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:144) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:29) at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:21) at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:31) at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:410) at org.postgresql.Driver.connect(Driver.java:280) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:99) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82) at fr.inria.cedar.ontosql.db.PostgresDataSource.getConnection(PostgresDataSource.java:47) at fr.inria.cedar.ontosql.rdfdb.dictionaryencoder.RDFGraphDictionaryEncoder.start(RDFGraphDictionaryEncoder.java:131) at fr.inria.cedar.ontosql.rdfdb.dictionaryencoder.RDFGraphDictionaryEncoder.process(RDFGraphDictionaryEncoder.java:73) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:125) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:114) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.processWithoutPreProcessing(DataLoading.java:102) at fr.inria.cedar.ontosql.rdfdb.dataloading.DataLoading.process(DataLoading.java:89) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.load(BuilderCmd.java:244) at fr.inria.cedar.quotientSummary.controller.BuilderCmd.main(BuilderCmd.java:103)