Examples of org.apache.turbine.util.db.pool.DBConnection

org.apache.turbine.util.db.pool.DBConnection
This class wraps the JDBC Connection class, providing built-in exception logging to stderr and a timestamp which indicates how old the Connection is. DBConnection's timestamp is used by the ConnectionPool to expire connections when they get too old. Do not use this class as a shared resource (it is not thread-safe). @author Frank Y. Kim @author John D. McNally @author Daniel L. Rall @author Magn�s ��r Torfason @author Jon S. Stevens @version $Id$

        {
            quantity = (BigDecimal)quantityStore.get(tableName);
        }
        else
        {
            DBConnection dbCon = null;
            try
            {
                String databaseName = tableMap.getDatabaseMap().getName();


                // Get a connection to the db
                dbCon = TurbineDB.getConnection(databaseName);
                Connection connection = dbCon.getConnection();


                // Read the row from the ID_TABLE.
                BigDecimal[] results = selectRow(connection, tableName);


                // QUANTITY column.

View Full Code Here

     */
    public static Schema initTableSchema(String tableName,
                                         String dbName)
    {
        Schema schema = null;
        DBConnection db = null;


        try
        {
            if (dbName == null)
            {
                // Get a connection to the db.
                db = TurbineDB.getConnection();
            }
            else
            {
                // Get a connection to the db.
                db = TurbineDB.getConnection( dbName );
            }


            Connection connection = db.getConnection();


            schema = new Schema().schema(connection, tableName);
        }
        catch(Exception e)
        {

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static DBConnection beginTransaction(String dbName)
        throws Exception
    {
        DBConnection dbCon = TurbineDB.getConnection( dbName );
        if ( dbCon.getConnection().getMetaData().supportsTransactions() )
        {
            dbCon.setAutoCommit(false);
        }


        return dbCon;
    }

View Full Code Here

    public static void deleteAll( String table,
                                  String column,
                                  int value )
        throws Exception
    {
        DBConnection dbCon = null;
        try
        {
            // Get a connection to the db.
            dbCon = TurbineDB.getConnection();

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static void doDelete(Criteria criteria)
        throws Exception
    {
        DBConnection dbCon = null;


        // Transaction stuff added for postgres.
        boolean doTransaction = (TurbineDB.getDB(criteria.getDbName()).
            objectDataNeedsTrans() &&
            criteria.containsObjectColumn(criteria.getDbName()));

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static ObjectKey doInsert(Criteria criteria)
        throws Exception
    {
        DBConnection dbCon = null;
        ObjectKey id = null;


        // Transaction stuff added for postgres.
        boolean doTransaction = (TurbineDB.getDB(criteria.getDbName()).
            objectDataNeedsTrans() &&

View Full Code Here

        Vector results = null;
        if (TurbineDB.getDB(criteria.getDbName())
              .objectDataNeedsTrans() &&
              criteria.containsObjectColumn(criteria.getDbName()))
        {
            DBConnection dbCon = beginTransaction(criteria.getDbName());
            try
            {
                results = executeQuery( createQueryString(criteria),
                                        criteria.isSingleRecord(), dbCon );
                commitTransaction(dbCon);

View Full Code Here

                                      int numberOfResults,
                                      String dbName,
                                      boolean singleRecord)
        throws Exception
    {
        DBConnection db = null;
        Vector results = null;
        try
        {
            // get a connection to the db
            db = TurbineDB.getConnection( dbName );

View Full Code Here

    {
        // Transaction stuff added for postgres.
        boolean doTransaction = (TurbineDB.getDB(updateValues.getDbName())
            .objectDataNeedsTrans() &&
            updateValues.containsObjectColumn(updateValues.getDbName()));
        DBConnection db = null;
        try
        {
            // Get a connection to the db.
            if (doTransaction)
            {

View Full Code Here

    {
        // Transaction stuff added for postgres.
        boolean doTransaction = (TurbineDB.getDB(updateValues.getDbName())
            .objectDataNeedsTrans() &&
            updateValues.containsObjectColumn(selectCriteria.getDbName()));
        DBConnection db = null;
        try
        {
            // Get a connection to the db.
            if (doTransaction)
                db = beginTransaction(selectCriteria.getDbName());

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.apache.turbine.util.db.pool.DBConnection

org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary

org.apache.turbine.om.peer.BasePeer

org.apache.turbine.util.db.IDBroker

java.util.Vector

java.sql.SQLException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.