Re: AW: jca adapter for (MySQL)DB

As is stated most RDBMS connectors utilize JDBC to connect to relational
databases - and that's the right approach.

The whole point of JCA is that you have one standard interface from the app
server perspective (CCI) to connect to other systems such as SAP,
PeopleSOft, CICS etc etc. My advice if you're only going to connect to a
simple RDBMS then sure use JDBC but if the integration scenario requires
other EIS then I would go with a pure JCA approach - but look out for
connectors that support not only standard JDBC but also offer things like
stored procedures and support hierarchical relationships.

-----Original Message-----
From: A public list for J2EE Connector architecture interest.
[mailto:[email protected]] On Behalf Of Naren Chawla
Sent: Friday, August 08, 2003 9:56 AM
To: [email protected]
Subject: Re: AW: jca adapter for (MySQL)DB


Exactly. Why wouldn I use an JCA adapter to connect to rdb when there is
JDBC. Are there reasons for people to use JCA adapters to connect to
relational db's ?

--Naren



-----Original Message-----
From: A public list for J2EE Connector architecture interest.
[mailto:[email protected]]On Behalf Of Jon Dart
Sent: Friday, August 08, 2003 9:21 AM
To: [email protected]
Subject: Re: AW: jca adapter for (MySQL)DB

Note that connectivity to databases is generally accomplished in J2EE via
JDBC. You wouldn't use a Connector for direct communication with a database,
typically (the Sun JDBC Connector only does this for illustrative purposes).
Longer run it is likely we will see convergence between the Connector
Architecture and JDBC, as they are already similar in many ways. But for
right now, JDBC is the way to go for databases.

--Jon

Atul Apte wrote:
> In that case there is no need for me to send you the link for the 
> database adapter :)
>
> ----- Original Message -----
> From: "Lenharcik Juraj" <[email protected]>
> To: <[email protected]>
> Sent: Friday, August 08, 2003 9:42 AM
> Subject: AW: AW: jca adapter for (MySQL)DB
>
>
> thank you for your tipp. seems to be the right thing :-)
>
> -----Ursprüngliche Nachricht-----
> Von: Binod [mailto:[email protected]]
> Gesendet: Samstag, 9. August 2003 03:05
> An: A public list for J2EE Connector architecture interest.; 
> Lenharcik, Juraj
> Betreff: Re: AW: jca adapter for (MySQL)DB
>
>
> Please grab JDBC Connector from 
> http://java.sun.com/products/jdbc/related.html.
>
> thanks,
> Binod
>
> On Friday 08 August 2003 05:23 pm, Lenharcik Juraj wrote:
>
>>Yes I remember also. But this was only a sample adapter and to for 
>>productive usage.
>>
>>-----Ursprungliche Nachricht-----
>>Von: Binil Thomas [mailto:[email protected]]
>>Gesendet: Freitag, 8. August 2003 13:28
>>An: [email protected]
>>Betreff: Re: jca adapter for (MySQL)DB
>>
>>Lenharcik Juraj wrote:
>>
>>>does anyone knows where to get a open-source resource adapter for 
>>>MySqL or general databases?
>>
>>If I remember well, Sun did have a sample JCA adapter that connected 
>>to a database using JDBC. But I cant find it on the website right now,
>
> though.
>
>
===========================================================================
> 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".
>
>

===========================================================================
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".

===========================================================================
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".