Top 15 Java Oracle Projects

• dbeaver

  11 26,983 9.9 Java

  Free universal database tool and SQL client

  

  Project mention: Generate DDL | reddit.com/r/dbeaver | 2022-06-07

  See if you can find it here: https://github.com/dbeaver/dbeaver

• jOOQ

  34 4,966 9.9 Java

  jOOQ is the best way to write SQL in Java

  

  Project mention: Deepkit – High-Performance TypeScript Framework | news.ycombinator.com | 2022-06-07

  Cool jooq[1]-query-syntax-like ORM! https://deepkit.io/library/orm

  It does not seem to have the code-generation (for the db table DTOs) though.

  I also like typescript's "string & MinLength<3> & Email" type combining.

  A quick edit-test-loop must be a great selling point of this kind of FW compared to FW in more strongly types languages (that have slower edit-test-loops due to compilation) that I usually prefer.

  [1]: https://www.jooq.org/

• Scout APM

  scoutapm.com

  sponsored

  Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  

• JSqlParser

  2 3,726 8.6 Java

  JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

  

  Project mention: Open Source SQL Parsers | dev.to | 2021-10-08

  JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.

• liquibase

  17 3,268 9.8 Java

  Main Liquibase Source

  

  Project mention: springboot with stored procedures | reddit.com/r/SpringBoot | 2022-04-18

  You might gain some efficiency but lose maintainability. I have worked on codebases were SP are coded, tuned and inserted by and, but this is painful for testing and so on. Instead, use FlywayDB https://flywaydb.org/ or Liquibase https://www.liquibase.org/ for configuration management of the DB, to handle the DB migrations including inserting the SPs. In Spring use the SimpleJdbcCallOperations interface to call the SPs (with the concrete implementation class being SimpleJdbc), that way it is easy to mock or stub the database calls for unit testing. Use the unit testing framework that works best with your database to test your SPs, e.g. for Oracle see https://docs.oracle.com/cd/E15846_01/doc.21/e15222/unit_testing.htm#RPTUG45064

• requery

  0 3,097 0.0 Java

  requery - modern SQL based query & persistence for Java / Kotlin / Android

  

• Ebean ORM

  4 1,301 9.9 Java

  Ebean ORM

  

  Project mention: How do you guys go about the persistence layer? | reddit.com/r/java | 2022-03-23

  You can have a look at https://ebean.io/ ... better control over the generated SQL, multiple levels of abstraction, can generate DB migrations and run the DB migrations, transparent encryption support, SQL 2011 history support, test against docker containers.

• testcontainers-spring-boot

  1 665 9.2 Java

  Container auto-configurations for Spring Boot based integration tests

  

  Project mention: Building a Scalable Live Stream Chat Service with Spring WebFlux, Redis PubSub, RSocket and Auth0 | dev.to | 2021-08-20

  We will use the Playtika testcontainers-springboot library to easily spin up a Redis docker container while running the integration tests locally. This can then be used as our PubSub message broker as we test the functionality of the connection server.

• JetBrains

  surveys.jetbrains.com

  sponsored

  Developer Ecosystem Survey 2022. Take part in the Developer Ecosystem Survey 2022 by JetBrains and get a chance to win a Macbook, a Nvidia graphics card, or other prizes. We’ll create an infographic full of stats, and you’ll get personalized results so you can compare yourself with other developers.

  

• symmetric-ds

  4 533 9.3 Java

  SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.

  

  Project mention: migrate giant 17TB DB from mariadb10.4 to MySQL 8 | reddit.com/r/mysql | 2021-12-10

  Use replication. https://www.symmetricds.org/

• scalardb

  1 305 9.3 Java

  Universal transaction manager

  

  Project mention: A Universal Transaction Manager | news.ycombinator.com | 2021-09-21

• obevo

  0 205 0.0 Java

  Obevo is a database deployment tool that handles enterprise scale schemas and complexity

  

• setup-java

  6 32 8.2 Java

  GitHub Action to download and install Oracle's Java Development Kit builds (by oracle-actions)

  

  Project mention: Which version you have found most useful and stable after Java 8 ? | reddit.com/r/java | 2022-05-04

• OBridge

  0 19 1.8 Java

  Java code generator for calling PL/SQL.

• MicrostarterCli

  8 6 9.5 Java

  A Simple tool that generates Micronaut Components

  Project mention: Demo: Generating REST &amp; Graph Endpoint In a Micronaut Application Using MicrostarterCLI | reddit.com/r/programming | 2022-02-04

• autonomous-database-for-developers

  1 4 8.9 Java

  Working apps demoing Autonomous Converged Database powerful capabilities for developers

  Project mention: NoSQL & SQL together: Spring Boot example🤯 | dev.to | 2022-04-29

  Spring Boot sample app on GitHub

• StORMi

  0 0 0.0 Java

  Shujutech Object Relational Mapping Interface, the only Java ORM that fully supports all OO concepts.

Java Oracle related posts

• Which version you have found most useful and stable after Java 8 ?
  1 project | reddit.com/r/java | 4 May 2022
• global-tz, a new fork of iana-tz (uses JEP 330 to automate data transformation)
  3 projects | reddit.com/r/java | 21 Mar 2022
• Introducing the `oracle-actions/setup-java` GitHub action
  3 projects | reddit.com/r/java | 14 Mar 2022
• Setup local MS SQL docker container
  4 projects | dev.to | 13 Dec 2021

Index

Sponsored

Static code analysis for 29 languages.

Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

www.sonarqube.org

Do not miss the trending Java projects with our weekly report!