It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

postgreSQL driver in bamboo Edited

bbanakaffalatta Apr 19, 2017

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 ?

3 answers

1 vote
Edwin Kyalangalilwa Community Leader Apr 19, 2017 • edited

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

bbanakaffalatta Apr 20, 2017 • edited

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 Kyalangalilwa Community Leader Apr 20, 2017

How did you install your bamboo?

bbanakaffalatta Apr 20, 2017 • edited

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 Kyalangalilwa Community Leader Apr 20, 2017 • edited

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

Screen Shot 2017-04-20 at 10.36.33.png

0 votes
bbanakaffalatta Apr 20, 2017

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.

bbanakaffalatta Apr 20, 2017

I tried

DriverManager.getDrivers()

and it return an empty list

0 votes
bbanakaffalatta Apr 21, 2017

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 Kyalangalilwa Community Leader Apr 22, 2017

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Here’s what we’re doing to make Jira Cloud faster

Hello Community 🤗 I’m Nikhil, a Product Manager on the Jira Cloud team working on performance improvements. Performance is an ongoing journey and we continue to invest heavily in it. We under...

101 views 0 16
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you