Connection Class

Returns true if the connection is open.

Returns true if the connection is closed.

Used to retrieve the time it took to open the database connection (in milliseconds)

Used to retrieve the java.sql.Connection for this Connection

Used to open a connection to the database using a JDBC connection string. Returns true if the connection was opened successfully.

 jdbc:[dbVendor]://[dbName][propertyList] 

 jdbc:derby://temp/my.db;user=admin;password=mypassword 

Used to open a connection to the database using a javaxt.sql.Database. Returns true if the connection was opened successfully.

Used establish a connection to the database using a previously opened java.sql.Connection. Returns true if the connection is open.

Used establish a connection to the database using a previously opened java.sql.Connection. Returns true if the connection is open.

Used to close a connection to the database, freeing up server resources. It is imperative that the database connection is closed after it is no longer needed, especially if the connection came from a ConnectionPool. That said, this class implements the AutoCloseable interface so you do not have to call this method if the connection was opened as part of a "try" statement. Example:

    try (javaxt.sql.Connection conn = database.getConnection()){

    }
    catch(Exception e){
        e.printStackTrace();
    }    

Used to execute a SQL statement and returns Records as an iterator. Example:

    for (javaxt.sql.Record record : conn.getRecords("select id from contacts")){
        System.out.println(record.get(0));
    }    

Note that records returned by this method are read-only.

Used to execute a SQL statement and returns a Records as an iterator. Example:

    for (javaxt.sql.Record record : conn.getRecords(

        "select first_name, last_name from contacts",

        new HashMap<String, Object>() {{
            put("readOnly", true);
            put("fetchSize", 1000);
        }}
    ))
    {
        System.out.println(record.get("first_name") + " " + record.get("last_name"));
    }    

Returns a single record from the database. Example:

    javaxt.sql.Record record = conn.getRecord("select count(*) from contacts");
    if (record!=null) System.out.println(record.get(0));    

Note that records returned by this method are read-only.

Used to execute a SQL statement and return an open Recordset. The caller must explicitly close the Recordset when finished or invoke the getRecordset() method it in a try/catch statement.

Used to execute a SQL statement and return an open Recordset. The caller must explicitly close the Recordset when finished or invoke the getRecordset() method it in a try/catch statement. Example usage:

    try (javaxt.sql.Connection conn = db.getConnection()){

      //Open recordset
        try (javaxt.sql.Recordset rs = conn.getRecordset("select * from contacts")){

          //Iterate through the records
            while (rs.next()){

              //Do something with the record. Example:
                System.out.println(rs.getValue(0));
            }

        }
    }
    catch(Exception e){
        e.printStackTrace();
    }    

Used to execute a SQL statement and return an open Recordset. The caller must explicitly close the Recordset when finished or invoke the getRecordset() method it in a try/catch statement. See the other getRecordset() for an example. Note that records returned by this method are read-only.

Used to execute a prepared sql statement (e.g. "delete from my_table").

Used to explicitly commit changes made to the database.

Used to return database information associated with this connection.