oarevalo/BugLogHQ — pull request #20 by bcswartz (2013-03-03 15:16:56+00:00)
Title: Added Oracle support

I've made a few additions and modifications to the BugLogHQ files so it can be run with Oracle.

The key issue with supporting Oracle is that Oracle doesn't an autoincrement feature; instead, it has the notion of sequences, auto-incrementing numbers that exist separately from tables. So the included install script for creating the BugLog tables also creates sequences based on the BugLog table names, and the _insert() function in dbDataProvider.cfc utilizes the sequences when adding records.

Oracle also uses the CLOB data type database field for text fields that hold over 4,000 characters, so I modified the relevant DAO properties to use the cfqueryparameter type for CLOBs if the datasource is of type "oracle."

Finally, I had to adjust a few queries to use Oracle-specific SQL functions.

Rather than update the Readme to denote the Oracle support, I figured I would let you update that file as you see fit.