Pocketquery: Cant connect using Postgresql driver

[Jeffrey Kramer]

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

[Felix Grund (Scandio)]

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)

[Jeffrey Kramer]

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

[Felix Grund (Scandio)]

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 :)