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
