Anaplan connect error: SQL: No suitable driver found for "jdbc:oracle:thin:host:domain:port:service

Options
anilkumar.yethipathi
anilkumar.yethipathi Member, ALL USERS, Community Member Posts: 4 New Contributor
in Extensibility

Unable to connect to Oracle database using jdbc. API throwing no suitable driver found error.

 

1. Installed JDK 

2. placed ojdbc driver jar file in JDK lib directory as well as in anaplan connect directory.

 

 

Tagged:

Comments

  • anilkumar.yethipathi
    anilkumar.yethipathi Member, ALL USERS, Community Member Posts: 4 New Contributor

    tried both, still same issue. any configuration needed here?

  • anilkumar.yethipathi
    anilkumar.yethipathi Member, ALL USERS, Community Member Posts: 4 New Contributor

    I did not see any warning message in logs with loadclass. I had put -loadclass option while calling AnaplanConnect.bat. is it how it needs to be done? I don't think it is doing anything.

     

    Yes, I am using connection string as you mentioned. 1.4.1 is the version of Anaplan connect.

  • anilkumar.yethipathi
    anilkumar.yethipathi Member, ALL USERS, Community Member Posts: 4 New Contributor

    Thanks a lot @scott.smith . re-installing Java on a different directory path helped resolving this issue.

  • damianAP
    damianAP Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Contributor

    I'd always recommend exercising caution when installing a JDK, it will often reap dividends to install it in a directory containing no spaces, often minimising the directory path length (ie. c:\jdk) as spaces can cause issues when defining search paths, environment variables etc. 

Categories