How to connect IntelliJ IDEA 2017.1.2 to Postgresql

Question

I am new to the IntelliJ IDEA IDE world, and would like to connect it to Postgresql as my data source. When I Test Connection using my Postgresql database, IntelliJ responds with a successful message. However, I'm not sure this is all there is to configuring it. As I'm trying to populate my database with with a table and some data. But the table doesn't even appear in the database tool window. Any help is appreciated. Thanks

Answer 1

I just came back to the sample application and when I tried running it, I got the following error; Cannot determine embedded database driver class for database type NONE. After a few searching for it I found that the solution was to place this line in my application.properties file spring.datasource.url=jdbc:postgresql://localhost/<database name>. and it connected successfully. I didn't need to include a

spring.datasource.data-username=<username>
spring.datasource.data-password=<password>

but you may have to.