Hello Hugh, now the connection can be established and data be written, but closing the model/connection with model.close() (in my code example target_model.close()) doesn't work. No error message or exception, it just hangs.
Georgi > -----Original Message----- > From: Hugh Williams [mailto:hwilli...@openlinksw.com] > Sent: Tuesday, October 06, 2009 2:03 AM > To: Georgi Kobilarov > Cc: virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] Jena/JDBC connection not properly closed > > Hi Georgi, > > It would appear the connect string URL can only be "hostname:port" or > "hostname" ( in which case default port 1111 is assumed), so you would > need to drop the /CHARSET and /TIMEOUT attributes for this to work ie > > def getModel(name : String) = VirtModel.createDatabaseMode > (name,"localhost:1111", "user", "pw"); > > i would expect to be able to pass other connect string URL attributes > like /CHARSET /TIMEOUT etc. as can be done for the normal connect > string URLs, so development have been asked to look into adding > support for this to be supported. > > 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 5 Oct 2009, at 15:00, Georgi Kobilarov wrote: > > > 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 > > > > > > --------------------------------------------------------------------- > --------- > > 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
