MySQL and Flex Data Services

[Vision_Airlines]

I'm trying to figure out how to access MySQL and serve data
to clients through FDS. I have a friend that says he thinks Tomcat
is the answer to this, but he's not sure how. Does anyone here have
any suggestions? Thanks for your time.

[sanclementetech]

FDS does not connect to a database. Instead you have to use
either HTTP, WebService, Java POJO, Java Spring, Java Hibernate,
ColdFusion, or PHP. With that said, you will need an application
server as well, FDS is installed on application server. You can use
Tomcat (this is what I use), JBoss, JRun, etc.

[Pitpips]

RDBMS like MySQL, MS-SQL Server, Oracle, DB2 and so on.

Could some expert write code examples explaining the
recovering data from RDBMS via an SQL query or how can i pass my
query to the webservice and get the results data and finaly
populate my gridline... and the other way... how can i send the
content of the gridline to an update or insert query in the
webservice...

Tanks for any help.

[seth_hodgson]

I'd recommend reading through the FDS sample applications.
The samples apps demostrate data access with FDS using the
JavaAdapter and custom assemblers as well as the Hibernate
assembler.



Best,

Seth

[Bill_White]

In my Java world I use Hibernate combined with Spring classes
to read data from the database and use it in my FDS custom
assemblers.

[sanclementetech]

I agree with Bill, using Spring with HIbernate is the way to
go. Gives you more options and flexibility.