CRUD Operations with Firebird in Spring Boot

December 26, 2025

#1

Firebird is a reliable relational database that can be integrated into Spring Boot. Here’s how to perform basic CRUD operations using Spring Data JPA with Firebird.

Add Dependencies

Add Firebird JDBC driver and Spring Data JPA to your pom.xml:

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

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

Configure Firebird Connection

Set properties 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
spring.jpa.hibernate.ddl-auto=update
spring.jpa.database-platform=org.hibernate.dialect.FirebirdDialect

Create Entity

@Entity
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String email;
    // getters and setters
}

Repository

public interface UserRepository extends JpaRepository<User, Long> {
}

Service Layer

@Service
public class UserService {
    @Autowired
    private UserRepository repo;

    public User create(User user) { return repo.save(user); }
    public List<User> readAll() { return repo.findAll(); }
    public User update(User user) { return repo.save(user); }
    public void delete(Long id) { repo.deleteById(id); }
}

Controller

@RestController
@RequestMapping("/users")
public class UserController {
    @Autowired
    private UserService service;

    @PostMapping public User create(@RequestBody User u){ return service.create(u);}
    @GetMapping public List<User> readAll(){ return service.readAll();}
    @PutMapping public User update(@RequestBody User u){ return service.update(u);}
    @DeleteMapping("/{id}") public void delete(@PathVariable Long id){ service.delete(id);}
}