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$

     * @exception Exception, a generic exception.
     */
    public static void doDelete(Criteria criteria)
        throws Exception
    {
        DBConnection dbCon = null;
        try
        {
            // Get a connection to the db.
            dbCon = TurbineDB.getConnection( criteria.getDbName() );
            doDelete(criteria, dbCon);

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

     * @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

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.