Pocketquery: Cant connect using Postgresql driver

Hi Support,

Description

Just installed the Pocketquery addon. Using the JDBC postgresql driver. The JDBC postgresql driver is also configured for Confluence to connect to the Confluence database so i know its working correctly.

Log output

2015-08-14 15:46:13,455 DEBUG [http-nio-8091-exec-7] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: Failed to connect to database bier!
2015-08-14 15:46:13,456 DEBUG [http-nio-8091-exec-7] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: There was an error: I cannot connect to this database. For inspection, add a logging entry with level debug and class "de.scandio.confluence.plugins.pocketquery.util.LogUtil" at Confluence Admin => "Logging and Profiling". PocketQuery will then log information to atlassian-confluence.log.
2015-08-14 15:49:26,465 DEBUG [http-nio-8091-exec-2] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: New message: pocketquery.admin.success.database.add
2015-08-14 15:49:27,663 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: Testing database bier
2015-08-14 15:49:27,665 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: Testing database connection bier | bier.***.local | jdbc:postgresql://bier.***.local:5432/bier | bier
2015-08-14 15:49:27,666 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: Trying to load database driver jdbc:postgresql://bier.***.local:5432/bier
2015-08-14 15:49:27,668 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: I could not load the driver =(. Exception info: name, java.lang.IllegalArgumentException: name
2015-08-14 15:49:27,669 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: There was an SQLException when testing the connection =(. Info: Cannot instantiate JDBC driver class jdbc:postgresql://bier.***.local:5432/bier: name, java.sql.SQLException: Cannot instantiate JDBC driver class jdbc:postgresql://bier.***.local:5432/bier: name
2015-08-14 15:49:27,670 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: Failed to connect to database bier!
2015-08-14 15:49:27,671 DEBUG [http-nio-8091-exec-12] [plugins.pocketquery.util.LogUtil] debug ====> PocketQuery says: There was an error: I cannot connect to this database. For inspection, add a logging entry with level debug and class "de.scandio.confluence.plugins.pocketquery.util.LogUtil" at Confluence Admin => "Logging and Profiling". PocketQuery will then log information to atlassian-confluence.log.

But the driver is installed

confluence:/var/atlassian/application-data/confluence/logs# ls /opt/atlassian/confluence/confluence/WEB-INF/lib/ | grep sql
hsqldb-2.3.0.jar
postgresql-9.2-1002.jdbc4.jar

Psql client

No problem connecting from the Confluence server using psql-client package from the debian repo.

confluence:~# psql -U bier -h bier.***.local 
Password for user bier: 
psql (9.1.16)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

bier=> \q

Sysinfo

  • Debian Wheezy 7.8 x64
  • Confluence 5.8.6
  • PocketQuery 1.14.7

Question

  • Should i install the latest JDBC postgres jar?
  • Can i use that JAR next to the current 9.2 JAR ?
  • What would support advice me to do?

 

Much thanks in advanced.

Regards,

Michael Akkermans

 

2 answers

This widget could not be displayed.

Hi Jeffrey,

Thank you for your interest in PocketQuery!

Cannot instantiate JDBC driver class jdbc:postgresql://bier.***.local:5432/bier

At first glance, it looks like you entered the JDBC URL in the driver field. The driver should be "org.postgresql.Driver". Or am I wrong here?

Regards, Felix (Scandio)

This widget could not be displayed.

Spot-on! Thanks very much @Felix Grund (Scandio) smile

Thanks! If that solved your issue, it would be nice if you accepted my answer. And even better would be a little review on the marketplace if you like PocketQuery and haven't done so yet. Thank you for support :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

524 views 3 19
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you