Object-relational mapping

CocoBase

Home Page

Categories: Object-relational mapping

Author: Thought

Latest version: 5.0
Added 2006-07-31

Persistence and query manager for local J2SE and distributed J2EE environments that is transparent to the object and does not modify the byte-code of the object with extensions, annotations, etc. whether at design, build, deploy or runtime.

Features include:
- Generic POJO O/R mapping
- ability to map single or multiple inheritance with multiple discriminators without requiring knowledge of specific mapping strategies
- SQL realms, allowing multiple SQL views or filters for the same Java class model
- SQL tuning, allowing generation and tuning of SQL for each mapping at design time
- Callback plug-ins and factories for incorporating custom behavior at runtime
- Supports standard EJBQL based querying for object queries and it is based on an early draft of the EJB3 persistence API
- Spring integration
- Eclipse IDE plug-in
- Magic Mapper: a case-tool user interface for mapping tables, fields and objects

Built for Java

Plug-in

Add to my favorites[NEW]

OJB

Home Page

Categories: Object-relational mapping

Author: The Apache Software Foundation

Latest version: 1.0.1
Added 2005-01-10

ObJectRelationalBridge (OJB) is an object/relational mapping tool that allows transparent persistence for Java objects against relational databases.
Features include:
- Support of standard and non-standard API's (PB, OTM, ODMG, JDO)
- The PersistenceBroker kernel API and all top-level APIs allows Java programmers to store and retrieve Java objects in/from (any) JDBC-compliant RDBMS
- Transparent persistence: Persistent classes don't have to inherit from a persistent base class or to implement an interface.
- Object caching, lazy materialization through virtual proxies, distributed lock-management with configurable Transaction-Isolation Levels. Optimistic and pessimistic Locking is supported.
- Designed to be scalable: Allows to build massively distributed and clustered systems.
- Configurable persistence by reachability: All Objects associated to a persistent object by references can made persitent too
- Pluggable implementation of service classes like PersistenceBroker, ObjectCache, SequenceManager, RowReader, ConnectionFactory, ConnectionManager, IndirectionHandler, SQLGenerator, JdbcAccess...
- Mapping support for 1:1, 1:n and m:n associations
- Configurable collection queries to control loading of relationships
- Automatic and manual assignment of foreign key values
- The mapping is defined in an XML Repository. The mapping is dynamic and can be manipulated at runtime

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

TopLink

Home Page

Categories: Object-relational mapping, XML

Author: Oracle

Latest version: 10.1.3.1.0
Added 2006-11-20

Object-to-relational persistence architecture that provides a mechanism for storing Java objects and Enterprise Java Beans (EJBs) in relational databases and for converting between Java Objects and XML documents (JAXB).

Features include:
- can communicate with any relational database that has a JDBC-compliant driver available such as Oracle, IBM Universal Database, IBM Informix, IBM Cloudscape, Microsoft SQL Server, Microsoft Access, and Sybase Adaptive Server. TopLink supports both the JDBC 1.x and 2.0 standards.
- mapping tools are integrated into JDeveloper and also available in the stand-alone TopLink Workbench

Built for Java

Plug-in

Free or free version available

Add to my favorites[NEW]

Castor

Home Page

Categories: Object-relational mapping, XML

Latest version: 1.2
Added 2005-01-11Updated 2006-06-07

Open Source data binding framework for Java.
Castor joins Java objects, XML documents and relational tables. It provides Java-to-XML binding, Java-to-SQL persistence, and more.

Features include:
- Castor XML: Java object model to and from XML (XML databinding). Generate source code from an XML Schema; Default introspection or mapping file for existing object models.
- Castor JDO: Java object persistence to RDBMS. Castor JDO is not the same-as or compatible with Sun's JDO. Castor has a different approach to handling data object to RDBMS mappings.
- XML-based mapping file to specify bindings for existing object models
- Support for schema-less Java to XML binding
- In memory caching and write-at-commit reduces JDBC operations
- Two phase commit transactions, object rollback and deadlock detection
- OQL query mapping to SQL queries
- EJB container managed persistence provider for OpenEJB
- Ability to create base mapping from existing Java classes
- Ability to create an XML Schema from an XML input document

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

Hydrate

Home Page

Categories: Object-relational mapping, XML

Latest version: 2.0
Added 2006-06-07

Tool for transforming data between three different representations: relational databases, objects in an object-oriented programming language and XML.

Features include:
- Map data from many different data sources into a single self-consistent in-memory model.
- Load, populate and connect up multiple object types from a single query.
- Full control over the SQL that runs against the database (if you need it).
- Access and manipulate the same data through the XML toolset. Use the same meta data that describes your objects to read from, write to and validate any consistent XML schema. Use XML for display, data transmission or XSLT transformation. Load XML data back into objects.
- XML reading and writing uses SAX exclusively

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

O/R Broker

Home Page

Categories: Object-relational mapping

Latest version: 2.0
Added 2005-05-23

Convenience framework for applications that use JDBC that allows you to externalize your SQL statements into individual files, and allows declarative mapping from tables to objects.
O/R Broker is another object-relational tool, except it differs from most in that it allows use of constructors, setter methods, and direct field access, as well as JavaBean properties. The developer maintains all control over SQL, allowing fine-grained performance.
O/R Broker serves solely as a broker between the database and an object model. It allows object encapsulation, and doesn't require an object model to follow strict JavaBean rules, which can be useful.
One of the design goals for O/R Broker was simplicity. There are are only 4 public classes, and an XML Schema file for validation of the configuration. The only dependency is Java 1.4 or higher, and there is optional support for Velocity and FreeMarker for dynamic SQL generation.

Features include:
- Inheritance mapping
- SQL statements externalized in individual text files

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

Beck

Home Page

Categories: Object-relational mapping, XML

Latest version: 0.17
Added 2005-04-07

Maps between Java objects and XML.
The mapping is configurable via an XML configuration file. It can be extended by adding Java software to Beck's framework.

Beck isn't a binding tool. It doesn't generate Java classes from XML schema, nor generate XML schema from Java classes. Beck assumes you already have Java classes to contain your data. Beck doesn't require an XML schema, but if you have one it can help Beck map to the XML you want.

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

Hibernator

Home Page

Categories: Object-relational mapping

Latest version: 0.9.5
Added 2006-04-12

Eclipse plugin that enables synchronisation of a Java class and the related Hibernate mapping file.
Hibernator provides access to common Hibernate tasks from Eclipse, such as creating or updating a Database Schema, running Hibernate queries and creating simple Hibernate mapping documents. A developer can edit his business classes without having to manually update the matching Hibernate files.

Built for Java

Plug-in

Free or free version available

Source code provided

Add to my favorites[NEW]

Cayenne

Home Page

Categories: Object-relational mapping

Author: The Apache Software Foundation

Latest version: 3.0.1
Added 2005-08-25Updated 2010-09-29

Openn source persistence framework providing object-relational mapping and remoting services.
Cayenne binds one or more database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more. With Cayenne's Remote Object Persistence, those Java objects can even be persisted out to clients via Web Services. Or, with native XML serialization, objects can be even further persisted to non-Java clients, such as an Ajax-capable browser.

Cayenne is distributed with CayenneModeler, a GUI mapping tool that supports reverse-engineering of RDBMS schemas, working with database mappings and generation of Java source code for the persistent objects.
Persistent Java classes are generated and synchronized with the mapping using the Modeler or alternatively with an Ant task. A database SQL schema can be generated from the Modeler and also with simple API calls.

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

Mia-Generation

Home Page

Categories: Code generation, Object-relational mapping

Author: Mia-Software

Latest version: 5.0.1
Added 2005-04-04Updated 2007-01-16

Development environment to build custom code generators complying with specific architectures and frameworks.
Mia-Generation provides a dynamic bridge between analysis and design, and supports iterative cycles by preserving user defined code fragments between two generations. Generation rules are specified with an IDE dedicated to generator building.

Features include:
- Support of UML 2, but open to any other meta-model
- Open to any file format for input models : can be connected to major modeling tools.
- Template based generation engine
- Java as script language
- Modular architecture
- Support for iterative development cycles (can preserve hand-written code)
- Built-in support for UML Profiles
- Facilities for generators deployment
- Plug-ins for Eclipse, JBuilder, Visual Studio .NET, BEA WebLogic Workshop

Mia-Generation Boosters provide you with Mia-Generation customizable project files (a set of generation scripts) and UML profiles for transforming your UML models into platform-specific code:
- Mia for .NET: produce .NET multi-layered architecture
- Struts Generator: produce Struts based applications
- JSF Generator: produce JavaServer Faces (JSF) based applications
- OJB Generator: produce an Object/Relational mapping layer (and associated Java Objects) using ObjectRelationnalBridge - OJB from the Apache DB Project.
- Hibernate Generator: provides the capability to use Mia-Generation to produce an Object/Relational mapping layer (and associated Java Objects) using Hibernate.

Built for Java

Plug-in

Add to my favorites[NEW]

BEA Kodo

Home Page

Categories: Object-relational mapping

Author: BEA Systems

Latest version: 4.1
Added 2005-12-28Updated 2006-10-17

Implementation of both the Java Data Object (JDO) and Enterprise Java Bean (EJB) standardized persistence APIs. Kodo allows you to use the API you prefer or even to mix use of both JDO and EJB in the same application.

Features include:
- Complete JDO 2.0 support
- Full EJB 3.0 Java Persistence API (JPA) based on code from the Apache OpenJPA project
- Level 2 database cache; Statement batching; Query caching; Custom fetch groups
- Stored procedure support
- Supported mappings: one-to-one, one-to-many, many-to-many (collection or map)
- Inheritance models: single table, multiple table
- Extensible plug-in architecture
- BEA Kodo Management Console
- Fine-tuning with BEA Kodo Profiler
- Supported databases: Oracle 8i, 9i, 10g; IBM DB2 and Informix; SQL Server; Sybase ASE; Borland JDatastore and Interbase; Pointbase; Firebird; Microsoft Fox Pro and Access; Empress; InterSystems Caché; Apache Derby/Cloudscape; MySQL; PostgreSQL; HSQL Database Engine (Hypersonic)

Built for Java

Add to my favorites[NEW]

XORM

Home Page

Categories: Object-relational mapping

Latest version: Beta 6
Added 2005-08-30

Object-relational mapping layer for Java applications.
XORM provides interface-based persistence to RDBMSs using the Java Data Objects (JDO) API while allowing developers to focus on the object model, not the physical layer.

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

pBeans

Home Page

Categories: Object-relational mapping

Latest version: 2.0
Added 2007-03-26

Object-relational mapping layer.

Features include:
- Automatic table creation and schema evolution: Tables corresponding to JavaBean classes are created on demand
- Based on annotated JavaBeans: You define a getter and setter for each bean property. Persistent bean classes need to be tagged with a @PersistentClass annotation.
- Transitive persistence
- Instance consistency: If you retrieve an object from persistent storage that is already known to exist in main memory, you get a reference to the object in main memory.
- Light configuration: There is no need to define schemas or anything of the sort in a language other than Java, and there are no code generation steps of any kind.
- Database features: Transactions and auto-increment IDs (MySQL only).
- Via annotations users are allowed to define their own table and field names, the name of the primary key, whether fields are nullable, whether tables are user-managed (not automatically modified), table indexes, unique or otherwise, whether unused fields should be deleted, whether a field is nullable, whether it is renamed from another field (to prevent loss of data when a property is renamed), etc.
- Servlet support: A pBeans store may be easily configured using servlet context parameters.

Requirements: J2EE/J2SE 5+, a JDBC Driver, a relational database (pBeans supports MySQL, PostgreSQL, SQLServer and HSQLDB by default. Support for additional databases may be "plugged in" by implementing a class).

Built for Java

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

Enhydra DODS

Home Page

Categories: Object-relational mapping

Author: Enhydra.org

Latest version: 7.0 Beta 1
Added 2006-06-07

Enhydra DODS (Data Object Design Studio) is an oOpen source a code generating object-relational mapping tool.
Based on XML data model descriptions (DOML files) SQL DDL, Java code and documentation (HTML, PDF, XMI) is generated automatically using a generator GUI, by Ant tasks or from within your IDE of choice.

Features include:
- The generated Java code is DB vendor independent. The SQL DDL is DB vendor specific. The generator can be customized by different sets of code templates.
- Configurable templates
- Data/query caching

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]

Speedo

Home Page

Categories: Object-relational mapping

Author: ObjectWeb

Latest version: 1.3.0
Added 2005-05-27

Open source implementation of the JDO 1.0.1 specification.

Features include:
- Possible choice of optimistic or pessimistic transaction mode.
- Cache of persistent objects, with a choice of several replacement policies (LRU | MRU | FIFO | ...).
- Data prefetching at query evaluation time: later accesses to objects will not require any I/O to the data store.
- Management of relationships (coherency management).
- Able to create the SQL schema.
- Various identifier support (application composite or single, SQL sequence, speedo).
- Supports Oracle, SQL server, MySQL, Postgres, etc.
- Through JORM and MEDOR, access to legacy relational databases, as well as any other data store supported by JORM and MEDOR.
- Many JDO 2.0 features.

Built for Java

Free or free version available

Source code provided

Add to my favorites[NEW]