Hi Hugh, unfortunately these connections strings don't work for me. I get a "connection failed" for the "localhost/..." connect string, and a "wrong port number" for the "localhost:1111/..." connect string. (the port number is correct)
Best, Georgi > -----Original Message----- > From: Hugh Williams [mailto:hwilli...@openlinksw.com] > Sent: Monday, October 05, 2009 2:43 AM > To: Georgi Kobilarov > Cc: virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] Jena/JDBC connection not properly closed > > 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
