SQLite in memory unit testing show "no such table error" instead of real error message

Question

I have a simple NHibernate based application that I'm unit testing it with in memory SQLite. Whenever the test fails, for example because of duplicate entity, the unit test fails with error 'there is no such table TABLE_NAME' error instead of showing original error.

If I switch to real file database, all tests (passed or failed) are evaluated correctly. How this is possible at all and how can I correct this?

Firo · Accepted Answer · 2012-06-08 09:03:54Z

3

this is often caused by not using SchemaExport with the inmemory database. Sqlite inmemory databases are dependend on the connection, so each connection has its own database.

new SchemaExport(config).Create(false, true); // creates database, fill it and throws away

instead of

using (var session = sessionfactory.OpenSession())
{
    new SchemaExport(config).Execute(false, true, false, session.Connection, null);

    // use session in test
}

answered Jun 8, 2012 at 9:03

Firo

30.8k4 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Afshar Over a year ago

I'm using Sharp Arch., where should I put this?

Firo Over a year ago

new SchemaExport(config).Execute(false, true, false, session.Connection, null); should be just before running the test case with the session the test case uses. How to get the config from Sharparch i don't know

Lee Grissom Over a year ago

The one sentence in your answer, "Sqlite inmemory databases are ... so each connection has its own database" was an "A-Ha" moment for me. Thanks!

Collectives™ on Stack Overflow

SQLite in memory unit testing show "no such table error" instead of real error message

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related