Hi Quentin, We are looking into this issue ...
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 1 Dec 2015, at 09:04, Quentin <quentin@guidinghand.solutions> wrote: > > Hi, > > I'm encountering some errors accessing Virtuoso7 via odbc. The actual > error varies depending on the release but the below error occurs with > the latest stable7. > > $ virtuoso-t -? > Virtuoso Open Source Edition (Column Store) (multi threaded) > Version 7.2.1.3214-pthreads as of Dec 1 2015 > Compiled for Linux (x86_64-unknown-linux-gnu) > Copyright (C) 1998-2015 OpenLink Software > > The same error occurs under develop7 as well as the next older release > of stable7. An older v6 driver against a v7 DB worked for the below > query but had an unrelated buffer-underrun issue with blobs (exposing > Apache's heap concatenated after the blob truncated to 4072 characters). > > The actual error given is: "VD032: remote prepare: SQ200: No column > t2.P.Complete." > Running the DB in foreground/debug mode doesn't give any more > information. The query and its result are shown here: > ********************* > 05:15:04 INFO: COMP_2 dba XX.XX.XX.XX 1111:1 Compile text: SPARQL > SELECT ?Object ?PredLabel > FROM <Test/> > WHERE { > ?S ?P ?Object > FILTER (?S = <Subject1>) > { SELECT ?P ?PredLabel > FROM <Test/Ontologies/> > WHERE { > ?P rdfs:label ?PredLabel . > } } > } ORDER BY ?ObjectLabel LIMIT 100 > 05:15:04 INFO: ERRS_0 S0022 SQ200 No column t2.P. > 05:15:04 INFO: ERRS_0 S0022 VD032 remote prepare: SQ200: No column t2.P. > ********************* > > The presence or absence of triples in query results is irrelevant to the > error. The query executes normally via isql and conductor. > Assuming that PHP is configured for odbc, the script at the bottom of > the post is sufficient to cause the error: > > Aside from assistance with the error in question, could I get some > guidance on the 'correct' way to build or extract odbc drivers from a > Virtuoso release? Or, given Ubuntu 14.04LTS, should I be using drivers > from the iodbc package? It's possible that the error is due to an > incorrect odbc configuration or driver and I'd like to check what I'm > supposed to be doing there. > > Quentin. > ********************* > <?php > > // Main > function main() { > $db_user = 'dba'; > $db_pass = 'dba'; > $dsn = 'testv7Stable'; > $cursor = SQL_CUR_USE_DRIVER; > > echo "Opening DB.\n"; > $dbCon = odbc_connect($dsn, $db_user, $db_pass, $cursor); > > echo "DB open.\n"; > $insertQuery1 = "SPARQL > WITH <Test/Ontologies/> > INSERT { > <Pred1> rdfs:label \"Test Predicate\" . > }"; > $insertQuery2 = "SPARQL > WITH <Test/> > > INSERT { > <Subject1> <Pred1> \"Test Object\" . > }"; > $testQuery = "SPARQL > SELECT ?Object ?PredLabel > FROM <Test/> > WHERE { > ?S ?P ?Object > FILTER (?S = <Subject1>) > { SELECT ?P ?PredLabel > FROM <Test/Ontologies/> > WHERE { > ?P rdfs:label ?PredLabel . > } } > } ORDER BY ?ObjectLabel LIMIT 100"; > $delete1 = "SPARQL DROP SILENT GRAPH <Test/>"; > $delete2 = "SPARQL DROP SILENT GRAPH <Test/Ontologies/>"; > $cur = (odbc_exec($dbCon, $insertQuery1)); > $cur = (odbc_exec($dbCon, $insertQuery2)); > > $cur = (odbc_exec($dbCon, $testQuery)); > if (!odbc_error($dbCon)) { > echo "Test passed.\n"; > } else { > echo "Test failed.\n"; > echo odbc_errormsg($dbCon); > } > $cur = (odbc_exec($dbCon, $delete1)); > $cur = (odbc_exec($dbCon, $delete2)); > @odbc_close($dbCon); > } > > > echo "Starting.\n"; > main(); > echo "Complete.\n"; > ?> > > ------------------------------------------------------------------------------ > Go from Idea to Many App Stores Faster with Intel(R) XDK > Give your users amazing mobile app experiences with Intel(R) XDK. > Use one codebase in this all-in-one HTML5 development environment. > Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. > http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
