[Virtuoso-users] Jena/JDBC connection not properly closed

[Georgi Kobilarov]

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")