No suitable driver found for jdbc:sqlserver = How to connect plugin to External Postgres database

Question

Hi all, I get an issue concerning a plugin I am working on. I have to execute postgres request from a Jira plugin. I had a the following dependencies in the POM.XML org.postgresql postgresql 42.2.14 provided When I ran the servlet to access the DB : try (Connection connection = DriverManager.getConnection("jdbc:postgresql://localhost:5432/example", "postgres", "postgres")) I get the following error => No suitable driver found for jdbc:sqlserver Can you please help me about that ? In advance thank you :) , Kind regards, PAB.

Nic Brough -Adaptavist- · Answer

I am really very sorry, I do not know how to draw a database driver into a plugin build.

I do not know if it is even possible.  Part of my memory is insisting that if you want to connect to a database, the driver needs to be installed in Tomcat, which is something an application plugin cannot do.  I am probably wrong, I suspect there's a way to do it, but I really do not know.

But I can tell you that a mention in a pom.xml is not the right route, if it can be done, it's not that simple.

I am only familiar with installing the database connecting drivers manually in Tomcat.  (I say "familiar" - I mean "get the right .jar and copy it into tomcat/lib" - not really complex engineering there)

Paul-Antoine Bonlieu · Answer

Hi Nic,

Thank you for your answer.

My goal is to embed the Driver with the Jira Plugin.

Is is possible to realize this action by configurating the Pom as I made ?

In advance thank you,

Kind regards,

Paul.

Nic Brough -Adaptavist- · Answer

Doesn't the database driver jar have to be installed in the Tomcat, not the plugin?