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

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)

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published yesterday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

66 views 0 5
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