Re: [Virtuoso-users] Rollback via java

2012-07-08 Thread Hugh Williams
Hi Alex, This is known behaviour as Virtuoso SPAURL operations are not transactional in the same sense as SQL operations are, see the following documentation link: http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul Use of the Virtuoso log_enable() mode is recom

Re: [Virtuoso-users] Rollback via java

2012-07-08 Thread Alex
Hi, thanks for your answer. No there was not an sqlexception. But even your suggested workaround does't work. The returned int is not 0. But again it clears the graph even if the rollback's code is not executed. This the changed code: conn.setAutoCommit(false); stmt = conn.createStateme

Re: [Virtuoso-users] Rollback via java

2012-07-08 Thread Jürgen Jakobitsch
hi, did you double check that stmt.executeQuery(query); doesn't throw an exception? i'd have a try with stmt.executeUpdate and check the resulting int is gt 0. if so try a rollback. wkr turnguard - Original Message - From: "Alex" To: virtuoso-users@lists.sourceforge.net Sent: Friday, J

Re: [Virtuoso-users] using RAMDisk software for faster database access

2012-07-08 Thread Hugh Williams
Hi Sherif, 0.9849b is not the version of the Virtuoso server “virtuoso-t” requested, please provide the output of the “virtuoso-t -?” command requested which will provide the version which should be 6.1.X ... You also have not provided the output of the “status(‘’)” command requested which wil

Re: [Virtuoso-users] using RAMDisk software for faster database access

2012-07-08 Thread sherif kandel
The virtuoso version is version 0.9849b. The number of triples in the store is about 220M triple (the dbpedia dump) The virtuoso.ini file : http://pastie.org/4216107 RAM disk is a tool that converts the memory into an accessable partition, it's a straight forward tool with a single command to all