Date:         Thu, 7 Jul 2005 16:47:40 +0100
Reply-To:     Phil Mason <woodstreet@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Phil Mason <woodstreet@GMAIL.COM>
Subject:      What is the best way to call a stored process from Java
Content-Type: text/plain; charset="us-ascii"

we currently call stored processes from Java using some code we wrote that
uses Foundation Services (SAS 9.1.3). This was based on an example provide
by SAS UK. Now we are questioning whether this is the best way and are
considering the following:

1 - Using the SAS Stored Process Web Application (comes with the Web
Infrastructure Kit). We have been told this is the recommended way.

2 - Using Foundation Services (as we currently do) - which I have heard is
not recommended.

3 - Messaging, using a JMS (Java Message Service) adaptor - which is kind of
like email for programs.

4 - Creating a java web service and using that - which is SOAP driven but
well supported by SAS.

5 - Using JCA (J2EE Connector Architecture), which those in the Java world
say is the best way.

I dont know much about Java and have to advise my software architects what
to do. Does anyone have any idea of the pros & cons of these approaches? It
would be very useful.

thanks
Phil Mason