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$

    {
        // 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

     * @exception Exception, a generic exception.  */
    public static int executeStatement(String stmt,
                                       String dbName)
        throws Exception
    {
        DBConnection db = null;
        int rowCount = -1;
        try
        {
            // Get a connection to the db.
            db = TurbineDB.getConnection( dbName );

View Full Code Here

    /**
     * Do a Prepared Statement select according to the given criteria 
     */
    public static Vector doPSSelect(Criteria criteria) throws Exception
    {
        DBConnection dbCon = TurbineDB.getConnection( criteria.getDbName() );
        Vector v = null;


        try
        {
            v = doPSSelect (criteria,dbCon);

View Full Code Here


        // Check for Transaction support.  Give warning message if
        // IDBroker is being used with a database that does not
        // support transactions.
        String dbName = tMap.getDatabaseMap().getName();
        DBConnection dbCon = null;
        try
        {
            dbCon = TurbineDB.getConnection(dbName);
            transactionsSupported = dbCon.getConnection()
                .getMetaData().supportsTransactions();
        }
        catch (Exception e)
        {
            transactionsSupported = false;

View Full Code Here

//        synchronized(tMap)  see comment in the getNextIds method
//        {
            if (adjustQuantity)
                checkTiming(tableName);


            DBConnection dbCon = null;
            try
            {
                String databaseName = dbMap.getName();


                // Get a connection to the db by starting a
                // transaction.
                if (transactionsSupported)
                {
                    dbCon = BasePeer.beginTransaction(databaseName);
                }
                else
                {
                    dbCon = TurbineDB.getConnection(databaseName);
                }
                Connection connection = dbCon.getConnection();


                // Write the current value of quantity of keys to grab
                // to the database, primarily to obtain a write lock
                // on the table/row, but this value will also be used
                // as the starting value when an IDBroker is

View Full Code Here

        {
            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

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.