Projects tagged ‘jdbc’, ‘mysql’, and ‘oracle’

Simple yet Powerful Jdbc Tool for browsing Relational databases. DBClient provides both a convenient SQL Editor (highlighting, auto-complete, ...) and automated Browsing and Refactoring Actions (Select, Drop, etc...). Since release 0.3, it is massively based on Plugins architecture which makes it very extensible.

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table ... [More] relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. [Less]

LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control. ... [More] LiquiBase aims to provide a solution that: * Supports merging of changes from multiple developers * Works well with code branches * Allows you to manage production data as well as various test datasets * Works in an environment where multiple machines will be attempting to migrate the database concurrently * Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA * Supports rolling back changes * Database "diff" tool [Less]

Model-based data export tool. Exports consistent, referentially intact row-sets from relational databases. Removes obsolete data without violating integrity. DBMS agnostic (JDBC). Generates hierarchically structured XML and topologically sorted SQL-DML.

It's a code generation tool. In particular, it generates a persistence layer implementation from an already-deployed relational model. In ACM we weren't satisfied with the effort JDBC-based manual implementations require, as well as their average ... [More] reliability and performance: the time they consume adding almost no value, and the severity of the problems they can produce (connection or cursor leaks, to name a few). [Less]