Skip to Content
0

JDBC Custom DataSource sap pi

Oct 09, 2017 at 11:30 AM

65

avatar image

Hi SAPiens,

Our basis have created the custom datasource (CADATACOM) in PI _dev system.

Now when I am trying to connect to DB using JDBC Receiver channel I am getting -

Could not open connection to jdbc:datacom://xxxxx:xxx/xxxxxxx/xx

Can't we use custom datasource in JDBC Adapter?

However, basis tried to ping DB from there end and they were able to hit it. It means DB is not down.

Please suggest.

BR,

Rashmi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Oct 10, 2017 at 10:45 AM
0

Hello Rashmi,
What DB vendor do you use and what kind of JDBC drivers have you deployed in PI?

Best regards,
Vadym

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadym Diachenko,

This CADATACOM database -

https://docops.ca.com/ca-datacom-tools/15-0/en/working-with-ca-datacom-server/configuring-ca-datacom-server/implement-and-configure-the-jdbc-driver#ImplementandConfiguretheJDBCDriver-JDBCArchitectureinaUNIX/LinuxEnvironment

However, jar files are not deployed on classloader instead basis did it on custom datasource... I am not sure what it is and why they deployed it on custom datasource.... Is this the reason I am unable to config my communication channel?

Should it be always classloader?

BR,

Rashmi

0
Former Member

Hello Rashmi,

As it is written on support page:

"The CA Datacom® Server JDBC driver is a JDBC 4.0 compliant driver with some exceptions. The Java classes that constitute the Server JDBC driver reside in the cadcjdbc.jar file."

We can make the following consequences:

1. The driver is JDBC 4.0 compliant so has to be supported by SAP PI software.

2. The only file deployed with com.sap.aii.adapter.lib.sda file should be the driver file - cadcjdbc.jar

Can you ensure that it was deployed in the system

The connection string in your case seems to be wrong. At least, what I found on support portal:
//jdbc:datacom//xxxxxxx:ppppp

https://docops.ca.com/ca-datacom-tools/15-0/en/working-with-ca-datacom-server/configuring-ca-datacom-server/implement-and-configure-the-jdbc-driver

I'd recommend you to check the deployed driver and try the above connection string with any 3rd-party client or DBMS able to connect to that DB. As soon as you will ensure that connection string is correct, try to configure it in JDBC channel in PI.

Best regards,
Vadym

0

Hi Vadym Diachenko

Basis created custom data source, hence they havent imported driver file - cadcjdbc.jar on com.sap.aii.adapter.lib.sda library...

Is it mandatory that jar files should be deployed on this library location only?

I am using below string URL, is that wrong ?

jdbc:datacom://HOST:PORT/ServerName=XXXX_SERVER,ApplicationID=XXXQA_SERVER

BR,

Rashmi

0
Former Member

Hello Rashmi,
All JDBC driver libraries should be deployed within com.sap.aii.adapter.lib.sda archive following recommeded way (using SUM or Telnet).

Regarding the connection string, unfortunately I cannot suggest the correct one, because never used such DB vendor service. However, preliminary connection string testing using any 3rd-party tool (as I already suggested) is highly useful in this case, because helps to ensure that connection is possible and alive and that it is not PI's failure.

Best regards,
Vadym

0