Where to call SQL close() ?

anchnk

in Contributed Library Questions • 2 years ago

Hi, just read the documentation but not sure how that works ?

AFAIU, close() methods call SQL object dispose() method which itself register to the callback function papplet.registerDispose ?

Does that means i have to call close() like that ?

void setup() {
do the db connection here
}
void draw() {
//do some query here or in setup
}
void dispose() {
msqlobject.close();
}

Or should i put it in stop() method ?

I'm sorry i'm just confuse about how to end a database connection properly

Replies(2)

PhiLho

Re: Where to call SQL close() ?

2 years ago

The official way is to use stop(). You can see it used in the official Minim examples.
dispose()'s doc says: " Not to be called or overriden by users"
Note that to properly use stop(), you have to call the super's method (not that it does much, currently, but it is cleaner this way and this might change again):

void stop()
{
msqlobject.close();
super.stop();
}

anchnk

Re: Re: Where to call SQL close() ?

2 years ago

Ok thanks phi.lho, wasn't really sure on that one.

Top Reply