How to connect IntelliJ IDEA 2017.1.2 to Postgresql

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. Screen shot of Data Sources and Drivers dialog 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

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.

Leave a Reply

Your email address will not be published. Required fields are marked *