[redland-dev] A question about librdf and postgres storage

[Dave Beckett]

Attilio Fiandrotti wrote:
> Hi
> 
> I'm developing an application that accesses librdf thru java bindings
> and retrives data from a postgres db.
> 
> This is what i noticed about the number of opened connections to the pg
> database
> 
> world = new World();
> world.open();
> storage = new Storage (world, "postgresql", "test", "...");
> model = new Model(world, storage, "");
> 
> -> now i have 3 opened connections
> 
> Then, When i first perform a model.getXXX() , the number of active
> connections is permanently increased by 1, even if i take care of
> cleaning up iterator and other similar things.
> If i later perform another model.getXXX() the number of connections is
> not increased anymore.
> 
> The question is: is this expected and regular or am i doing something
> the wrong way ?

I'm guessing that like the mysql backend, the connections are cached until
the store is closed.

Dave