Skip to Content
0
Former Member
Apr 21, 2008 at 04:29 PM

Connect to JDBC

39 Views

Hello experts,

Im trying to access a JDBC provider as explained at: http://help.sap.com/saphelp_nw04/helpdata/en/30/a0f17aacb34b108b39a96acc33da3f/content.htm

The code is as follows:

IConnection connection = null;
// get the Connector Gateway Service

String jdbcSystem = "pubs";
IConnectorGatewayService cgService = (IConnectorGatewayService)

         PortalRuntime.getRuntimeResources().getService(IConnectorService.KEY);

ConnectionProperties cp = new ConnectionProperties(portalRequest.getLocale(),

         portalRequest.getUser());    

try {
    connection = cgService.getConnection(jdbcsystem, cp);

} catch (Exception e) {
} finally {

    try {

        if (connection != null) {

            connection.close();

        }

    } catch (ResourceException re) {

    }

}

Now the NWDS tells me that: This compilation unit indirectly references the missing type com.sap.portal.services.api.connectorgateway.IConnectorGatewayService (typically some required class file is referencing a type outside the classpath) UserPojo.java my_Web_std/source/mycompany line 0

Which is the .jar file that I need to add to the class path, and where can I find that?

Thanks in advance,

Florian