Examples of org.apache.turbine.util.db.IDBroker

org.apache.turbine.util.db.IDBroker

This method of ID generation is used to ensure that code is more database independent. For example, MySQL has an auto-increment feature while Oracle uses sequences. It caches several ids to avoid needing a Connection for every request. This class uses the table ID_TABLE defined in conf/master/id-table-schema.xml. The columns in ID_TABLE are used as follows:
ID_TABLE_ID - The PK for this row (any unique int).
TABLE_NAME - The name of the table you want ids for.
NEXT_ID - The next id returned by IDBroker when it queries the database (not when it returns an id from memory).
QUANTITY - The number of ids that IDBroker will cache in memory.

Use this class like this:

 int id = dbMap.getIDBroker().getNextIdAsInt(null, "TABLE_NAME"); - or - BigDecimal[] ids = ((IDBroker)dbMap.getIDBroker()) .getNextIds("TABLE_NAME", numOfIdsToReturn);

NOTE: When the ID_TABLE must be updated we must ensure that IDBroker objects running in different JVMs do not overwrite each other. This is accomplished using using the transactional support occuring in some databases. Using this class with a database that does not support transactions should be limited to a single JVM. @author Frank Y. Kim @author John D. McNally @version $Id: IDBroker.java,v 1.27.4.6 2001/06/01 01:35:00 jvanzyl Exp $

    {
        Iterator maps = dbMaps.values().iterator(); 
        while ( maps.hasNext() )
        {
            DatabaseMap map = (DatabaseMap) maps.next();
            IDBroker idBroker = map.getIDBroker();
            if (idBroker != null)
            {
                idBroker.stop();
            }
        }
    }

     */
    public void setIdTable( TableMap idTable )
    {
        this.idTable = idTable;
        addTable(idTable);
        idBroker = new IDBroker(idTable);
        addIdGenerator(TableMap.IDBROKERTABLE, idBroker);
    }

     */
    public void setIdTable( TableMap idTable )
    {
        this.idTable = idTable;
        addTable(idTable);
        idBroker = new IDBroker(idTable);
        addIdGenerator(TableMap.ID_BROKER, idBroker);
    }

    {
        Iterator maps = dbMaps.values().iterator();
        while ( maps.hasNext() )
        {
            DatabaseMap map = (DatabaseMap) maps.next();
            IDBroker idBroker = map.getIDBroker();
            if (idBroker != null)
            {
                idBroker.stop();
            }
        }
    }

Examples of org.apache.turbine.util.db.IDBroker

Related Classes of org.apache.turbine.util.db.IDBroker