Re: [Virtuoso-users] Help to fix Virtuoso error

2011-11-24 Thread Hugh Williams
Hi Hoan, You are asking what looks like a commercial licensing question (ie Number of licensed connections exceeded error) on an open source mailing list, please log a support case or use our support forum fro asking such questions: http://support.openlinksw.com/support/online-support.v

[Virtuoso-users] Help to fix Virtuoso error

2011-11-24 Thread Nguyen Mau Quoc Hoan
Hi.I've just downloaded the newest version of Virtuoso (glibc 2.12 x86 (32-bit). After activated, I tried to connect to Virtuoso server by using Java but I always get error: 08004 LI100: Number of licensed connections exceeded How could I fix it? This is my code (example 1): > String u

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Sebastian Trüg
On 11/24/2011 01:31 PM, Ivan Mikhailov wrote: > Sebastian, > > On Thu, 2011-11-24 at 13:16 +0100, Sebastian Trüg wrote: >> Hi Ivan, >> >> thanks a lot for your proposal. It is almost identical to what I ended >> up doing. Except for the last few lines where I used: >> >>foreach(any row in

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Ivan Mikhailov
Sebastian, On Thu, 2011-11-24 at 13:16 +0100, Sebastian Trüg wrote: > Hi Ivan, > > thanks a lot for your proposal. It is almost identical to what I ended > up doing. Except for the last few lines where I used: > >foreach(any row in rows) do > { > cnt := cnt + 1; >

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Sebastian Trüg
Hi Ivan, thanks a lot for your proposal. It is almost identical to what I ended up doing. Except for the last few lines where I used: foreach(any row in rows) do { cnt := cnt + 1; result(sprintf('sparql clear graph <%s>', row[0])); if(state <> '0

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Ivan Mikhailov
Hello Sebastian, Consider this: create procedure nrl_drop_graphs(in query_base varchar, in query_params any := null) { declare stat, msg varchar; declare metas, rset any; stat := '0'; if (query_params is null) query_params := vector (); exec ('sparql ' || query_base, stat, msg,

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Mitko Iliev
Hi Sebastian, You cannot declare cursor as a statement string, the cursor can be declared as : declare cr cursor for select x from table where ... In your case when you need to execute a statement give to the procedure as string literal, you can use exec () and and exec_next () , see http://docs