VOSNews Virtuoso Open Source Edition NewsVirtuoso Open Source Edition News 2022 News Announcements 2022-05-18 Virtuoso 7.2.7 Released, Open-Source Edition The Virtuoso engine has been enhanced to use 64-bit prefix IDs in RDF_IRI which allows for very large databases such as Uniprot, which currently contains over 90 billion triples, to be hosted using the Virtuoso Open Source engine.While new databases automatically make use of this important enhancement, existing databases will need to be upgraded. Please read our instructions to upgrade from 7.2.x to 7.2.7. Virtuoso Engine Added optimizations for clearing graph Added optimizations for deleting triples Added support for CONNECT to allow http proxy like squid to tunnel https:// requests Added support for OpenSSL 3.0.x Added support for cast epoch time back to date/datetime Added support for handling X-Forwarded-Proto header from proxy Added support to fine tune size of memory pool used by SPARQL constructs Added support to populate labels in insert for FCT Added optional digest name to aes key Added short name date BIF functions Added xenc digest and xenc_hmac_digest BIF functions Added unix_timestamp() BIF function Added support for handling HTTP status 307 and 308 in client Fixed Host header should include non-standard port. Fixed SQLConnect handling of empty strings in szDSN and szUID Fixed SSL_renegotiate for OpenSSL 1.1.x Fixed backup_online syntax Fixed calculations from TZ in minutes to +HHMM format Fixed check for https behind proxy for dynamic local Fixed crypto functions error codes Fixed issue calling external proxy with https address Fixed issue executing vec exec expression in WHERE clause Fixed issue generating triples from rdf view to physical store with rdfs:label property Fixed issue sorting NaN values in colstore Fixed issue with X509 CSR generation Fixed issue with backup restore and DDL from plugins Fixed issue with dsa and rsa keys when no cert is attached Fixed issue with registering tables in plugin Fixed issues with x509 extensions Fixed memory leak in colsearch Fixed missing index upgrading older databases Fixed possible box corruption printing a very long literals box Fixed return HTTP 503 even if MaintenancePage cannot be found Fixed serialize of AES IV Fixed subject should be written in UTF8 format Fixed trace to log warnings as WARN 0 instead of ERRS_0 Fixed when running as windows service, stderr is an invalid handle Removed redundant checkpoints when creating new database Small cleanups SPARQL Added optimizations for clearing graph Added optimizations for deleting triples Added initial list of languages to decrease risk of deadlocks Added SPARQL SELECT_FED role Added RDF DUMP_GRAPH and RDF_DUMP_NQUADS as built-in stored procedures Added missing JSON support function to format output of ASK query Added support to fine tune size of memory pool used by SPARQL constructs Fixed /sparql-auth requests should not be redirect to /sparql Fixed RDF loading re. transaction modes. Fixed SPARQL endpoint description document Fixed functions for making rdf literals must return dc of boxes Fixed incorrect handling of UTF8 characters on SPARQL HTTP endpoint Fixed issue converting RDF metadata from older databases Fixed issue with ANYTIME query timeout values Fixed issue with JSON-LD and JSON-LD (with context) mime types Fixed issue with SPARQL ASK in embedded PL Fixed issue with SPARQL variables containing unicode characters Fixed issue with incomplete RDF box Fixed old proxy and redirect handling in RDF HTTP_URL_GET Fixed reporting when new graph is created Fixed use a standard namespace URI for special bif: and sql: SPARQL Built-in functions Removed redundant checkpoints when creating new database Small cleanups JDBC, Jena and RDF4j Added optimizations for bulk deleting triples Added support for all JDBC Transaction Isolation levels Added new class VirtStreamRDF for support stream uploading to Virtuoso Fixed issue with closing/leaking JDBC statements Fixed issue with exceptions Fixed issue using batchSize Fixed SQLException handler for better conversion to JenaException Small cleanups Faceted Browser Added check if automated label fill is enabled Added some nofollow and noindex hints for bots Added support to use built-in rdf_label and don't cache the object value twice Fixed UTF-8 encoding issues Fixed XSS issue Fixed bad url encoding Fixed caching query via plink Fixed decoding of percent-encoded URLs when used as labels Fixed detection of label language Fixed do not make default http links Fixed do not remove user defined graphs Fixed efficiency of label language lookup Fixed endpoint creation Fixed issue with bnodes Fixed issue with sid Fixed issue with sponge link in header Fixed make ifps secure Fixed missing graph group Fixed only make link when protocol scheme is safe (http, https, ftp) Fixed order labels by accept-language Fixed return 404 if usage.vsp is called with bad url Fixed several issues in About: block Fixed usage.vsp for safe links Fixed whitespace in Link: header Updated S ranking algorithm Conductor Added faster check for version of installed VAD package Added drop statement and better reporting (ala-isql) Added fingerprint info for system root key Added git hash to the build info Added warning to modifying registry by hand Fixed dependency check on ODS Fixed ensure DB qualifier for conductor Fixed fully qualified view name and use DB qual for all conductor sql Fixed import of user's key Fixed installation of VADs can only be performed by dba account Fixed issue with encoding Fixed issue with non-dba user login causing inf redirects Fixed missing check for ODS Briefcase Fixed LDP metadata Fixed the the rr:graph was not taken from RML doc - UI changes Fixed UI form related to importing RDF files Fixed UI form related to RDF push subscriptions Fixed url encoding DAV Added helper function for fixing DAV COL FULL_PATH Fixed encoding-type for text/* files Fixed handling of content type Fixed issue removing properties Fixed LDP metadata Fixed unhandled error when COL FULL_PATH is NULL Removed redundand join with all graphs GEO Added GEOS-isValid BIF R2RML Fixed handling tableName attribute as per spec Fixed rr:graph was not taken from RML doc 2020 News Announcements 2020-06-22 Virtuoso 7.2.6 Released, Open-Source Edition Virtuoso Engine Added support for macOS 11 Big Sur on Intel and Apple Silicon Added support for OpenSSL 1.1.1 Added support for Strict-Transport-Security header Added check to make sure RPNG is properly seeded Added support for Forward Secrecy using DH and ECDH Added support for rwlock in dict Added support for latest iODBC DM Unicode fixes Added support for unfoldable internal functions in execution plan Fixed default cipher list Fixed set default protocol to TLSv1.2 or newer when possible Fixed issue setting cipher list on https ctx Fixed issues ordering NaN values Fixed issue with atomic transactions Fixed issue reading large blobs Fixed small memory leaks Fixed small portability issues Fixed dependency on netstat during building and testing SPARQL Added initial support for GeoSPARQL functions Added new bootstrap 4 based /sparql (X)HTML endpoint Added support for Content-Disposition header hint for browsers Added flag to control inference optimizations by G Added support for property paths in federated SPARQL queries Fixed namespace check for bif: and sql: and issues with system functions Fixed issue with JSON-LD and JSON-LD (with context) mime types Fixed output formats to use UTF-8 and HTML5 or XHTML5 Fixed splitting on '/#:' produces better results for unnamed prefixes JDBC Driver Added support for JDBC 4.3 Moved SSL connectivity into regular jdbc drivers Fixed issue with closing stmt handle in PreparedStatement Fixed JDBC RPC login options Fixed issue with POINTZ Fixed constructions using new Long/Byte/Short/Character Fixed issue with finalizers Fixed issue running jdbc testsuite Removed support for deprecated versions of JDKs 1.1, 1.2, 1.3, 1.4 and 1.5 Faceted Browser Added FCT Configuration page in Conductor Added specific Map view options using dedicated graph Added configuration option to control browser cache Added small inference rule for link-out icons Added support for schema.org latitude/longitude in factet inference Added new setting to treat narrow string boxes as UTF-8 encoded Added page to show state of Entity Data generation Added preview for embedded content Added statistics about users of IRI as subject or object in graph to Metadata page Added support for IRIs from RDFviews Fixed number of i18n issues with URL encodings in /describe Fixed issues with long values such as geo shapes Fixed issue with pager in /describe Fixed issue with page refresh when Show x rows selector changes Fixed issues with https in /describe content negotiation in Alternates and Location headers Fixed issues with /describe page behind a (ssl) proxy Fixed reporting proper datatype of object rather than box type Conductor Added UI optimizations Added option to view CalDAV and CardDAV resources Disabled triggers generation for RDF view referencing SQL views Fixed issue creating LDP collection data Fixed issue creating user's IRIs Fixed issue in RDF console Fixed issues editing soap services Fixed login when conductor is behind a proxy Fixed small build issues Moved binsrc/yacutia binsrc/conductor DAV Added new optimizations for WebDAV Added support to move lost collections to '/DAV/.lost+found/' collection Added triggers to check the collection hierarchy before updates Added performance improvements for some often used functions Added additional checks for some API calls Updated triggers and procedures to use the new column COL FULL_PATH Fixed issue in conductor showing folder content after rename. Fixed issue with ID of DET collections and optimize DAV SEARCH_ID Fixed issues reported by the Litmus DAV testsuite for COPY and MOVE Fixed issues with LDP, PROPFIND, PATCH Fixed issues with HostFs DET actions Fixed issue with SSL HTTP authentication Fixed issue with LDP POST command Fixed LDP folder content return (by GET) GEO Added new plugins proj4, geos and shapefileio for GeoSPARQL Added check if proj data has been loaded Fixed issue in error handling Fixed handling of GEO NULL_SHAPE Fixed bif:st_intersects Fixed issue with empty shape Fixed handling empty and invalid geometries Fixed portability issues ODS Fixed issue login into ODS Fixed OAUTH token R2RML Fixed support for rr:datatype and rr:language 2018 News Announcements 2018-08-15 - Virtuoso 7.2.5.1 Released, Open Source Edition New and updated product features as of August 15, 2018, v7.2.5.1, include: Virtuoso Engine Added support for application/n-triples mime type Added support for modifying size of SQL compiler cache Added better version checking for OpenSSL to configure Added support for timeout on socket connect Added new debug code to audit SPARQL/SQL errors Added new code for MALLOC_DEBUG Added support for LDAPS Added support for TLSext Server Name Indication to http_client Remove TLSv1 protocol from default protocol list Fixed initial DB.DBA.RDF_DEFAULT_USER_PERMS_SET for user 'nobody' so /sparql endpoint can query all graphs without any performance penalty Fixed scheduler errors should be emailed every time the event fails Fixed issue replaying table rename due to dereference of NULL result Fixed issue returning correct user after TLS login Fixed issues with HTTP PATCH command changing resource permissions Fixed check for infinite loop in SQL compiler Fixed XMLA service to select TIMESTAMP, XML_ENTITY, IRI_ID columns Fixed issue with shcompo cache size Fixed memory leaks Fixed portability issues and compiler warnings Fixed issues building Windows binaries using VS2017 SPARQL Added new option 'Explain' to /sparql endpoint Added new help page for RDF views to /sparql endpoint Fixed initial fill of language and datatype caches after server restart Fixed SPARQL DELETE for quads which failed on booleans and other inlined RDF boxes Fixed SPARQL 1.1 SUBSTR() Fixed issues with PATCH not returning an error after a SPARQL error Fixed SPARQL_CONSTRUCT_ACC could get fixed-value variables referred to in 'stats' argument Fixed Turtle 1.1 permits multiple semicolons without predicate-object pairs between them Fixed handling for timezone date values from SPARQL queries Fixed readability and indentation of EXPLAIN output Fixed issue encoding urls in SPARQL/FED Fixed st_contains and other geo predicates Fixed issue with cast numeric to bool Fixed issues with Turtle and JSON;LD_CTX Jena & Sesame Added method to Sesame provider to query across all RDF graphs in Quad Store Added setIsolationLevel/getIsolationLevel to VirtDataset Update using of DB proc rdf_insert_triple_c() Fixed baseURI parameter not handled properly by RDF4J provider Fixed issue with Jena object values that are URLs Fixed providers Jena/RDF4J setNamespaces/getNamespaces in global cache instead of connection cache Fixed xsd:boolean literals returned as xsd:string literals Fixed VirtDataset class for properly handle transaction JDBC Driver Added support for concurrency mode CONCUR_VALUES Added support for SSL truststore Fixed binding/conversion of Unicode characters Fixed handling of SPARQL negative dates Fixed Sql Workbench/J CSV file import in Virtuoso fails on empty numeric fields Fixed exception handling ADO.NET Fixed support for SPARQL Negative Dates, Concurrency modes, Connection option "Log_enable" Fixed compilation warnings and errors on Mono and .NET versions on Windows Fixed error in CompareTo() methods Fixed issue ADO.NET for DateTime types and TZ Faceted Browser Fixed incorrect UTF-8 character IRI handling in Namespaces Conductor Added option to delete locked files by admin users Added support for JSON and JSON-LD in rewrite rules for SPARQL query output Added support for importing PEM and DER formats Updated Conductor UI to support new redirection options Moved 'OAuth Service Binding' to 'Web Services' Optimized handling of vspx session expiration Fixed issue creating new user accounts with conductor using user with dba and administrator roles Fixed a missing CA chain does not mean .p12 file is bad Fixed issue with 'Next' time in Scheduler Fixed selection of category in the database browser page Fixed rewrite rule export format Fixed CSV importer Fixed crawler functions to work with HTTPS sources Fixed issues with Rewrite Rule export function Fixed issues in R2RML DAV Added item creator as a field in the properties when not empty Added overwrite flag for DynaRes creation Optimized calls to some APIs using user/password properties Fixed issues related to the LITMUS testsuite for DAV Fixed issues with Mac OS X WebDAV mapping Fixed issues with WebDAV browser and folder selection Fixed issue deleting Smart folders Fixed issue with permissions for PUT command Fixed bug with PROPFIND and bad XML (without correct namespace) as body Fixed issue with DAV authentication Fixed issues with set/update LDP related data Fixed response code to 204 for PATCH command Fixed return 406 if no matching Accept header found Fixed issue retrieving user's profile data with RDFData DET DBpedia Added LODmilla browser Download Open Source or Commercial now! 2016 News Announcements 2016-04-24 - Virtuoso 7.2.4 Released, Open Source and Commercial Editions New and updated product features as of April 25, 2016, v7.2.4, include: Virtuoso Engine Added "obvious" index choice Added new bif http_redirect_from for getting initial path from internal redirect Fixed ODBC issue with SQL_C_LONG bound to an int32 instead of an int64/long Fixed hang as page was not left if geo_pred signal an error Fixed check if geo_pred gets right arguments to prevent crash Fixed portability issue on Windows Fixed issue with cost based optimizer for isiri_id Fixed no change from chash to pageable if enable_chash_gb = 2 Disabled AIO for this release of Virtuoso SPARQL Added missing default privilege grants to SPARQL_UPDATE role account Added optimizations covering property paths with complementary and/or repeating paths Added min/max for IRI ID Added new HTML output option to DESCRIBE and CONSTRUCT queries that uses <script>...</script> to include RDF-based Structured Data Islands Added support for CVS in RFC4180 format Added support for skipping UTF-8 BOM marks on Turtle and JSON lexers Added support for service invocation of bigdata running in triples and introducing language exceptions Added new debug option to /sparql page Fixed issue with ':' in blank node labels Fixed NQuads do not permit %NN in blank node labels Fixed issues with property paths like <p>|!<p> Fixed issue when SERVICE clause does not return real vars, only ?stubvarXX Fixed issue with unused default graph Fixed issue with SPARQL SELECT COUNT(DISTINCT *) { ... } Fixed SPARQL-BI syntax for HAVING Fixed issue with duplicate triples in microdata Fixed handling of strings containing serialized XML Fixed issue with boolean in SPARQL/XML results Jena & Sesame Added Sesame 4 provider Added Jena 3 provider Added support for Sesame 2.8.x Added Jena example for use of Inference and Ontology Model with Jena provider Fixed Node2Str for Literals for more properly handle Literals with Lang Fixed issue with openrdf-workbench application Fixed Testsuites Fixed Sesame 2 test connection string Fixed PreparedStatement with parameter bindings for SPARQL queries with parameters instead of substituting parameter values in query Updated testsuites JDBC Driver Added support for building JDK 1.8 and JDBC 4.2 Added support for Connection.setCatalog() Fixed conversion of broken Unicode strings Fixed variable initialization Fixed VirtuosoDataSource methods setLog_Enable() and getLog_Enable() to properly work with Spring framework Fixed JDBC driver to remove finalizers Faceted Browser Added link-out icons Added more link-out relations Fixed content negotiation Fixed default output is XML Fixed facet search service Fixed issue with CSS Fixed labels Fixed missing alias in facet service Fixed missing grant Fixed og:image added to list Fixed possible change of displayed resources post-sponge Fixed prefixes Fixed space encoding in IRI Fixed splitting UTF-8 strings can produce bad encoded strings Fixed support for images Fixed svc search to keep address Conductor Added validation for sequence number value Added start and expiration dates of CA Added new option to disable scheduled job Synced Conductor WebDAV implementation with briefcase Fixed set specific sponger pragmas on text/html Fixed checkpoint after RDF view generation Fixed use of transactional mode Fixed issue with LDAP server Fixed labels DAV Small optimization for update triggers of WS.WS.SYS_DAV_RES Fixed set specific sponger pragmas on text/html Fixed issue uploading Turtle files containing special symbols DBpedia Implemented new fluid skin design for DBpedia /page based on the Bootstrap Framework Updated DBpedia VAD for UTF-8 based URIs for International Chapters Updated prefixes Added references to license Fixed show language with label, abstract, comment Fixed the http://mementoarchive.lanl.gov link Download Open Source or Commercial now! Older Virtuoso News 2015 2013 2012 2011 2010 2009 2008 2007 2006 CategoryVirtuoso CategoryOpenSource CategoryWebSite