Projects / sqlDoInstall


sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. It allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.


Recent releases

  •  20 Jan 2009 01:21

    Release Notes: Incorrect handling of "create type statement" has been fixed. Installation is no longer marked as FINISHED when a procedure, function, etc. was created with errors. This release will check whether the object created is valid and exit with an error if not (trigger, procedure, etc.). It stops the installation with an error if the required termination character is not found. Do not use "--" in the text of a "create comment" statement, as the rest of the line will be treated as a comment and the statement will fail.

    •  22 Jul 2008 21:51

      Release Notes: A bug in the creation of objects where columns are named like '%function', '%procedure','%trigger', etc. has been fixed. The environment variable "SQL_DEBUG" can be set to either 1, 2, or 3. Level 1 will report occurrences of create function, trigger, procedure, and anonymous pl-sql blocks. Level 2 is level 1 plus generated SQL statements. Level 3 is level 2 plus every line read from the input file.

      •  01 Jul 2008 20:30

        Release Notes:


        Project Spotlight


        A Fluent OpenStack client API for Java.


        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.