A Connection object
is not garbage-collected until all other JDBC objects created from that connection
are explicitly closed or are themselves garbage-collected. Once the connection
is closed, no further JDBC requests can be made against objects created from
the connection. Do not explicitly close the Connection object until
you no longer need it for executing statements.Connectionsgarbage
collection of
A session-severity or higher exception causes the connection to
close and all other JDBC objects against it to be closed. System-severity
exceptions cause the system
to shut down, which not only closes the connection but means that no new connections
should be created in the current JVM.
Implementation Notes on Connection
Methods
Returns
Signature
Implementation Notes
PreparedStatement
prepareStatement(String sql, int [] columnIndexes)
Every column index in the array must correlate to an
auto-increment
column within the target table of the INSERT. Supported in embedded mode only.
PreparedStatement
prepareStatement(String sql, String [] columnNames)
Every column name in the array must designate an
auto-increment
column within the target table of the INSERT. Supported in embedded mode only.
See for
details on the use of the two forms of the Connection.prepareStatement
method shown in this table.