This is not a valid database name

Question

Hi,

I got stuck with the "not valid database" -error when trying out PocketQuery. I'm using MySQL and the testdb -database is in the same MySQL-instance as confluence. Confluence works fine.

Parameters entered in Database Management:

* Name: MySQL vega

* Url: jdbc:mysql://localhost/testdb

* Driver: com.mysql.jdbc.Driver

* User: root

* Password: *****

I tried out also Bob Swifth's SQL plugin which worked fine with the same set of parametres

(new Data source added to confluence tomcat's server.xml

<Resource name="jdbc/testdbDS"
                                auth="Container"
                                type="javax.sql.DataSource"
                                driverClassName="com.mysql.jdbc.Driver"
                                url="jdbc:mysql://localhost/testdb?autoReconnect=true&allowMultiQueries=true"
                                username="root"

password="****"
                                maxActive="25"
                                maxIdle="5"
                                maxWait="10000"
                        />)

Any ideas what went wrong/how to solve the issue?

Thanks!

Jarmo

Jarmo Kauppinen · Accepted Answer

Mystery solved. Apparently the name of the database entry point can't contain any space character. So I renamed 'MySQL vega' to 'MySQL' and "Oh yes, I can connect to this database".