Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

2015-12-10 Thread Piret Lattikas

Hi, Hugh.

Saw that new release verison 7.2.2 of virtuoso is available. But when I 
try to build debian packages I get an error:


test -x debian/rules
/usr/bin/make -C binsrc/VirtuosoClient.Net clean
make[1]: Entering directory 
`/tmp/build/virtuoso-opensource/binsrc/VirtuosoClient.Net'

make[1]: *** No rule to make target `clean'.  Stop.
make[1]: Leaving directory 
`/tmp/build/virtuoso-opensource/binsrc/VirtuosoClient.Net'

make: *** [cleanbuilddir/libvirtmono0-cil] Error 2

The steps I take:
- start clean ubuntu 14.04 LTS Virtual Machine. All commands in machine 
are executed under root user.

- install initial dependencies:
apt-get update
|apt-get||install||-y openjdk-6-jdk git build-essential automake 
devscripts equivs

|- clone virtuoso source from github:
|git clone https:||//github||.com||/openlink/virtuoso-opensource||.git
| git checkout v7.2.2
- make sure all dependencies needed are installed, based on another 
message thread conversation ( 
http://sourceforge.net/p/virtuoso/mailman/message/34650682/ ):

|mk-build-deps --||install||debian||/control
|- start debian package build:
|fakeroot debian||/rules||clean binary|

Am I missing something? Did some thing changed with release? Because 
building develop/7 branch latest state on 27th of November worked with 
these steps.


Best regards.

Piret


On 08.12.15 16:15, Hugh Williams wrote:

Hi Piret,

Yes, you should just need the new Virtuoso server binary ie the 
virtuoso-t executable …


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

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

2015-12-10 Thread Patrick van Kleef
HI Piret,

> Saw that new release verison 7.2.2 of virtuoso is available. But when I try 
> to build debian packages I get an error:
> 
> test -x debian/rules
> /usr/bin/make -C binsrc/VirtuosoClient.Net clean
> make[1]: Entering directory 
> `/tmp/build/virtuoso-opensource/binsrc/VirtuosoClient.Net'
> make[1]: *** No rule to make target `clean'.  Stop.
> make[1]: Leaving directory 
> `/tmp/build/virtuoso-opensource/binsrc/VirtuosoClient.Net'
> make: *** [cleanbuilddir/libvirtmono0-cil] Error 2
> 
> The steps I take:
> - start clean ubuntu 14.04 LTS Virtual Machine. All commands in machine are 
> executed under root user.
> - install initial dependencies:
> apt-get update
>   apt-get install -y openjdk-6-jdk git build-essential automake devscripts 
> equivs
> - clone virtuoso source from github:
> git clone https://github.com/openlink/virtuoso-opensource.git
>   git checkout v7.2.2
> - make sure all dependencies needed are installed, based on another message 
> thread conversation ( 
> http://sourceforge.net/p/virtuoso/mailman/message/34650682/ ):
> mk-build-deps --install debian/control
> - start debian package build:
> fakeroot debian/rules clean binary

Looks like the clean rule fires too soon, before the actual Makefiles etc are 
created.

Since this is a new checkout, as a workaround you can just use:

fakeroot debian/rules binary

After you have build the first time, the clean option is functional.

I will fix this for the next release

> Am I missing something? Did some thing changed with release? Because building 
> develop/7 branch latest state on 27th of November worked with these steps.


Patrick


Patrick
---
Patrick van Kleef
Program Manager
OpenLink Software

http://www.openlinksw.com/
http://twitter.com/openlink/


--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


[Virtuoso-users] Virtuoso updated to version 7.2.2

2015-12-10 Thread Ted Thibodeau Jr
We're pleased to announce that Virtuoso 7.2.2 is now available, and 
includes various enhancements and bug fixes. Significantly updated 
areas include the main Virtuoso Engine; SPARQL functionality; JDBC, 
Jena, Sesame, and .NET providers and functionality; the Faceted 
Browser; the Conductor; and WebDAV functionality.

New product features as of December 9, 2015, v7.2.2, include:

  * Virtuoso Engine
- Added support for reading bzip2 compressed files
- Added support for reading xz/lzma compressed files
- Added optimization for DATE/DATETIME/TIME escapes

  * SPARQL
- Added option 3 to RDF_AUDIT_METADATA() which provides self-fixing 
  of JSO based system metadata
- Added new JSO loader with bif_jso_validate_and_pin_batch
- Added new HTML output options to default /sparql endpoint page

  * Jena & Sesame
- Updated Jena provider to handle mapping of Jena Blank Nodes to 
  Virtuoso Blank Nodes

  * JDBC Driver
- Added additional server-side settings
- Added initial testsuite for handling date values in JDBC provider

  * Faceted Browser
- Added aggregate query optimization for data across named graphs
- Added support for automatic sponging when no pre-existing data is 
  in place for a target document
- Added using microdata as HTML metadata default instead of RDFa
- Added missing default privilege GRANTs

  * Conductor
- Added export function for stored private and public keys
- Added filters to IMAP DET folders
- Added support for FTP DET
- Added support for move and copy commands on some DETs
- Added support for prefix search, lookup, and verification to 
  WebDAV/Briefcase Editor
- Added support for setting file expiration for WebDAV/Briefcase

  * WebDAV
- Added DETs move/copy commands
- Added IMAP DET filters to WebDAV browser
- Added last-modified attribute to Documents
- Added scheduler procedure for expired items
- Added support for FTP DET

More details of the additions, fixes, and other changes in this 
update of both Open Source and Commercial Editions, may be found 
here --

   


Additional Information: 

* Virtuoso Commercial Edition

  - Home Page


  - Download Page


* Virtuoso Open Source Edition 

  - Development Branch


  - Stable Branch



Please enjoy!




--
A: Yes.  http://www.idallen.com/topposting.html
| Q: Are you sure?   
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.   //   voice +1-781-273-0900 x32
Senior Support & Evangelism  //mailto:tthibod...@openlinksw.com
//  http://twitter.com/TallTed
OpenLink Software, Inc.  //  http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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










smime.p7s
Description: S/MIME cryptographic signature
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

2015-12-10 Thread Thomas Michaux

one more bad news :(

this time I tried with the dump_one_graph_nt procedure from V6 (because 
in V6 dump_nquads() calls the http_nquad() function which is not available)


I then checked with grep that the  dump file for the graph (72Mo) 
contained the XMLLiteral literals, and it has, here are few examples lines :


 
  "Part III: a sharp result on the 
lack of uniform 
stabilization"^^ .
 
  "The existence and unicity 
problem for 
bases"^^ .
 
  "System of non linear ordinary 
differential 
equations"^^ .
 
  "Experiences in LAN and WAN 
environments"^^ .


Then, I imported in V7 from this file using bulkloader :

ld_dir('/LN_Hupe', '*.nt', 
'http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV');

rdf_loader_run();


but still got the problem when querying in V7 with DATATYPE 
returning http://www.w3.org/2001/XMLSchema#string (instead of 
http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral ), for example 
same "Subject" uri and same predicate in query from the first example 
above  :


 select ?graph ?titre (DATATYPE(?titre ))from 
 where {

 GRAPH ?graph {
 
 ?titre

}
}


graph   titre   callret-2
http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV 
"???� rootzPart III: a sharp result on the lack of uniform 
stabilization" 	http://www.w3.org/2001/XMLSchema#string



...hope it will help to investigate

Thomas







Le 08/12/2015 16:13, Thomas Michaux a écrit :
Hugh, new information : same type error when copying V6 virtuoso.db in 
a clean "row store original" V7 , we lost XMLLiteral present in V6 datas :


select ?titre (DATATYPE(?titre ))from 
 
where 
{ 
dcterms:title ?titre}


returns

titre   callret-1
"???� rootbVariants of nonlinear normal form observer design" 
http://www.w3.org/2001/XMLSchema#string



so now we can exclude error during the row to column store procedure.

Thomas


Le 08/12/2015 15:34, Thomas Michaux a écrit :

Le 08/12/2015 14:03, Hugh Williams a écrit :

Hi Thomas,

Don’t know what you mean by " pbs on datas” ???

I assume this spurious chars at the beginning of the strings ?


yes (triple count is ok in V7/V7, no RDF data loss)



Are you saying this string values where XMLLiteral in vs but are now 
XMLSchema#string in v7 , which may be the cause ?
yes XMLLiteral in V6 (via DATATYPE function call) and 
XMLSchema#string in V7




Did you convert the RDF_QUAD table to column store mode also ?


yes

As would be interesting to know if this occurred when it was in v7 
row store original mode also …


i will check this and provide information



Have you tried dumping and reloading the RDF Quad data as also 
suggested as an alternative previously ? ie


not at the moment but i will do as "plan B" if we have the same 
missing types in V7 row store test



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 8 Dec 2015, at 11:55, Thomas Michaux  wrote:

in SPARQL : select ?titre (DATATYPE(?titre ))from 
 
where 
{ 
dcterms:title ?titre}


V7 result :

titre   callret-1
"???� rootbVariants of nonlinear normal form observer design" 
http://www.w3.org/2001/XMLSchema#string




V6 result:

titre   callret-1
Variants of nonlinear normal form observer design 
http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral




Thomas

Le 08/12/2015 12:42, Thomas Michaux a écrit :
when we compare the datatypes from V6 and v7 it seems we'd lost 
the "strong" typing in V6 to a "generic" V7 type 
http://www.w3.org/2001/XMLSchema#string :



SELECT DB.DBA.RDF_DATATYPE_OF_OBJ( "s_1_1_t0"."O") AS 
"titre_datatype",