How can I resolve "org.postgresql.Driver" not found in my bitbucket server plugin?

[David Schlesinger]

I'm writing a bitbucket server plugin that writes to an external postgresql DB. I'm using PostgreSQL JDBC and getting the following error when calling  Class.forName("org.postgresql.Driver") :

java.lang.ClassNotFoundException: org.postgresql.Driver not found

I've tried adding the following to my pom.xml but it results in the plugin failing to install:

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.4.1212</version>
        </dependency>

How can I write to an external PostgreSQL DB from my plugin?

[Rick Ding · Accepted solution]

Hi, have you solve the problem? I meet the similar question, I want to add mysql-connector-java.jar but failed...

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
            <scope>compile</scope>
        </dependency>

if you solve the problem, please reply me,thanks a lot.

[David Schlesinger]

So one way to deal with this issue is to manually load the jar you want to use at runtime. This page was helpful: http://www.kfu.com/~nsayer/Java/dyn-jdbc.html

[Rick Ding]

Thank you very much, you help me solve the problem which trouble me for one week. I sincerely appreciate you very much.

[Edwin Kyalangalilwa]

Try adding the jar file into 

CATALINA_HOME/lib/