» Fig Leaf Software Home

We've Got You Covered.

Friday, February 17, 2012

How to set up ID columns in ColdFusion 9 ORM that will work on MSSQL, MySQL and ORACLE


ColdFusion 9's ORM is the bees-knees in my opinion. It allows extremely rapid development and refactoring.

If you happen to be a lucky developer working on a green field project where you are designing your DB and want ColdFusion entities to work across the major DB's such as MSSQL, MySQL and ORACLE you'll want to set your entity ID columns like this:

<cfproperty
fieldtype="id"
column="IDPerson"
name="IDPerson"
generator="increment"
ormtype="long" />

Using this approach will make all the underlying DBs assign the IDs. Setting the ORMTYPE to long is the attribute and value that allows this to work on ORACLE as well.

No comments:

Post a Comment

About Us

Fig Leaf Software is an award-winning team of imaginative designers, innovative developers, experienced instructors, and insightful strategists.

For over 20 years, we’ve helped a diverse range of clients...

Read More

Contact Us

202-797-7711

Fig Leaf Software

1400 16th Street NW
Suite 450
Washington, DC 20036

info@figleaf.com