Home > database >  About the disconnect!!!!!!!!!! Be urgent!!!!!!!!!!!!!!!!!!!!!
About the disconnect!!!!!!!!!! Be urgent!!!!!!!!!!!!!!!!!!!!!

Time:10-06

Pb in the need to manually write disconnect using SQLCA;
If you didn't write, he is in what circumstances to perform disconnect
If a transaction has not yet been submitted, then the accident suspension, the system automatically disconnect???

CodePudding user response:

Pb in the need to manually write disconnect using SQLCA;

Don't need

If you didn't write, he is in what circumstances to perform disconnect

SQLCA is destroy programs usually is shut down

If a transaction has not yet been submitted, then the accident suspension, the system automatically disconnect???

Yes, system=operating system

CodePudding user response:

Pb in the need to manually write disconnect using SQLCA;
Answer: need. Generally speaking, before the end of the program. If your program to access the database operation is small, can consider to the end of each transaction is disconnect.

If you didn't write, he is in what circumstances to perform disconnect
A: as far as I know, this is determined by the database backend. Before I used SQL server, if the client network fault and database connection lost, to the SQL server connection still exists, it will be disconnected after a certain period of time.

If a transaction has not yet been submitted, then the accident suspension, the system automatically disconnect???
A: same as above, see database. Will disconnect, but not necessarily immediately.

CodePudding user response:

Lz want?
  • Related