tag:blogger.com,1999:blog-27532376.post115832710070166442..comments2023-09-09T13:31:19.025+00:00Comments on Susan Duncan: SOA and the Database - Heresy?Susanhttp://www.blogger.com/profile/14630880123112351682noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-27532376.post-22040796776332228892008-04-21T14:32:00.000+00:002008-04-21T14:32:00.000+00:00Veniamin, both approaches are ways to consider. Th...Veniamin, both approaches are ways to consider. This might not be the answer you want to hear though! If you want to the loosely coupled approach then using ESB is a good choice. ADF BC or other technology is also viable if you don't need such loose coupling. There are many articles on OTN that might help you make that decision.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-27532376.post-42664596605143151622008-02-14T11:02:00.000+00:002008-02-14T11:02:00.000+00:00Susan, we have another dilema - should we use Web ...Susan, we have another dilema - should we use Web Services to query list of data from database (using Oracle ESB DB Adapter for example) to better suite SOA and be more loosely coupled, or it is still fine to get the data using ADF BC or similar?<BR/><BR/>Which way to consider? <BR/>Thanks.Veniamin Goldinhttps://www.blogger.com/profile/01681616181105728907noreply@blogger.comtag:blogger.com,1999:blog-27532376.post-1159896946089769762006-10-03T17:35:00.000+00:002006-10-03T17:35:00.000+00:00Thank you for your interest.We have a workforce au...Thank you for your interest.<BR/><BR/>We have a workforce automation project developed using J2EE components.<BR/><BR/>This project has been extended with a voice portal.<BR/><BR/>The voice gateway uses low REST services so we did a J2EE prototype but the perforance was no so good.<BR/><BR/>So we decided to go for full PL/SQL services, all hands made, to get performance and quick agile development.<BR/><BR/>We used APEX to create the configuration and the administration panels for the mobile devices, as well as we used APEX to test quickly all the servcices.<BR/><BR/>In this way we were able to show the users the voice behaviour and the visual behaviour of the application at the same time.<BR/><BR/>I think APEX is a great product and I would like to use an Oracle PL/SQL based SOA framework as well.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-27532376.post-1158860590335882362006-09-21T17:43:00.000+00:002006-09-21T17:43:00.000+00:00Tom,I am interested also. Was your final UI using...Tom,<BR/>I am interested also. Was your final UI using HTMLDB (now Apex) or was that just used for prototyping.<BR/><BR/>PatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-27532376.post-1158626601904461722006-09-19T00:43:00.000+00:002006-09-19T00:43:00.000+00:00We are also using only Oracle 10g in two applicati...We are also using only Oracle 10g in two applications we are creating now. The interface being developed in Adobe Flex 2.0 communicates with the database using DBMS_EPG where we call packages and procedures which return XML messages (we build the message using the various XML built-in packages and functions provided by Oracle). So far we are very happy in terms of security, flexibility and performance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-27532376.post-1158567401726072222006-09-18T08:16:00.000+00:002006-09-18T08:16:00.000+00:00This sounds like an interesting project. What are ...This sounds like an interesting project. What are you using for the UI, did you use J2EE components, did you use a development tool? I'd love to hear more. Email me privately if you preferSusanhttps://www.blogger.com/profile/14630880123112351682noreply@blogger.comtag:blogger.com,1999:blog-27532376.post-1158333981454292922006-09-15T15:26:00.000+00:002006-09-15T15:26:00.000+00:00Our latest SOA project uses only an Oracle 10g dat...Our latest SOA project uses only an Oracle 10g database.<BR/><BR/>The application layers are split in different packages.<BR/><BR/>All the low REST services are implemented in PL/SQL using the XMLDB and the MOD_PLSQL.<BR/><BR/>The development has been test driven with the help of utPLSQL.<BR/><BR/>All the services can be tested trought an HTMLDB application.<BR/><BR/>The develop and deploy processes are very agile with this approach.<BR/><BR/>We have a lot of experience in developing SOA projects in java, but this time it's been easier, faster, and the performance are very impressive.Anonymousnoreply@blogger.com