More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What is a Connection object?
A Connection object represents a connection with a database. Within the scope of one Connection, you access only a single Derby database. (Database-side JDBC procedures can allow you to access more than one database in some circumstances.) Depending on your Derby product license, a single application might allow one or more Connections to Derby, either to a single database or to many different databases, provided that all the databases are within the same system .
With DriverManager, you use the connection URL as an argument to get the getConnection method to specify which database to connect to and other details.
The following example shows an application establishing three separate connections to two different databases in the current system.
Connection conn = DriverManager.getConnection(
"jdbc:derby:sample");
System.out.println("Connected to database sample");
conn.setAutoCommit(false);
Connection conn2 = DriverManager.getConnection(
"jdbc:derby:newDB;create=true");
System.out.println("Created AND connected to newDB");
conn2.setAutoCommit(false);
Connection conn3 = DriverManager.getConnection(
"jdbc:derby:newDB");
System.out.println("Got second connection to newDB");
conn3.setAutoCommit(false);
A Connection object has no association with any specific thread; during its lifetime, any number of threads might have access to it, as controlled by the application.
(Continued on next question...)
