Top 18 Java Oracle Projects
-
dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.
-
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
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.
-
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.
-
ah, I was thinking of https://github.com/requery/requery but I wasn't really sure, also that project is dead oh no :D
-
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.
-
-
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.
-
-
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.
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
-
-
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
I can connect to the database using this oracle-jdbc-tester, without encryption, using the connection string:
-
-
-
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
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 |