Skip to Content
avatar image
Former Member

jdbcSystem alias for MaxDB connexion

Hi all,

I'm trying to connect to a MaxDB Data Base called EPD but I think I'm using a wrong system alias. This is the code:

IConnection connection = null;
String jdbcSystem = "jdbc/EPD";
IConnectorGatewayService cgService = (IConnectorGatewayService)WDPortalUtils.getServiceReference(IConnectorService.KEY);
	try{
	IWDClientUser usuari = WDClientUser.getCurrentUser();
	ConnectionProperties cp = new ConnectionProperties(Locale.getDefault(),usuari.getSAPUser());
	connection = cgService.getConnection(jdbcSystem, cp);
	}catch (Exception e){}

So I get this exception:

com.sapportals.portal.ivs.cg.SystemNotFoundException: Failed to get system null

Could anyone tell me please what to write in the string:

String jdbcSystem = "jdbc/EPD";

??

Thanks all in advance,

Ivan,

Message was edited by: Ischia Ivan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 27, 2006 at 10:34 AM

    1. logon to visual administrator tool of the engine and click on Server0->Services->JDBC Connector.

    2. LOOK resource select Resources->DataSources.

    3. LOOK the Aliases list add the DB Alias

    Usually are: DataSources -> SAP<SID>DB (<SID> System ID)

    Alias -> SAP/PDIM

    So:

    String jdbcSystem = "jdbc/SAP<SID>DB";

    or

    String jdbcSystem = "jdbc/SAP/PDIM";

    Message was edited by: Roberto Tagliento

    Add comment
    10|10000 characters needed characters exceeded