What is a simple way to read from a Oracle DataBase and write to a text file, not using Spring Batch (but using Java)? Too complicated for Spring Batch.

This page summarizes the projects mentioned and recommended in the original post on /r/javahelp

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • jOOQ

    jOOQ is the best way to write SQL in Java

  • There are also attempts to write queries in another DSL than the already commonly known and accepted SQL (or JPQL and Criteria API with the JPA specification/standard). One prominent candidate would be jooq: https://www.jooq.org/

  • Spring Data JPA

    Simplifies the development of creating a JPA-based data access layer.

  • "Spring Batch" is not the Spring technology to access databases conveniently. That would be "Spring Data" or even "Spring Data JPA": https://spring.io/projects/spring-data-jpa

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • JDBI

    The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

  • Another option is JDBI, that helps you with mappings too while having less features than JPA: https://jdbi.org/

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts