I'm looking for a lightweight, open source, more or less cross-database Java library that would allow me to read off metainformation on columns, tables and integrity constraints given a DataSource.
Java library for reading database schema
6.1k Views Asked by Marat Salikhov At
2
There are 2 best solutions below
0
Rich
On
Depends what you want to do afterwards of course, but if you just want to visualise an existing datatbase, I recommend SchemaSpy.
Of course, JDBC already lets you read metainformation, using Connection.getMetaData(). This gives you a DatabaseMetaData instance.
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in JDBC
- Hibernate ClobJdbcType bindings: what are the diferences?
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- How RowSet works java?
- java ee jdbc jstl servlet connection to db
- VSCode Libraries not showing for New Java Project
- Is there any guide online on how to correctly map the sakila database using Java and hibernate?
- Java cancel task running Oracle query through JDBC - connection broken because of SQLSTATE(08006), ErrorCode(17002) IO Error: Socket read interrupted
- Ibm Db2 Jdbc Connection
- How to connect to mysql inside a Kubernetes cluster?
- How to specify multiple databases when connecting to DolphinDB Server with JDBC interface？
- Connecting to MS SQL DB from Java thows error
- Access denied for user 'root'@'localhost' (using password: YES) in eclipse when connecting with jdbc
- databricks / pycharm sql connection
- How to correctly insert a jsonb into postgresql using a Java PreparedStatement
- How to query jsonb column with spring data
Related Questions in DATABASE-SCHEMA
- SQL schema for a fill-in-the-blank exercise
- Enforce schema on schemaless DynamoDB database
- Design SQL Schema for User Interests
- Issues Generating ODB Schema and Query Files for C++ Project
- Does setting a .unique(on:) constraint affect the uniqueness of the .id in fluent/vapor?
- My schema is not showing in the Schema List Window
- How to design my Django app database to accommodate multiple level information of an item?
- Copy and use Progress database file at runtime
- In schema compare, some files erroneously appear as missing in the local DB compared to Azure SQL Server DB. Only a few files are affected, not all
- is adding a table for video, image, and audio a good job for normalizing the database or not
- Database schema and query to accumualte total amount of days for each "category" of an animal over a period of time
- Mongoose: Nested Schema Array is throwing an error that _id = null and _id cannot be duplicated
- SQLite3: "CREATE VIEW" fails at "column-name"
- Separating schema and data migrations
- How to specify in Pymongo validator key type in object?
Related Questions in DDLUTILS
- Incompatible types ddlutils catch block
- HSQL Error: org.hsqldb.HsqlException: primary key already exist
- Migrate large mySQL Database to derby using DdlUtils
- Is there any way to convert derby database table rows to SQL insert statements
- Alternatives to DDLUtils from apache
- DDLUtils not exporting Mysql data using ant script
- Nested Exception vs modern (Java SE 7) exceptions
- Apache DdlUtils :: how to obtain the sequence name for auto-increment keys?
- How to make my webApp switch between different DBMS smoothly(DB Independency)?
- Problems on converting Database with ddlutils
- Auto-incrementation with HSQLDB (2.2.8) + DDLUtils
- DdlUtils: defering insertion
- Problem using DdlUtils with Oracle 11.1.0
- Problem in using org.apache.ddlutils.DdlUtilsException
- Java library for reading database schema
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I have found an answer to my question, Apache DDLUtils. My question was really a duplicate of this one.