philduba.com

The first item I had to do was create the SQL script for Oracle. I can't recall if I used a converting tool or not, but I believe I did use one to get me close. I did find that Oracle, at least in my instance/configuration, could not have one giant SQL statement inside of one CFQUERY tag, so I used the format of one of the other SQL insert files where each one was in its own CFQUERY tag. The other item I soon found out was Oracle (again in my configuration) placed a maximum of 32 characters, I believe, on identifier names, i.e., table, constraints, pretty much any object you can define. Some of MangoBlog's constraint names were really long and that was before putting a prefix on. I kept to a two-character prefix and modified a few of the constraint names and that seemed to do the trick.

The next item of business was to modify the installer to include Oracle as an option. I probably didn't have to do this, but I wanted to give the logic back so I figured I could update the main setup.cfm and Setup.cfc files. This was probably the easiest part of the whole effort.

The final part came after trying to use MangoBlog's data access components as they were as part of the overall functionality. I consistently received errors. It turns out, that the queries used across the board did not conform to Oracle's format. Now, I don't know remember which side of ANSI SQL-92 each product is on, but the reality was I had to almost rewrite the data access components in order to get MangoBlog to work with Oracle. As a result, I added an oracle folder to the dataaccess folder under the components area, modified the dataaccess.cfc so that if Oracle was chosen as the database, it would use the new components. I believe I also added some logic to establish this in the application scope, but I can't recall.

For those wishing to use this code, I had originally not posted it because I wanted it to go through our QA process; however, that was never accomplished, so there could be bugs in it. I did run it on my local and development servers, but did not really give it a large shakedown of use. Also, the timeframe in which I did this work was May/June of 2009, so those are the files these are based on. Finally, all the files, in the right folder, are in the attached zip.