Skip to Content

Connecting to Quality EP Portal Datase from Development EP Portal

hi Team,

We are working on EP Server 7.4 Net weaver version.

We have portal Data base in quality & development, with JDBC drivers,

Currently i need to connect to Quality Portal Dase from a WDJ Component in Deployed in Development Portal.

the below code am using but getting error

": java.sql.SQLException: No suitable driver found for jdbc:SAP://ch*******:30015 at java.sql.DriverManager.getConnection" .


Code for connecting to Data base am using :

InitialContext ctx = null;
 Connection con = null;
ctx = new InitialContext();

con = DriverManager.getConnection("jdbc:SAP://ch******:30015","userid","PW"); 

Kindly let me know to fix the issue.

Regards

Govardan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 24 at 09:38 PM

    Dear Govardan,


    In case you want to use JDBC driver you need to maintaint the correct driver and correct URL for it. Depending on what kind of driver see example settings in wiki:


    https://wiki.scn.sap.com/wiki/x/KAK6GQ


    Best regards,
    Barnabás Paksi

    Add comment
    10|10000 characters needed characters exceeded

    • hi Barnabas,

      I have maintained all drivers properly,

      Im using below

      con = DriverManager.getConnection("jdbc:sap://hostname:30047",user,password);

      earlier since 30015 a wrong port was used i was unable to connect now after using 30047 am facing issue, as Invalid Authentication as shown below. It specifies Invalid Authentication, but am using proper user name and password i.e. user id dbadmin with Administrator Rights.

      Am able to login with dbadmin via portal login i.e. http://Hostname:port/irj/portal

      sql-exception.png (19.5 kB)