JCA implementation ?

[Former Member]

We should connect to R/3 with using the SAP Connector Framework(JCA

1.0) ,get some data,

and show them in our EP portal system(EP6 SP2 - WAS 6.2 - SAP R/3

4.70)

We tried to implement JCA. but It's a problem to implement JCA.

EP6 sp service document say that With the connector service you can

connect to a SAP system.

but With EP Serviec document sample code for connection to a SAP

system,

We can't connet to a SAP system(R/3) With the connetor service

////////////////////////////////////////////////////////////////////////

//////////////////

// sample code for a connection to a SAP system

IConnection connection = null;

try { // get the Connector Gateway Service

Object connectorservice =

PortalRuntime.getRuntimeResources().getService(

IConnectorService.KEY);

IConnectorGatewayService cgService =

(IConnectorGatewayService) connectorservice;

if (cgService == null) {

response.write("Error in get Connector

Gateway Service <br>");

}

try {

connection = cgService.getConnection

(sapsystem, request);

} catch (Exception e) {

response.write("Connection to SAP system

failed <br>");

}

if (connection == null) {

response.write("Connection is null <br>");

}

else {

response.write("Connection succesful");

}

} catch (Exception e) {

response.write("Exception occured");

}

////////////////////////////////////////////////////////////////////////

///////////////////

sample source code execute result:

SimpleSapConnection: the SystemIdentifier is: PDK_R3_BACKEND

Connection is null

I want to know why this sample code not excute and

EP6 sp2 not yet support the SAP Connector Framework(JCA 1.0) with

the connetor service

[Former Member]

Hi

I have the same problem.

I have tried to update SharingReference in the PortallApp.xml. This gave some new error messages telling me that some of the jar's couldnt be found. Then i found these jars and placed them where they could be found. Still it doesnt work. There seems to be a problem with the IConnectorGatewayService

This is the error message that i get:

Portal Runtime Error

<b>An exception occurred while processing a request for :

iView : BudgetViewer.BudgetStatus

Component Name : BudgetViewer.BudgetStatus

com/sapportals/portal/ivs/cg/IConnectorGatewayService.

Exception id: 11:09_21/04/04_0050

See the details for the exception ID in the log file</b>

Did you find a solution?

By the way, does anybody know where to find that logfile?

TIA

kr Henrik

[Former Member]

Hi

Heres the logfile:

<J2EE_HOME>\cluster\server\managers\log\portal\logs\portal.log

kr

Henrik

[Former Member]

Hi

1. Make sure that you have a system with alias PDK_R3_BACKEND

2. log on as a user that is also a R/3 user

3. go to java development in the portal, select component inspector. Select com.sap.portal.pdk.srv.sapconnector and add to favorites.

4. Start SimpleSapConnection.

If it works then you are ready to proceed with your own code.

Else your systems are not properly configured/installed, and somebody has to do something...

5. Then you look at the samples portalapp.xml and here you find all the necessary SharingReference settings.

Good luck.

Kr Henrik

[former_member110461]

Have you checked whether you can connect to the system e.g. create a simple SAP transaction iview. Is your user mapping set up too?

Paul

Message was edited by: Paul Tomlinson

[Former Member]

we created a simple transaction iview and user mapping set up and tested transaction iview.

taracton iview can connect to R/3system very well.

but We can't connet to a SAP system(R/3) With the connetor service

I want to know why this sample code not excute