Java Oracle

Open-source Java projects categorized as Oracle

Top 18 Java Oracle Projects

  • dbeaver

    Free universal database tool and SQL client

    Project mention: SQLite is not a toy database | /r/programming | 2023-04-28

    dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.

  • jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Do you use DB Enum Types? | /r/ExperiencedDevs | 2023-05-30

    Some of our applications already use DB schema-based code generation too (e.g. jOOQ), which makes using the DB-defined enum quite easy.

  • Sonar

    Write Clean Java Code. Always.. Sonar helps you commit clean code every time. With over 600 unique rules to find Java bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • 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: Semantic Diff for SQL | news.ycombinator.com | 2022-07-29

    I wonder if this is a topical thread to check if anyone is aware of a Java based solution to parse a CREATE VIEW statement to get a mapping between the view columns and the corresponding source table columns. I checked out jsqlparser[0] and it does produce an AST which can be parsed using the visitor-pattern[1] but was wondering if there is a more "out-of-the-box" solution. Due to various reasons, querying the database information schema is not an option I can pursue.

    [0]: https://github.com/JSQLParser/JSqlParser

    [1]: https://en.wikipedia.org/wiki/Visitor_pattern

  • liquibase

    Main Liquibase Source

    Project mention: Better alternatives to schemachange for Snowflake Database Object Deployment | /r/snowflake | 2023-05-20

    I haven't used it for a number of years but it sounds like something like liquibase (https://www.liquibase.org/) might be what you're looking for.

  • requery

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

    Project mention: Learning Android’s Room Database Made Easy | /r/androiddev | 2023-01-22

    ah, I was thinking of https://github.com/requery/requery but I wasn't really sure, also that project is dead oh no :D

  • Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Database Subsetting and Relational Data Browsing | news.ycombinator.com | 2023-05-30

    This is my passion project. The subsetter is certainly something for specialists, but the data browser is unique and very useful for many.

    https://github.com/Wisser/Jailer

    Feedback and ideas for improvement are very welcome.

  • Ebean ORM

    Ebean ORM

    Project mention: loom and database drivers | /r/java | 2023-02-18
  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • oracle-db-examples

    Examples of applications and tool usage for Oracle Database (by oracle-samples)

    Project mention: Oracle Database 23c Free – Developer Release | /r/oracle | 2023-04-05
  • testcontainers-spring-boot

    Container auto-configurations for Spring Boot based integration tests

    Project mention: Testcontainers: Testing with real dependencies | /r/programming | 2022-11-17

    For Spring Boot there's a nice wrapper: https://github.com/PlaytikaOSS/testcontainers-spring-boot. (I work for Playtika).

  • 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: Seamless integration of Databases | /r/PostgreSQL | 2023-02-17

    There are several CDC (change data capture) solutions on the market. I've used https://www.symmetricds.org quite successfully in the past.

  • ReplicaDB

    ReplicaDB is open source tool for database replication, designed for efficiently transferring bulk data between relational and non-relational databases

    Project mention: Can we sponsor this guy? | news.ycombinator.com | 2023-02-17
  • 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)

  • oracle-jdbc-tester

    A simple command line Java application to test JDBC connection to Oracle database

    Project mention: Enabling tcps? | /r/oracle | 2022-07-22

    I can connect to the database using this oracle-jdbc-tester, without encryption, using the connection string:

  • OBridge

    Java code generator for calling PL/SQL.

  • MicrostarterCli

    A Simple tool that generates Micronaut Components

  • autonomous-database-for-developers

    Working apps demoing Autonomous Converged Database powerful capabilities for developers

  • StORMi

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

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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 2023-05-30.

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 32,212
2 jOOQ 5,445
3 JSqlParser 4,383
4 liquibase 3,892
5 requery 3,120
6 Jailer 1,635
7 Ebean ORM 1,386
8 oracle-db-examples 1,156
9 testcontainers-spring-boot 767
10 symmetric-ds 583
11 ReplicaDB 260
12 obevo 217
13 setup-java 46
14 oracle-jdbc-tester 43
15 OBridge 22
16 MicrostarterCli 13
17 autonomous-database-for-developers 5
18 StORMi 0
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com