Examples of org.apache.torque.oid.IDBroker

org.apache.torque.oid.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 @author Henning P. Schmiedehausen @version $Id: IDBroker.java 239630 2005-08-24 12:25:32Z henning $

        nextId.setType(Integer.valueOf(0));
        tMap.addColumn(nextId);
        ColumnMap quantity = new ColumnMap("QUANTITY", tMap);
        quantity.setType(Integer.valueOf(0));
        tMap.addColumn(quantity);
        idBroker = new IDBroker(this);
        addIdGenerator(IDMethod.ID_BROKER, idBroker);
        return true;
    }

View Full Code Here

        synchronized (databases)
        {
            for (Iterator it = databases.values().iterator(); it.hasNext();)
            {
                Database database = (Database) it.next();
                IDBroker idBroker = database.getIDBroker();
                if (idBroker != null)
                {
                    idBroker.stop();
                }
            }
        }


        // shut down the data source factories

View Full Code Here

            TableMap tMap = getIdTable();
            tMap.addPrimaryKey("ID_TABLE_ID", new Integer(0));
            tMap.addColumn("TABLE_NAME", "");
            tMap.addColumn("NEXT_ID", new Integer(0));
            tMap.addColumn("QUANTITY", new Integer(0));
            idBroker = new IDBroker(idTable);
            addIdGenerator(IDMethod.ID_BROKER, idBroker);
            return true;
        }
        return false;
    }

View Full Code Here

        if (dbMaps != null)
        {
            for (Iterator it = dbMaps.values().iterator(); it.hasNext();)
            {
                DatabaseMap map = (DatabaseMap) it.next();
                IDBroker idBroker = map.getIDBroker();
                if (idBroker != null)
                {
                    idBroker.stop();
                }
            }
        }
        TorqueException exception = null;
        for (Iterator it = dsFactoryMap.keySet().iterator(); it.hasNext();)

View Full Code Here

0 1

TOP

Related Classes of org.apache.torque.oid.IDBroker

org.apache.torque.Database

org.apache.torque.map.DatabaseMap

org.apache.torque.TorqueInstance

java.sql.PreparedStatement

java.util.ArrayList

java.util.Iterator

org.apache.torque.TorqueException

java.sql.ResultSet

java.util.List

java.sql.Connection

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.