postgreSQL driver in bamboo

[Deleted user]

i want to develop a bamboo plugin, and i need to test  it in a safe environment.

i installed bamboo server on my macbook, and postgres.app for the database.

I used this to connect to the database using jdbc, but I get the error

No suitable driver found for jdbc:postgresql://localhost:5432/bamboo

I tried including

Class.forName("org.postgresql.Driver");

in my java class, but it does not find the class.

How do I include the driver in my plugin ?

[edwin]

You'll have to add the jdbc driver into the /lib directory of tomcat for Bamboo

https://jdbc.postgresql.org/download.html

and then restart bamboo

[Deleted user]

I don't find a tomcat directory, where is it ?

I tried adding the jar to

${bambooHome}/atlassian-bamboo/WEB-INF/lib/

but it does not work

[edwin]

How did you install your bamboo?

[Deleted user]

I downloaded the archive here https://confluence.atlassian.com/bamboo/installing-bamboo-on-mac-os-x-289276789.html

for writing the plugin I installed atlassian sdk using homebrew.

[edwin]

Try ${bambooHome}/lib then check that you have the driver that matches your postgres version

[Deleted user]

I tried different locations

${bambooHome}/lib
${bambooHome}/atlassian-bamboo/WEB-INF/lib
${bambooHome}/atlassian-bamboo/lib

and none of them worked.

do I need to include the driver in the pom.xml of the plugin ?

if so, How do I do that ?

[edwin]

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

[Deleted user]

I have downloaded the latest jdbc jar in this folder, but it still does not find it, I have bamboo 5.15.5 with java 8 and postgreSQL 9.6, so I used the 4.2 version.

[Deleted user]

I tried

DriverManager.getDrivers()

and it return an empty list

[edwin]

http://www.programcreek.com/java-api-examples/index.php?class=java.sql.DriverManager&method=getDrivers

Maybe that will help