Connecting to R/3 database using JDBC or JCO

[Former Member]

How do I connect to R/3 Database using either JDBC : ODBC drivers or JCO to retrieve data from the transparent tables using JSP on the Netweaver Development Studio.

[Former Member]

Hi Sandeep,

Did the replies help? If so, don't forget to assign points. I gave them some, but feel free to increase them! Click on the Yellow Star icon in each reply. You can give:

1 10 pointer (solves problem)

2 6 pointers (very helpful)

lots of 2 pointers (helpful)

Thanks!

Joan (and Mark Finnern)

[Former Member]

Mr Sandeep,

U attended a state of the art training at SAP bangalore and yet u don't know how to connect to SAP through ur JAVA Code..

Strange uhh!!!

It seems u need to attend that SAP Was Training once again!!!!!!!!!!!

[Former Member]

Hi Sandeep,

SAP recommends using JCA instead of JCo. I came across a nice article with an example included. Just search for "JCA on EP6 Building Portal Applications " on SDN website. hope u like it

[gregorw]

Or use this link:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/jca on ep6 building portal applications.zip

[Former Member]

Hi Sandeep

It is recommended not to read the SAP database directly . I would suggest you write remote function modules that does the actual read and call that instead.

Regards

Pran

[Former Member]

My question is how?

Is there any sample code which will show how JCo is usedto retrieve data from the transparent tables.

[gregorw]

Hello Sandeep,

look at the examples coming with JCo.

Regards

Gregor

[Former Member]

The best way, I think, is using JCO connecting R/3 via RFC creating your own bapi if needed.

Only use JDBC if you're going to select content from single master table.

best regards!