Re: [Virtuoso-users] External Data Sources

2014-06-02 Thread Hugh Williams
Hi Ricardo. I don't understand what you mean by "I’m performing data aquisitiont trough RDF and then creating SPARQL queries to populate RDBMS views" , how do you create SPARQL queries to populate RDBMS Views or do you mean RDF Views, in which case you would be mapping SQL queries to RDF Vi

Re: [Virtuoso-users] What does "not support OPTION (...) clause for triples so SPARQL query can not be composed" mean?

2014-06-02 Thread Ivan Mikhailov
Hello Andra, > On 30-May-14 10:35 AM, Andra Waagmeester wrote: > > > > When I tried the suggested work around I am getting the following > > error code > > Virtuoso 42000 Error SQ110: Permission denied for delete from > > DB.DBA.RDF_QUAD (user ID = 106) > > > > SPARQL query: > > define sql:big

Re: [Virtuoso-users] Passing Java String Array to Virtuoso Stored Procedure

2014-06-02 Thread Hugh Williams
Hi Jerven, I was actually checking that issue over the weekend and it appears there is a proposed fix to hook the JDBC createArrayOf method into the function Orri implemented server side, which now needs to be tested and added to the open source git repo which should be sometime this week ...

[Virtuoso-users] External Data Sources

2014-06-02 Thread Ricardo Mendes
Hi, I'm performing data aquisitiont trough RDF and then creating SPARQL queries to populate RDBMS views. I need to support OLAP queries over that data, but virtuoso doesn't support that. Currently I cannot afford to buy the commercial version to support the External Data Sources and populate ot

Re: [Virtuoso-users] Passing Java String Array to Virtuoso Stored Procedure

2014-06-02 Thread Jerven Tjalling Bolleman
Hi all, Just to note. This is also the blocking issue for https://github.com/openlink/virtuoso-opensource/issues/155. Regards, Jerven On 02/06/14 10:43, s...@in.gr wrote: > Hey guys, > > I' m doing a lot of SELECT queries in a loop and constant JDBC calls > seem to ruin my performance. I wanna

[Virtuoso-users] Passing Java String Array to Virtuoso Stored Procedure

2014-06-02 Thread sieg
Hey guys, I' m doing a lot of SELECT queries in a loop and constant JDBC calls seem to ruin my performance. I wanna try to send an array of all the Strings I use in my queries to avoid JDBC overhead and later get the result sets back. JDBC4 driver does not seem to support the Types.Array type. Is