dbManager automatically handle disconnections?

[heroumi]

Hi,
1.
Does dbManager connections automatically handle disconnections?
Is it any problem if I run multiple functions in a row with dbManager like this?
Thank you.

Code: Select all

var dbManager = getParentExtension().getParentZone().getDBManager();

FriendUpdate(dbManager, source_id, destination_id);
FriendAdd(dbManager, source_id, destination_id, position);
EdgeUpdate(dbManager, source_id, destination_id, position);

2.
Is it possible to get the key returned by executeUpdate? executeInsert can get it.

Executes a SQL INSERT command returning the key of the inserted row

[Lapo]

Hi,
connections to the database are normally run in a local network so disconnections are highly unlikely. If you get disconnected in the middle of a DB transaction you will get a SQLException.

Is it any problem if I run multiple functions in a row with dbManager like this?

No it's not a problem.

Is it possible to get the key returned by executeUpdate? executeInsert can get it.

No that's not possible.

Cheers

[heroumi]

thank for info