ColdFusioning - ORM

ColdFusion / Railo Object Relational Mapping - ORM Source Code and Notes

Wed, 04 Aug 2010 03:53:00 -0400

Tonight I gave a presentation on using ORM with ColdFusion or Railo. You can watch the recorded presentation on Adobe Connect. As promised, I'm publishing the source code from the meeting.

Since the code uses ColdBox and a database, it requires some setup. If you follow the steps below, you'll be able to get setup to run the examples:

Setup ColdBox with a mapping ("/coldbox") to the ColdBox source
(I'm using Version 3115)
Unzip the source files to a empty directory
Setup a new site (I'm using "http://office.scribble/" in the examples)
In ColdFusion Admin
- Setup a mapping "scribble" that points at the directory
- Create a datasource pointing at a new database
Update Application.cfc with the new datasource (line 24)
Call the application from the browser

At this point, you should see the ColdBox version number and a list of actions. You'll want to run the "Reload" link first so the tables are all created. I'm not sure why, but if you receive an error on the "Reload" page, refresh the browser a couple times and I'll complete properly.

If you have problems setting up ColdBox, please refer to the ColdBox Documentation at http://wiki.coldbox.org/

Most of the code you'll be utilizing is in either /handlers/dev/ or /model/objects/

Also, I added a deleteContact example that wasn't covered in the presentation. It should be pretty self explanatory.

Lastly, this code is a basis to build on and should not be used in a production environment.

If you have any questions or problems, please leave a comment below.

Download Source Code

Object Relational Mapping (ORM) in ColdFusion 9 and Railo Free Presentation

Mon, 02 Aug 2010 13:47:00 -0400

Tomorrow night I will be presenting on using ORM with ColdFusion and Railo. We'll be looking at the concepts behind ORM but will also be exploring code samples and practical, real-world utilization of ORM.

The presentation will be in Tampa, FL and will also be offered via Adobe Acrobat Connect. That's right, we'll be broadcasting live and accepting questions from remote attendees!

If you ever have wondered what ORM was and how you could use it or if you're already using ORM but would like to learn more and solidify your understanding, this is the presentation to attend.

View more information or register over on Meetup.

ColdFusion Now Supports Multiple Data Sources for ORM

Tue, 13 Jul 2010 16:05:00 -0400

With the ColdFusion 9.0.1 update, you can now use multiple data sources with ORM. When you create your objects, use the "datasource" attribute to specify which each should use. Below is an example of it in use:


component		persistent		= true
			accessors		= true
			entityname		= 'Contact'
			hint			= 'This object holds contacts and their associated properties'
			datasource		= 'mydatasource' {

property name='ContactID' type='numeric' persistent=true ormtype='integer' fieldtype='id' generator='increment';
}

If you don't specify a data source, the default data source is used.

Introduction to ColdFusion ORM

Sat, 17 Oct 2009 00:19:00 -0400

After coming back from MAX and seeing how wonderful ORM is, I had to jump right into it. I'm using ORM for the Tour de ColdFusion so I will post some code samples as I write them. The first set is an introduction to ColdFusion ORM.

The first thing you have to do is turn ORM on. You do this simply by adding the two following lines to your Application.cfc:

The DataSource name must match the one you created in the ColdFusion Administrator that is correctly pointed at a database. The next thing we'll do is define our table. We're going to call this one Categories.cfc:

This defines the Unique ID named as Category that auto-increments. We defined some other simple columns. Next we're going to insert some data into the database:



	newObj = EntityNew("Categories");
	newObj.setCategoryName("UI Controls"); 
	newObj.setParentid("2"); 
	EntitySave(newObj);
	writedump(newObj.getCategoryID()); 
	ormflush();

All this does is set the category name, parentid and saves it. It also retrieves the new CategoryID from the database. The last thing we're going to do is get some data back out of the database:



   categories = EntityLoad("categories", true);
   writedump(categories);

This is very similar to doing except ORM loads and array rather than a query:



SELECT * FROM Categories

Lastly, if you want to select a single record from the database you would use this code:



   categories = EntityLoad("categories", 5, true);
   writedump(categories);

With "5" being the CategoryID of the record you want to pull from the database.

ORM is truly a game-changer in the web development industry. It is going to enable ColdFusion developers to create applications even faster than we could before. I would recommend not waiting to learn it because it is only going to save you time in the long run.

ColdFusion ORM: Error while executing the Hibernate query - table is not mapped exception

Sat, 17 Oct 2009 00:15:00 -0400

I'm starting to learn ORM and figured I'd post some simple but confusing problems I've run into. The first is I kept getting the error:

Error while executing the Hibernate query.
org.hibernate.hql.ast.QuerySyntaxException: tablename is not mapped
This was my ORM code:




categories = ormExecuteQuery("from categories where ParentID = ?", [request.ID]);

Apparently, because my cfc is named Categories.cfc and I didn't capitalize "categories" inside of the ormExecuteQuery, it was throwing the error. If I cahnge it to:




categories = ormExecuteQuery("from Categories where ParentID = ?", [request.ID]);

The code works. A simple capitalization error that doesn't seem obvious because ColdFusion is largely not case sensitive.