Adobe
Products
Creative Suite
Photoshop Family
Acrobat Family
Flash Platform
Digital Marketing Suite
Digital Publishing Suite
More products
Solutions
Digital marketing solutions
Digital media solutions
Education
Financial services
Government
Web Experience Management
More solutions
Learning Help Downloads Company
Store
Adobe Store for home and home office
Education Store for students, educators, and staff
Business Store for small and medium businesses
Other ways to buy
Search
 
Info Sign in
Welcome,
My cart
My orders My Adobe
My Adobe
My orders
My information
My preferences
Sign out
Why sign in? Sign in to manage your account and access trial downloads, product extensions, community areas, and more.
Adobe
Products Sections   Search  
Solutions Company
Help Learning
Sign in Welcome, My orders My Adobe
Qty:
Purchase requires verification of academic eligibility
Subtotal
Review and Checkout
Adobe Developer Connection / Flex Developer Center /

Set up and build your first Flex and ColdFusion application – Part 1: Database setup

by Trilemetry

Trilemetry
  • Trilemetry, Inc.

Created

22 March 2010

Page tools

Share on Facebook
Share on Twitter
Share on LinkedIn
Bookmark
Print
CFC ColdFusion  data services Flex

Requirements

Prerequisite knowledge

This tutorial is intended for:

  • Developers who are exploring tutorials in the Flex and ColdFusion mini learning center that are based on the Fictitious Sales Planner example.
  • Experienced ColdFusion developers without previous Adobe Flex framework or Adobe Flash Builder 4 experience.
  • ColdFusion developers who are familiar with ColdFusion components.

User level

All

Required products

  • ColdFusion (Download trial)
  • Flash Builder (Download trial)

Sample files

  • f4cf_fictitious_db.zip (75 KB)
  • f4cf_generated_cfcs.zip (4 KB)

Adobe Flash Builder 4, formerly known as Flex Builder, has simplified the integration of Adobe ColdFusion with the Adobe Flex framework to create SWF applications. You can now use simple wizards to import ColdFusion components (CFCs) into your projects and access data through service calls to the CFC functions. You can also easily populate Flex UI controls with the returned data by simply clicking-and-dragging the data object onto the control.

In Part 1, you will learn how to set up a ColdFusion data source. In Part 2, which is optional, you will generate the ColdFusion components (CFCs) using ColdFusion Builder. In Part 3, you will set up a Flash Builder data service project with ColdFusion for use with the Fictitious Sales Planner sample application.

Download the sample database archive file

In this section you will download the F4CF_FictitiousSalesPlanner database archive file. This database contains the employee sales data for the Fictitious Sales Planner sample application, which is used in other tutorials of the Flex and ColdFusion mini learning center.

  1. Download the f4cf_fictitious_db.zip sample file if you haven't done so already.
  2. Unzip the file to the \ColdFusion9\db directory and review the contents:
    • The \ColdFusion9\db folder now contains the F4CF_FictitiousSalesPlanner folder which contains the control files and sample data for the Derby db.
  3. Start the ColdFusion server.

Create the Apache Derby data source

In this section, you will use the ColdFusion Administrator to create an Apache Derby Data Source to access the FictiousSalesPlanner data.

  1. Log on to the ColdFusion Administrator.
  2. Expand the Data & Services left hand navigation and Click on Data Sources.
  3. Enter F4CF_FictitiousSalesPlanner as the Data Source Name and Select Apache Derby Embedded from the Driver drop down menu as shown in Figure 1.
Add a New Apache Derby Data Source.
Figure 1. Add a New Apache Derby Data Source.
  1. Click the Add button.
  2. Click the Browse Server button next to the Database Folder, and navigate to the ColdFusion9\db\F4CF_FictitiousSalesPlanner folder. Click Apply. The Data Source definition panel will appear as shown in Figure 2.
The Data Source definition panel.
Figure 2. The Data Source definition panel.
  1. Click the Submit button.
  2. You should now see the F4CF_FictitiousSalesPlanner Data Source listed under the Connected Data Sources as shown in Figure 3.
The F4CF_FictitousSalesPlanner Data Source has been added.
Figure 3. The F4CF_FictitousSalesPlanner Data Source has been added.

You will be using the F4CF_FictitiousSalesPlanner data source in Part 2 and Part 3 of this series.

Where to go from here

You have learned how to set up a ColdFusion data source and Flash Builder project. In Part 2, which is optional, you will generate the ColdFusion components (CFCs) using ColdFusion Builder. In Part 3, you will set up a Flash Builder data service project with ColdFusion for use with the Fictitious Sales Planner sample application.

More Like This

  • Binding ColdFusion data to Flex UI components with Adobe Flash Builder 4
  • Working with Doctrine 2, Zend AMF, Flex, and Flash Builder
  • Building a Flex application that connects to a BlazeDS Remoting destination using Flash Builder 4
  • Building the server side of the Tour de Flex real-time dashboard
  • Data-centric development with Flash Builder 4
  • Understanding the role of CFCs in Flex application development
  • Deploying a Flex application with ColdFusion URL variables
  • Generating ColdFusion forms with Adobe Flash Builder 4
  • Getting started with ColdFusion and Flash Builder 4 – Database, CFC, and data services setup
  • Managing ColdFusion data with Adobe Flash Builder 4

Tutorials & Samples

Tutorials

  • Flex mobile performance checklist
  • Flex and Maven with Flexmojos – Part 3: Journeyman
  • Migrating Flex 3 applications to Flex 4.5 – Part 4

Samples

  • Twitter Trends
  • Flex 4.5 reference applications
  • Mobile Trader Flex app on Android Market

Flex User Forum

More
02/07/2012 Newbie - Views
01/24/2012 How to navigate through the views without losing content?
02/07/2012 ActionScript rounding issue
02/07/2012 Setting Value of Static Const

Flex Cookbook

More
01/20/2012 Skinnable Transform Tool
12/12/2011 Date calculations using 'out-of-the-box' functions
12/05/2011 String replaceAll in ActionScript
12/04/2011 Flex: Validate/revert editable Datagrid input value

Products

  • Creative Suite
  • Photoshop Family
  • Acrobat Family
  • Flash Platform
  • Digital Marketing Suite
  • Digital Publishing Suite
  • Mobile apps

Solutions

  • Digital marketing
  • Digital media
  • Web Experience Management

Industries

  • Education
  • Financial services
  • Government

Help

  • Product help centers
  • Orders and returns
  • Downloading and installing
  • My Adobe

Learning

  • Adobe Developer Connection
  • Adobe TV
  • Training and certification
  • Forums
  • Design Center

Ways to buy

  • Adobe Store
  • For students and educators
  • For small and medium businesses
  • For enterprises
  • Special offers

Downloads

  • Adobe Reader
  • Adobe Flash Player
  • Adobe AIR
  • Adobe Shockwave Player

Company

  • News room
  • Partner programs
  • Corporate social responsibility
  • Career opportunities
  • Investor Relations
  • Events
  • Legal
  • Contact Adobe
Choose your region United States (Change)
Choose your region Close

North America

Europe, Middle East and Africa

Asia Pacific

  • Canada - English
  • Canada - Français
  • Latinoamérica
  • México
  • United States

South America

  • Brasil
  • Africa - English
  • Österreich - Deutsch
  • Belgium - English
  • Belgique - Français
  • België - Nederlands
  • България
  • Hrvatska
  • Česká republika
  • Danmark
  • Eastern Europe - English
  • Eesti
  • Suomi
  • France
  • Deutschland
  • Magyarország
  • Ireland
  • Israel - English
  • Italia
  • Latvija
  • Lietuva
  • Luxembourg - Deutsch
  • Luxembourg - English
  • Luxembourg - Français
  • Middle East and North Africa - English
  • Moyen-Orient et Afrique du Nord - Français
  • Nederland
  • Norge
  • Polska
  • Portugal
  • România
  • Россия
  • Srbija
  • Slovensko
  • Slovenija
  • España
  • Sverige
  • Schweiz - Deutsch
  • Suisse - Français
  • Svizzera - Italiano
  • Türkiye
  • Україна
  • United Kingdom
  • Australia
  • 中国
  • 中國香港特別行政區
  • Hong Kong S.A.R. of China
  • India - English
  • 日本
  • 한국
  • New Zealand
  • Pacific - English
  • 台灣

Southeast Asia

  • Includes Indonesia, Malaysia, Philippines, Singapore, Thailand, and Vietnam - English

Copyright © 2012 Adobe Systems Incorporated. All rights reserved.

Use of this website signifies your agreement to the Terms of Use and Online Privacy Policy (updated 07-14-2009).

Ad Choices

Reviewed by TRUSTe: site privacy statement