stanford.netdb.middleware

Class NetDB_Connection

java.lang.Object

stanford.netdb.middleware.NetDB_Connection

public class NetDB_Connection
extends java.lang.Object

This class represents database connection.

Constructor Summary

Constructors

Constructor and Description
NetDB_Connection(java.lang.String db_url, java.util.Properties db_props)

Method Summary

Modifier and Type	Method and Description
void	commit(java.util.logging.Logger logger)
static java.lang.String	db_schema()
static void	db_schema(java.lang.String schema)
Result_Hash	execute(java.util.logging.Logger logger, DB_Statement call) performs actual database call and stuff result set(s) into Hashtable *** HAVE TO WRITE ABOUT FORMAT OF THE HASH ***
void	generic_picker(java.util.logging.Logger logger, java.sql.ResultSet rs, Result_Hash result, java.lang.Integer fetch_size) Attempt to transform a ResultSet, from the database, into a hash.
java.lang.Integer	num_active_statements()
void	release() Releases the connection.
void	rollback(java.util.logging.Logger logger)
Session_ID	session_id()
void	session_id(Session_ID id)
Result_Hash	stored_procedure(java.util.logging.Logger logger, DB_Statement call)
static void	terminate_all_active()
void	verify() Open a connection to the database, and then close is.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

NetDB_Connection

public NetDB_Connection(java.lang.String db_url,
                        java.util.Properties db_props)

Method Detail

db_schema

public static java.lang.String db_schema()

db_schema

public static void db_schema(java.lang.String schema)

session_id

public Session_ID session_id()

session_id

public void session_id(Session_ID id)

release

public void release()
             throws java.sql.SQLException

Releases the connection. The idea is that for pool of connections it places connection back in a pool of available connections. Note that connection pooling is currently not implemented and may never be.

Throws:

java.sql.SQLException

commit

public void commit(java.util.logging.Logger logger)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

rollback

public void rollback(java.util.logging.Logger logger)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public Result_Hash execute(java.util.logging.Logger logger,
                           DB_Statement call)
                    throws java.lang.Exception,
                           java.sql.SQLException

performs actual database call and stuff result set(s) into Hashtable *** HAVE TO WRITE ABOUT FORMAT OF THE HASH ***

Throws:

java.lang.Exception

java.sql.SQLException

stored_procedure

public Result_Hash stored_procedure(java.util.logging.Logger logger,
                                    DB_Statement call)
                             throws java.lang.Exception,
                                    java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

generic_picker

public void generic_picker(java.util.logging.Logger logger,
                           java.sql.ResultSet rs,
                           Result_Hash result,
                           java.lang.Integer fetch_size)
                    throws java.sql.SQLException

Attempt to transform a ResultSet, from the database, into a hash. See the programmer's documentation for a full explanation. result should only ever have three keys: Result_Hash.RETURN_VALUE - the data from the database Result_Hash.WARNING_KEY - non-critical warnings (deprecated) Result_Hash.ERROR_KEY - non-critical errors (deprecated) Critical warnings/errors are passed up the program as exceptions, and/or logged to logger.

Throws:

java.sql.SQLException

num_active_statements

public java.lang.Integer num_active_statements()

terminate_all_active

public static void terminate_all_active()

verify

public void verify()
            throws java.lang.Exception

Open a connection to the database, and then close is. This can be used to verify that the connection information is good.

Throws:

java.lang.Exception