Flex with Oracle 10g

Question

Hi,

I am new to Flex 3/4 and was after some help with what is involved (examples pls) in creating an application in flex that runs off an Oracle 10g database to both retrieve/modify data from, with flex.

Basically would like to know how to connect flex to an oracle database to perform database transactions like updates/deletes/inserts.

Thanks.

Answer 1

I use GraniteDS which is a bit complicated and takes time to learn, if you want something more simple then use Adobes BlazeDS, and more simple still use PHP (http://www.adobe.com/devnet/flex/flex_php.html).

Answer 2

Adobe Flex 3 Help - About data access:

The Flex SDK contains features for accessing server-side data. Flex data access components are based on a service-oriented architecture (SOA). These components use remote procedure calls to interact with server environments, such as PHP, Adobe ColdFusion, and Microsoft ASP.NET, to provide data to Flex applications and send data to back-end data sources.

Personally I prefer Java with the BlazeDS/Spring/Hibernate stack. For tutorials look at the Adobe Developer Connection:

• Adobe Flex, BlazeDS, and Hibernate JPA on Tomcat and MySQL
• The Flex, Spring, and BlazeDS full stack