Java Oracle

Open-source Java projects categorized as Oracle Edit details

Top 15 Java Oracle Projects

  • dbeaver

    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

    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

    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

    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

    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

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

  • Ebean ORM

    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

    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

    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

    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

    Universal transaction manager

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

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

  • setup-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

    Java code generator for calling PL/SQL.

  • MicrostarterCli

    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

    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

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

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2022-06-07.

Java Oracle related posts

Index

What are some of the best open-source Oracle projects in Java? This list will help you:

Project Stars
1 dbeaver 26,983
2 jOOQ 4,966
3 JSqlParser 3,726
4 liquibase 3,268
5 requery 3,097
6 Ebean ORM 1,301
7 testcontainers-spring-boot 665
8 symmetric-ds 533
9 scalardb 305
10 obevo 205
11 setup-java 32
12 OBridge 19
13 MicrostarterCli 6
14 autonomous-database-for-developers 4
15 StORMi 0
Find remote jobs at our new job board 99remotejobs.com. There are 4 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
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