View Forum Topic

Forums
CS320
Closing a statement

Author	Message
cbort Posts: 95	Posted 21:40 May 26, 2011 \| If you close a connection will it close the prepared statements that were constructed by it or do you have to close each statement individually in addition to the connection?
cysun Posts: 2935	Posted 21:53 May 26, 2011 \| This is an interesting question. The documentation is not very clear about this. I always assume that calling connection.close() would close all the statements associated with the connection. A quick look at MySQL's Connection implementation (thanks to Open Source) shows that this is indeed the case (at least for the MySQL JDBC driver). Attachments: Connection.java Last edited by cysun at 21:54 May 26, 2011.

Author

Message

cbort

Posts: 95

Posted 21:40 May 26, 2011 |

If you close a connection will it close the prepared statements that were constructed by it or do you have to close each statement individually in addition to the connection?

cysun

Posts: 2935

Posted 21:53 May 26, 2011 |

This is an interesting question. The documentation is not very clear about this. I always assume that calling connection.close() would close all the statements associated with the connection. A quick look at MySQL's Connection implementation (thanks to Open Source) shows that this is indeed the case (at least for the MySQL JDBC driver).

Attachments:

Connection.java

Last edited by cysun at 21:54 May 26, 2011.