Top 18 Java Oracle Projects

• dbeaver

  13 32,212 9.9 Java

  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

  34 5,445 9.8 Java

  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

  www.sonarsource.com

  sponsored

  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

  1 4,383 9.0 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: 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

  23 3,892 9.8 Java

  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

  1 3,120 0.0 Java

  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

  64 1,635 0.0 Java

  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

  1 1,386 5.7 Java

  Ebean ORM

  

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

• InfluxDB

  www.influxdata.com

  sponsored

  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

  1 1,156 10.0 Java

  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

  1 767 7.6 Java

  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

  3 583 9.6 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: 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

  1 260 10.0 Java

  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

  0 217 0.0 Java

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

  

• setup-java

  0 46 0.0 Java

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

  

• oracle-jdbc-tester

  1 43 0.0 Java

  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

  0 22 0.0 Java

  Java code generator for calling PL/SQL.

• MicrostarterCli

  0 13 0.0 Java

  A Simple tool that generates Micronaut Components

• autonomous-database-for-developers

  0 5 0.0 Java

  Working apps demoing Autonomous Converged Database powerful capabilities for developers

• StORMi

  0 0 0.0 Java

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

• SaaSHub

  www.saashub.com

  sponsored

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

  

Java Oracle related posts

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

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

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