Problem opening SQLite Session on Mac OS X

[poksi592]

Hi,

I have pretty much straight forward test project, that works fine on Windows. I took the project and I "moved" it to the Mac on Xcode. There is something I don't understand:

- if I give to the constructor method anything else than only filename as connection string, t.i. fill name with path, constructor method is unsuccessful. i.e. "test.db" works and "Macintosh HD/Users/TheUser/test.db" doesn't...
- although test application executer normally and returns no errors of whatsoever, the file test.db is never created...

Thanks for your help!

[rakesh]

Your path is wrong if you prefix it with "Macintosh HD". Did you try just "/Users/TheUser/test.db"?

[poksi592]

@Rakesh, yes, of course. Same result.

[rakesh]

That is strange. I have been testing the SQLite interface on my Mac through a unit test suite, and then verifying the database through the sqlite3 command line shell. My code is more or less similar to the following:

Code: Select all

Connector::registerConnector();
poco_information( logger, "Registered SQLite Connector" );

pool = new SessionPool( Connector::KEY, "/tmp/uma.db" );
poco_information( logger, "PersistenceManager initialised" );

[poksi592]

hm, does it work also on other, non superuser directories, like mine?

[rakesh]

Yes, it works in any directory the current user has write privileges to. /tmp is not a superuser directory, it is all user directory.

[poksi592]

@Rakesh, thanks for your help. The problem was that it hasn't worked with "SQLite" as a parameter for Session, but the Connector::KEY instead. I wonder, how "SQLite" has worked fine on windows?

[alex]

The problem was that it hasn't worked with "SQLite" as a parameter for Session, but the Connector::KEY instead. I wonder, how "SQLite" has worked fine on windows?

Connector name is kept lowercase internally so it should not make the difference. What does your code look like and what POCO version are you using?

[poksi592]

Hi, Alex,

This is the code:

SQLite::Connector::registerConnector();
//databaseSession=new Session("SQLite",connectionstring);
databaseSession=new Session(SQLite::Connector::KEY,connectionstring);

The code that didn't work is commented out. Second line is used instead.