Poco::Data::Session

[dr0zaxx]

Hello,

Is calling the close() necessary after a Session?

Will there be multiple Session if i keep calling

Code: Select all

Poco::Data::Session session("SQLite", "sample.db");

over and over again or will it act as a singleton and only use the first Session that was created?

Thanks.

[alex]

There will be multiple sessions to the same db. See SQlite::Connector

[dr0zaxx]

@Alex

Thank you for your reply.

I am trying to utilize Poco::Data:SesssionPool

May I know if SQLite is supported?

[alex]

I am trying to utilize Poco::Data:SesssionPool

May I know if SQLite is supported?

Theoretically, yes. But SessionPool does not do any checking in regards to simultaneous DB access, so what will happen there depends on how you are accessing it. SQLite DB is a single file, thus different from a typical DBMS server handling simultaneous access from many sessions. You could devise your own locking scheme inside the DB to deal with that.

[alex]

SQLite DB is a single file, thus different from a typical DBMS server handling simultaneous access from many sessions. You could devise your own locking scheme inside the DB to deal with that.

I have to correct this. I thought we were compiling SQLite by default in multi-threaded mode. It is actually compiled in serialized mode and it should be safe to access it from different threads. See Poco::Data::SQLite Makefile and SQLite And Multiple Threads document for details.