After using the internal hsql db, I'm in the process of converting our Confluence instance to MySql (on an AWS EC2 box). After entering in the db credentials I get an Apache Tomcat 500 error as follows:
HTTP Status 500
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL ; SQL state [3D000]; error code ; No database selected; nested exception is java.sql.SQLException: No database selected
On the "Configure Database" page, this is the information I enter for Database URL: jdbc:mysql://myawsec2.us-east-1.rds.amazonaws.com:3306/. I don't enter the database name there (though maybe I should?) I also don't have the database name included in confluence.cfg.xml, as follows:
Should the database name be included in one/both of those locations? I feel like I've tried that, but I'm not positive. (I've tried both "jdbc:mysql://myawsdbname.myawsec2.us-east-1.rds.amazonaws.com:3306/" and "jdbc:mysql://myawsec2.us-east-1.rds.amazonaws.com:3306/myawsdbname/").
Yes when setting up the database JDBC connection, you will have to specify the database URL along with the name as well. So for an example, I think the following database URL should work:
Hence, can you kindly try to apply this and see if it helps?
If the problem remains, may I know how did you configure the database connection? Did you make changes directly to the confluence.cfg.xml?
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG