Understanding 'open environment' and 'get db object' invocation order

[rZinnatov]

Hello guys!

Question

Does the order of invocation the sp_open(env) and sp_getobject(env, "db.test") statements matter?

I tried both cases and it worked in each case. So obviously it doesn't but I tried trivial ones. So is there any case when it does matter?

Why am I concerned

CRUD example says:

void *db = sp_getobject(env, "db.test");
int rc = sp_open(env);

Common Workflow example says:

sp_open(env);
void *db = sp_getobject(env, "db.test");

Thank you!

[pmwkaa]

Hi, in that case yes - second case is more correct, thanks for pointing this out.
Database object would be unusable until it gets open. sp_open(env) basically opens all pre-defined databases and replays write-ahead log records. Yet, it it possible to create a new database after sp_open(env) is done by doing sp_open(db).

[rZinnatov]

Just to be clear. Open environment first is more correct, is it?

sp_open(env);
void *db = sp_getobject(env, "db.test");

About sp_open(db): Did you mean the following?

sp_open(env);
sp_setstring(env, "db", "test", 0);
void *db = sp_getobject(env, "db.test");
sp_open(db); // Do this because 'db' string was set after sp_open(env)

[pmwkaa]

Yes to both questions :)

[rZinnatov]

Thank you for the explanations! =)