jdbcSystem alias for MaxDB connexion

[Former Member]

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

[roberto_tagliento · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Roberto,

it looks it works but i continue having de same exception,

I found out that the DataSource is called SAPEPDDB and there are several ALIASES,

for examble: SAP/BC_UME assigned as:

ALIAS----

---

>SAP/BC_UME

DEPLOYER----

---

>SAPEPD DataSource

so that, I write

String jdbcSystem = "jdbc/SAP/BC_UME";

or

String jdbcSystem = "jdbc/SAPEPDDB";

and I don't get it to work, do you think I may add a new ALIAS, for example MY_ALIAS??

and then try

String jdbcSystem = "jdbc/MY_ALIAS"; ??

thansk,

[roberto_tagliento · Accepted solution]

Did you tried with:

String jdbcSystem = "SAP/BC_UME";

or

String jdbcSystem = "SAPEPDDB";

???

This is a GUESS!! 😛

Wait Valery Silaev, he will have the answer!

Message was edited by: Roberto Tagliento

[Former Member · Accepted solution]

Yes, i trid those both,

and they didn't work. Anyway i feel good to hear that It's just a guess, so i will continue trying.

In another sap forum I've read opction like:

Sting jdbcSystem = "jdbc:sapdb/host_name/syste_name";

could you tell if it is correct?

Thanks very much!!

[roberto_tagliento · Accepted solution]

Sorry nothing to say, it's bad say GUESS and TRY.

Have also other to do and searching.

I don't have much experience.

Valery probably (surely) will answer to you