Re: JCA on Web server

I think you will get the best results by using a jca adapter in an app
server rather than jco plain.  My impression is that jco does not deal
well with connection pooling.

Since you are already using Tomcat, I recommend using JBoss 3.2 with
Tomcat.  You will be able to deploy any of the JCA SAP resource
adapters and use them without needing ejbs.  I would recommend,
however, simply from an architectural viewpoint, to consider ejbs or at
least servlets to separate view and data model at least slightly.

I would investigate the 3rd partly jca sap adapters.  Several appear to
offer significantly enhanced functionality over the  (very hard to
obtain) adapter from SAP.  At least one seems to have a framework for
generating jsps to view  SAP data with no coding.  I have worked
(slightly) with adapters from ASAP and Insevo in JBoss.

http://www.asapsolutions.com
http://www.insevo.com

I haven't tried this one:
www.ibm.com/software/ts/mqseries/adapter/ws/library/mysap/factsheet.htm

david jencks

On Tuesday, March 18, 2003, at 03:37 AM, Lim Huat Heng wrote:

> To anyone who may advice:
>     I am currently evaluating the feasibility of integration between a
> web- based application (written in JSP and running on Jakarta Tomcat)
> and SAP system, in which, I will only want to 'download' data from > SAP.
>     I have searched in the Internet and found that there are few
> architectures that could help me in achieving the objective. However,
> I am confused and would like anyone who may advice to clear my
> following doubts:
> 1) What is the differences between J2EE Connector Architecture (JCA)
> and SAP Java Connector (JCO)?
> 2) Does J2EE Connector Architecture really need to be implemented on
> an application server? In order words, can I achieve the above
> objective by using JCA but still running the system on web- server
> (particularly Jakarta- Tomcat)
> 3) What is the best practice to develop such a system (to achieve the
> above objective)?
> 4) Any good examples/ references (including source code/ demo page)
> that I could refer to?
>      Thanks.
>
> =======================================================================
> ====
> To unsubscribe, send email to [email protected] and include in the
> body
> of the message "signoff CONNECTOR-INTEREST".  For general help, send
> email to
> [email protected] and include in the body of the message "help".
>

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff CONNECTOR-INTEREST".  For general help, send email to
[email protected] and include in the body of the message "help".