Pros and Cons of using JBDC Adapter with XI

[gopalkrishna_baliga]

Hi Experts,

Can somebody help me understand pros and cons in using different JDBC adapters with XI?

I would be really greatful to you.

Thanks & Regards

Gopal

[Former Member]

Besides all that has been replied before, I'd add the following :

- because JDBC relies on SQL statements, if they are poorly designed, they can create a lot of performance issues (it is sometimes very easy to fall into this trap, believe me, I did) at both end of the driver (XI and database)

- you must take the right decision regarding isolation level, to avoid consistency issues when accessing records/tables/... at the same time (at least for upd/del/ins statements)

Rgds

Chris

[Former Member]

Hai,

Go through the links:

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

http://help.sap.com/saphelp_nw04/helpdata/en/44/f565854b7341e6e10000000a1553f6/frameset.htm

Thanks,

Rajani.

[Former Member]

Hi,

XI supports all databases that have JDBC drivers,

Most of the databases have JDBC drivers and hence, XI supports nearly all databases,

Xi adapter allows you to talk to any database, but requires drivers from the the corresponding vendors.

Check This link

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards,

Ramesh.