Component /dat/lib/database/idGenerator

idGenerator provides a way to generate a unique id number for use in new record creation. Some databases provide a mechanism for this (auto increment field) and some do not. This component provides a generic implementation that will work with all databases. To use the idGenerator you must have a database table that contains a column for each id sequence that needs to be generated. The idGenerator will increment the specified column in the table and then pass that value to the output port.

Pins

• createid causes the component to increment the specified table and output the generated id number
• sent signals that an id was generated

Ports

• output send the generated id number the required component

Properties

• dsn the jdbc data source url needed to access the database.
• driver the database driver to use
• userName the user name needed to access the database.
• password the password needed to access the database.
• table the table containing the columns to be used to generate id numbers
• column the specific column to be used to generate the id number (a numerically typed column)