Hi Hugh,
the application was simply firing sequential queries through a Spring driver
that was simply simulating the pooling interface but was not actually doing
real pooling:
http://static.springsource.org/spring/docs/2.0.x/api/org/springframework/jdbc/datasource/DriverManagerDataSource.html
And
Hi Paolo,
Are you making a normal or pooled connection to the database ? As
pooled connection would be best if you application/script is making
many continuos connects and disconnects during this process as
detailed at:
http://docs.openlinksw.com/virtuoso/
VirtuosoDriverJDBC.html#jd
Hi Hugh,
I tried with the last driver but I still have the same problems.
I am not sure it is helpful but, if I add dummy code to increase the time
elapsed in between the queries, it seems behaving much much better (it often
completes the task without triggering connection problems).
Thank you fo
Hi Paolo,
Can you please try using the latest cut of the Virtuoso JDBC Driver
to see how this fares. It can be downloaded from the following FTP URL:
ftp://download.openlinksw.com/support/vos/virtjdbc3.jar
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http:/
Hi Hugh,
I increased the memory of the grails application to 1Gb. But it barely
reaches 240Mb.
I am attaching the virtuoso.ini that I haven't changed and the log file.
This is the exception as I see it in the console (after about 3 queries
of the same type):
2009-09-01 13:34:49,632 [798417047
Hi Paolo,
How did you increase the amount of available memory ?
Can you provide a copy of your Virtuoso configuration (virtuoso.ini)
and log (virtuoso.log) files for analysis ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http:/
I am currently working on some algorithms for indexing subclasses in
ontologies expressed in OWL. I therefore traverse the ontology performing a
list of queries. Unfortunately, most of the times, the indexing process is
not completing due to the following error:
Could not get JDBC Connection; nest
