Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question