The Envers project aims to enable easy versioning of persistent JPA classes. All that you have to do is annotate your persistent class or some of its prope...The Envers project aims to enable easy versioning of persistent JPA classes. All that you have to do is annotate your persistent class or some of its properties, that you want to version, with @Versioned. For each versioned entity, a table will be created, which will hold the history of changes made to the entity. You can then retrieve and query historical data without much effort.
Similarly to Subversion, the library has a concept of revisions. Basically, one transaction commit is one revision (unless the transaction didn't modify any versioned entities). As the revisions are global, having a revision number, you can query for various entities at that revision, retrieving a (partial) view of the database at that revision.
to software hibernate jpa jdbc jboss seam db database develop version-control by gresch on Jul 22, 2008, 5:18 PMJUDIE steht für Java Universal Database Import and Export. Das Tool exportiert einzelne oder alle Tabellen einer JDBC Datenbank nach XML und importiert die...JUDIE steht für Java Universal Database Import and Export. Das Tool exportiert einzelne oder alle Tabellen einer JDBC Datenbank nach XML und importiert diese wieder in andere Datenbanken. Es ist als API (JAR), Kommandozeilenprogramm oder Eclipse Plugin verfügbar. Es kann für Entwickler und Administratoren nützlich sein, um Daten zwischen Datenbanken zu übertragen, besonders zum Aufsetzen von Testdatenbanken. Wegen der einfachen API kann das auch automatisiert werden, z.B. als Skript oder Ant-Task.
to ant tools eclipse import plugin export jar software develop database migration jdbc java by gresch on Jul 21, 2008, 11:33 PMModel-based Data Export Tool
Features
* Mass data export to XML and SQL.
* Generates hierarchically structured XML and topologically sorted SQL-...Model-based Data Export Tool
Features
* Mass data export to XML and SQL.
* Generates hierarchically structured XML and topologically sorted SQL-DML.
* Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
* Removes and archives obsolete data from your productive database without violating integrity.
* Open Source. Entirely written in Java. Platform independent. DBMS agnostic.
to mdd xml mda java database develop sql tools software by gresch on Jun 28, 2008, 9:06 PMIn spite of the example working, transaction management is not working appropriately when it comes to both Hibernate and JBossCache participating of the sa...In spite of the example working, transaction management is not working appropriately when it comes to both Hibernate and JBossCache participating of the same transaction. The reason is because at the time of writing this wiki, Hibernate did not allow to inject a JTA Transaction Manager which is not bound to JNDI. In the example, Hibernate creates a JDBC transaction and JBossCache a JTA transaction which are not linked together. To be able to make a Hibernate and JBossCache participant of the same JTA transaction in a standalone environment, customer code needs to be added to Hibernate to get around the JNDI/JTA coupling.
to software hibernate transaction caching java develop performance database jboss by gresch on Apr 9, 2008, 10:02 PMData Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use...Data Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources. The Power*Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.
The Power*Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.
Whether you are building a Data Warehouse or using data models to communicate business rules, the Power*Architect will facilitate and automate your data modeling efforts.
to modelling dba database software sql design erd develop by gresch on Mar 28, 2008, 10:41 PMThe XAware project provides real time data integration with a service-oriented flavor. XAware makes other tools and frameworks much more productive by hidi...The XAware project provides real time data integration with a service-oriented flavor. XAware makes other tools and frameworks much more productive by hiding data complexity behind "XML views". XML views span any number of data sources, and can read data, write data, or transfer data between sets of sources, all within a distributed transaction.
to soa integration springframework uml sql xml transformation eclipse eai java_ee software frameworks database transactions develop by gresch on Feb 11, 2008, 2:35 PMSymmetricDS is web-enabled, database independent, data synchronization/replication software. It uses web and database technologies to replicate tables betw...SymmetricDS is web-enabled, database independent, data synchronization/replication software. It uses web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage.
to develop db replication realtime frameworks java mysql software tools oracle database by gresch on Nov 14, 2007, 10:40 AMlog4jdbc is a JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information) for other jdbc drivers using the Simple Logging Facade...log4jdbc is a JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information) for other jdbc drivers using the Simple Logging Facade For Java (SLF4J) logging system.
to develop tools frameworks db java sql database software tracing logging by gresch on Oct 30, 2007, 5:44 PMSQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provi...SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provides a Java Runtime Environment.
It's main focus is on running SQL scripts (either interactively or as a batch), graphical query building or administration of the database is not the focus.
to admin develop sql db tools software java database by gresch on Oct 23, 2007, 7:57 PMDo you hate starting on a new project and having to try to figure out someone else's idea of a database? Or are you in QA and the developers expect you to ...Do you hate starting on a new project and having to try to figure out someone else's idea of a database? Or are you in QA and the developers expect you to understand all the relationships in their schema? If so then this tool's for you.
SchemaSpy is a Java-based tool (requires Java 1.4 or higher) 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 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.
to schema database reverse-engineering db tools software tool erd sql develop by gresch and 3 other people on Oct 22, 2007, 8:32 AM Hibernate Synchronizer is a free Eclipse plugin code generation tool to be used with the Hibernate persistence framework. The plugin will automatically ge... Hibernate Synchronizer is a free Eclipse plugin code generation tool to be used with the Hibernate persistence framework. The plugin will automatically generate java code when your hibernate mapping files are modified. Objects are created with generated code in an abstract base class and a user-modifiable extension class so user code does not get deleted when the generation is performed.
The automaticallly generated objects include:
* Value Objects
* Proxy Interfaces
* Composite Key Objects
* Enumeration Objects
* Component Objects
* Subclasses
* DAOs
Other features include:
* Editor with code assist and outline view
* Custom template generation
* New mapping file wizard that queries your database
* New configuration file wizard
* Actions for adding mapping references, synchronizing files, and manually activating code generation
to hibernate java software eclipse orm jdbc java_ee plugins develop database by gresch on Aug 25, 2007, 11:40 AMDB Schema Viewer is an Eclipse plugin that builds a graphical view of an existing database. Reverse Engineering is performed through JDBC. The most popular...DB Schema Viewer is an Eclipse plugin that builds a graphical view of an existing database. Reverse Engineering is performed through JDBC. The most popular databases are currently supported:
* MySQL
* PostgreSQL
* Firebird
to rdbms software db plugins jdbc java schema database eclipse develop by gresch on Aug 25, 2007, 11:37 AMScriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.
Our primary focus is simplicity. You don't have to ...Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.
Our primary focus is simplicity. You don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.
to database etl tools java db develop by gresch on Jul 3, 2007, 8:04 PMApplication Ermodeller is a free CASE tool for data modelling which is built in Java. This tool supports conceptual and logical data modelling and in the f...Application Ermodeller is a free CASE tool for data modelling which is built in Java. This tool supports conceptual and logical data modelling and in the final step, it allows to create physical model that is specific for particular DBMS.
The basic idea is to support development of database via ER modelling in three levels of abstraction:
* conceptual
* logical
* physical
This separation allows to create database model independent on the particular database system. You may create conceptual model and logical model that are independent on any DBMS. Then, you may generate physical model for each DBMS you will use. Afterwards, physical models allows you to generate SQL data definition for your target DBMS.
to computing tools database db code-generation develop software java erd by gresch on Jun 11, 2007, 9:03 AMExtrema is a powerful visualization and data analysis tool that enables researchers to quickly distill their large, complex data sets into meaningful infor...Extrema is a powerful visualization and data analysis tool that enables researchers to quickly distill their large, complex data sets into meaningful information. Its flexibility, sophistication, and power allow you to easily develop your own commands and create highly customized graphs.
to visual analysis db tools etl database by gresch and 1 other person on Jun 6, 2007, 9:42 PMKettle is a powerful tool designed to bridge the gap between business and ICT; Turning your company's data into increased profits.
to kettle tools software etl develop db database by gresch on May 5, 2007, 6:40 PMThe Sundog Database Refactoring Tool (SDRT) is an open source (LGPL), DBMS-independent library that eases database development, particularly in an agile en...The Sundog Database Refactoring Tool (SDRT) is an open source (LGPL), DBMS-independent library that eases database development, particularly in an agile environment.
to tools computing database refactoring develop db sql by gresch on Apr 16, 2007, 1:20 PMAgata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite,...Agata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as PostScript, plain text, HTML, XML, PDF, or spreadsheet (CSV) formats through its graphical interface.
to database php tools software report opensource computing by gresch on Apr 15, 2007, 6:08 PMMIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there.
A database change consists of...MIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there.
A database change consists of tests to determine whether the change has already been applied and a set of change actions.
to tools refactor database sql develop db computing by gresch on Apr 13, 2007, 6:05 PMdbdeploy is a Database Change Management tool. It helps developers and
DBAs change their database in a simple, controlled, flexible and
frequent manner
to db database tools java develop computing software sql refactor ant by gresch on Apr 13, 2007, 5:46 PM
