Hi Georgi,
Can you please try changing your connect string URL for the Virtuoso
Jena Provider from:
def getModel(name : String) = VirtModel.createDatabaseModel(name,
"jdbc:virtuoso://localhost/CHARSET=UTF-8/TIMEOUT=20", "user", "pw")
To:
def getModel(name : String) = VirtModel.createDatabaseModel
(name,"localhost/CHARSET=UTF-8/TIMEOUT=20", "user", "pw");
Or:
def getModel(name : String) = VirtModel.createDatabaseModel
(name,"localhost:1111/CHARSET=UTF-8/TIMEOUT=20", "user", "pw");
This will force the Jena Provider to make a pooled connection to the
Virtuoso Server, resulting in connections being re-used when available
rather than on for each request as is the case with the default
"jdbc:virtuoso://localhost..." connect string URL.
Let us know if this resolves the issue for you ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 2 Oct 2009, at 12:14, Georgi Kobilarov wrote:
Thanks Hugh,
I downloaded the new jdbc and jena driver, but the problem still
exists. The
virtuoso.log doesn't list any errors.
Georgi
-----Original Message-----
From: Hugh Williams [mailto:hwilli...@openlinksw.com]
Sent: Thursday, October 01, 2009 7:39 PM
To: Georgi Kobilarov
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Jena/JDBC connection not properly
closed
Hi Georgi,
Can you please download the latest Virtuoso Jena and JDBC Drivers and
repeat your tests as their have been a number of fixes in both:
ftp://download.openlinksw.com/support/vos/virt_jena.jar
ftp://download.openlinksw.com/support/vos/virtjdbc3.jar
Also please check in your virtuoso.log file to see if any errors are
being reported on the server ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 1 Oct 2009, at 17:06, Georgi Kobilarov wrote:
Hello,
I ran into a problem with the Virtuoso Jena driver. I'm using the
virtuoso
jena library to write rdf to Virtuoso, and after around 8000
connections I
get the exception:
Virtuoso.jdbc3.VirtuosoException: Connection failed: No buffer space
available (maximum connections reached?)
My code (see below, written in Scala) does close the model, so I
believe the
connection should be closed as well. But netstat on Windows shows
thousands
of open connections. What am I missing?
Best,
Georgi
def replaceModel(replace: String, by: Model, in: String) = {
val target_model = getModel(in)
target_model.begin
try {
val old_resource = target_model.getResource(replace)
old_resource.removeProperties
target_model.add(by)
} catch {
case ex: Exception => { target_model.abort; throw ex}
} finally {
target_model.commit
target_model.close
}
}
def getModel(name : String) = VirtModel.createDatabaseModel(name,
"jdbc:virtuoso://localhost/CHARSET=UTF-8/TIMEOUT=20", "user", "pw")
---------------------------------------------------------------------
---------
Come build with us! The BlackBerry® Developer Conference in SF,
CA
is the only developer event you need to attend this year. Jumpstart
your
developing skills, take BlackBerry mobile applications to market and
stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart
your
developing skills, take BlackBerry mobile applications to market and
stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
