[flexcoders] FLex Java ASP SQL Server
Hi, I just saw the possibility of flex 2 and I was wondering if it was possible to retrieve data from an SQl server, like (microsoft SQL or MySQL). I understood that we could do this using php or java.. but I didn't found anything usefull on google.. Can't we connect directly to the SQL server?? So if you have any link explaining how to do it, i would very much appreciate. Thanks and Regards, Ponnusamy V Yahoo! Groups Sponsor ~-- Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM ~- -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [flexcoders] FLex Java ASP SQL Server
slightly more helpful link... http://msdn.microsoft.com/library/default.asp?url=""> On 10/25/05, Clint Modien [EMAIL PROTECTED] wrote: this would be a very poor architecture for a web application but you could use sqlxml to directly access sql server via http... http://msdn.microsoft.com/library/default.asp?url="" On 10/25/05, yourponnusamy [EMAIL PROTECTED] wrote: Hi,I just saw the possibility of flex 2 and I was wondering if it waspossible to retrieve data from an SQl server, like (microsoft SQL or MySQL).I understood that we could do this using php or java.. but I didn'tfound anything usefull on google..Can't we connect directly to the SQL server??So if you have any link explaining how to do it, i would very much appreciate.Thanks and Regards,Ponnusamy V Yahoo! Groups Sponsor ~--Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM~- --Flexcoders Mailing ListFAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links* To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com YAHOO! GROUPS LINKS Visit your group "flexcoders" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [flexcoders] FLex Java ASP SQL Server
Ponnusamy, I just saw the possibility of flex 2 and I was wondering if it was possible to retrieve data from an SQl server, like (microsoft SQL or MySQL). I understood that we could do this using php or java.. but I didn't found anything usefull on google.. Can't we connect directly to the SQL server?? So if you have any link explaining how to do it, i would very much appreciate. Thanks and Regards, Ponnusamy V Flex 2.0 is still an alpha technology, and so the featureset is still very much being defined. Furthermore, the enterprise data services have not shipped with the current Alpha, and this is the piece of interest to you. In terms of retrieving data from a SQL Server installation; with Flex 2.0 data services, you can do this with a Service Oriented Architecture (SOA) OR with a Data Oriented Architecture (DOA). With an SOA, you'd do this exactly the same as you would for Flex 1.x; have a middleware tier (most likely Java accessed by RemoteObject, but could be any other technology exposed as a SOAP WebService) that performs your CRUD operations (Create/Read/Update/Delete) between Flex and your database. In Flex 2.0, this will become known as RPC Services, as you will remotely invoke procedure calls on the server. With a data oriented architecture, you will be able to use the new open-adapter architecture for Flex 2.0, which provides seamless integration with data services through a number of adapters. At MAX in Anaheim, a number of proposed adapters were presented (no decisions have been made as to which adapters will ship) including an object adapter, a Hibernate adapter, a JDBC adapter and a Coldfusion Adapter. The adapters abstract and remove the complexity of writing your own CRUD code into configuration in a deployment descriptor (much like flex-config.xml) in most instances. The motivation for a DOA is that if your need for persistence is simply to create, read, update and delete to a database, that you care about synchronisation, offline operation, and have very little additional business logic (services) between client and database, then you can remove much of the drudge work of writing CRUD code, and gain a whole load of enterprise-class services (such as sychronisation) in addition. You can keep your serverless Flex compilation, this to me is the step-change in Flex 2.0 :-) Now it was presented (and reiterated by Stephen Elop in the quarterly investors call last night) that this adapter architecture would be an open-architecture; meaning that there will be a well defined API against which people can write their own adapters. There's nothing to say that someone could not write an adapter that offered tighter integration with SQL Server through the .NET APIs (ADO.NET) if you required. So to summarise the answer to your question; if you have data in a SQL server database, you can integrate that into your Flex apps today using RemoteObject, WebService or HTTPService and a middle tier proxying between Flex and your database. There may even be other strategies; some databases will now expose stored procedures as Java classes or SOAP Web Services on your behalf, reducing the effort in coding your midtier. Tomorrow, with Flex 2.0, this option will continue to be available to you, but the Flex Enteprise Data Services architecture will offer you even more powerful mechanisms by which to integrate an RIA experience with a database persistence tier. William Wechtenhiser, the Director of Engineering for Flex Enterprise, has written a tremendous article on Flex Data Services over on Macromedia Labs, that you can find here: http://labs.macromedia.com/wiki/index.php/Flex_Enterprise_Services:Data_ Services That might give you some insight into what Flex 2.0 is going to offer us. Exciting times for Enterprise RIA ! Best wishes, Steven -- Steven Webster RIA Practice Director (EMEA) Macromedia Consulting Office: + 44 (0) 131 338 6108 Mobile: +44 (0) 7917 428 947 Yahoo! Groups Sponsor ~-- Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM ~- -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [flexcoders] FLex Java ASP SQL Server
nice... thanks for the tidbits steven... On 10/25/05, Steven Webster [EMAIL PROTECTED] wrote: Ponnusamy, I just saw the possibility of flex 2 and I was wondering if it was possible to retrieve data from an SQl server, like (microsoft SQL or MySQL). I understood that we could do this using php or java.. but I didn't found anything usefull on google.. Can't we connect directly to the SQL server?? So if you have any link explaining how to do it, i would very much appreciate. Thanks and Regards, Ponnusamy VFlex 2.0 is still an alpha technology, and so the featureset is still very much being defined.Furthermore, the enterprise data services havenot shipped with the current Alpha, and this is the piece of interest toyou.In terms of retrieving data from a SQL Server installation; with Flex 2.0 data services, you can do this with a Service Oriented Architecture(SOA) OR with a Data Oriented Architecture (DOA).With an SOA, you'd do this exactly the same as you would for Flex 1.x;have a middleware tier (most likely Java accessed by RemoteObject, but could be any other technology exposed as a SOAP WebService) thatperforms your CRUD operations (Create/Read/Update/Delete) between Flexand your database.In Flex 2.0, this will become known as RPCServices, as you will remotely invoke procedure calls on the server. With a data oriented architecture, you will be able to use the newopen-adapter architecture for Flex 2.0, which provides seamlessintegration with data services through a number of adapters.At MAX inAnaheim, a number of proposed adapters were presented (no decisions have been made as to which adapters will ship) including an object adapter, aHibernate adapter, a JDBC adapter and a Coldfusion Adapter.Theadapters abstract and remove the complexity of writing your own CRUDcode into configuration in a deployment descriptor (much like flex-config.xml) in most instances.The motivation for a DOA is that if your need for persistence is simplyto create, read, update and delete to a database, that you care aboutsynchronisation, offline operation, and have very little additional business logic (services) between client and database, then you canremove much of the drudge work of writing CRUD code, and gain a wholeload of enterprise-class services (such as sychronisation) in addition. You can keep your serverless Flex compilation, this to me is thestep-change in Flex 2.0:-)Now it was presented (and reiterated by Stephen Elop in the quarterlyinvestors call last night) that this adapter architecture would be an open-architecture; meaning that there will be a well defined API againstwhich people can write their own adapters.There's nothing to say thatsomeone could not write an adapter that offered tighter integration with SQL Server through the .NET APIs (ADO.NET) if you required.So to summarise the answer to your question; if you have data in a SQLserver database, you can integrate that into your Flex apps today using RemoteObject, WebService or HTTPService and a middle tier proxyingbetween Flex and your database.There may even be other strategies;some databases will now expose stored procedures as Java classes or SOAP Web Services on your behalf, reducing the effort in coding your midtier.Tomorrow, with Flex 2.0, this option will continue to be available toyou, but the Flex Enteprise Data Services architecture will offer you even more powerful mechanisms by which to integrate an RIA experiencewith a database persistence tier.William Wechtenhiser, the Director of Engineering for Flex Enterprise,has written a tremendous article on Flex Data Services over on Macromedia Labs, that you can find here:http://labs.macromedia.com/wiki/index.php/Flex_Enterprise_Services:Data_Services That might give you some insight into what Flex 2.0 is going to offerus.Exciting times for Enterprise RIA !Best wishes,Steven--Steven WebsterRIA Practice Director (EMEA) Macromedia ConsultingOffice: + 44 (0) 131 338 6108Mobile: +44 (0) 7917 428 947 Yahoo! Groups Sponsor ~--Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM~--- Flexcoders Mailing ListFAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txtSearch Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups Links* To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED]* Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com YAHOO! GROUPS LINKS Visit your group "flexcoders" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED]