Top 18 Java Oracle Projects
Free universal database tool and SQL clientProject 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 is the best way to write SQL in JavaProject 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.
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 parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor PatternProject 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 and it does produce an AST which can be parsed using the visitor-pattern 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.
Main Liquibase SourceProject 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 - modern SQL based query & persistence for Java / Kotlin / AndroidProject 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
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.
Feedback and ideas for improvement are very welcome.
Ebean ORMProject mention: loom and database drivers | /r/java | 2023-02-18
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.
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
Container auto-configurations for Spring Boot based integration testsProject 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).
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 is open source tool for database replication, designed for efficiently transferring bulk data between relational and non-relational databasesProject mention: Can we sponsor this guy? | news.ycombinator.com | 2023-02-17
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
GitHub Action to download and install Oracle's Java Development Kit builds (by oracle-actions)
A simple command line Java application to test JDBC connection to Oracle databaseProject 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:
Java code generator for calling PL/SQL.
A Simple tool that generates Micronaut Components
Working apps demoing Autonomous Converged Database powerful capabilities for developers
Shujutech Object Relational Mapping Interface, the only Java ORM that fully supports all OO concepts.
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
What are some of the best open-source Oracle projects in Java? This list will help you: