Connect a Java application to Neon
This guide describes how to create a Neon project and connect to it with Java Database Connectivity (JDBC) or from a Spring Data project that uses JDBC.
The JDBC API is a Java API for relational databases. PostgreSQL has a well-supported open-source JDBC driver which can be used to access Neon. All popular Java frameworks use JDBC internally. To connect to Neon, you are only required to provide a connection URL.
For additional information about JDBC, refer to the standard JDBC API documentation and PostgreSQL JDBC Driver documentation.
To connect to Neon with JDBC or from a Spring Data project:
Create a Neon project
When creating a Neon project, take note of your project ID, database name, user, and password. This information is required when defining JDBC connection settings.
To create a Neon project:
- Navigate to the Projects page in the Neon Console.
- Click New Project.
- Specify a name, a PostgreSQL version, a region, and click Create Project.
For additional information about creating projects, see Setting up a project.
Connect with JDBC
For a JDBC connection URL, replace the variables in the following URL string with your Neon project ID, database name, user, and password:
<endpoint_hostname>the hostname of the branch endpoint, which is found on the Neon Dashboard, under Connection Settings.
<dbname>is the name of the database in your Neon project.
mainis the default database created with each Neon project.
<user>is the database user, which is found on the Neon Dashboard, under Connection Details.
<password>is the database user's password, which is provided to you when you create a project.
Connect from Spring Data
Spring Data relies on JDBC and PostgreSQL drivers to connect to PostgreSQL databases, such as Neon. If you are starting your project with Spring Initializr or connecting from an existing Spring Data project, ensure that the
PostgreSQL database driver dependency is installed.
Connecting from a Spring Data project requires specifying the datasource URL in your
application.properties file, as shown in the following example:
Refer to the Connect with JDBC section above for information about Neon