Connecting Spring Boot to Firebird Database with JDBC

December 25, 2025

#1

Firebird is a lightweight relational database that can be integrated easily with Spring Boot using JDBC. This guide shows how to set up the connection and run queries.

Add Firebird JDBC Dependency

Include the Firebird JDBC driver in your pom.xml:

<dependency>
  <groupId>org.firebirdsql.jdbc</groupId>
  <artifactId>jaybird-jdk18</artifactId>
  <version>5.0.3.java18</version>
</dependency>

Configure Database Connection

Set connection details in application.properties:

spring.datasource.url=jdbc:firebirdsql://localhost:3050/yourdb
spring.datasource.username=sysdba
spring.datasource.password=masterkey
spring.datasource.driver-class-name=org.firebirdsql.jdbc.FBDriver

This points Spring Boot to your Firebird database.

Using JdbcTemplate

Spring Boot automatically provides a JdbcTemplate bean. You can use it to run queries against Firebird.

@Repository
public class UserRepository {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    public List<String> getAllUsernames() {
        return jdbcTemplate.queryForList(
            "SELECT username FROM users",
            String.class
        );
    }
}

Expose Data via REST

You can create a simple REST endpoint to fetch the data.

@RestController
@RequestMapping("/users")
public class UserController {
    @Autowired
    private UserRepository repository;

    @GetMapping
    public List<String> getUsers() {
        return repository.getAllUsernames();
    }
}

Now, hitting /users will return usernames from Firebird.