| O/R Mapping Tools |
APIs, Data Interfaces |
Description, Features |
| Abra |
SQL-JDBC, XML, DDL |
XML configuration generate Java and DDL. Defines a style of DDL where database
objects all have object IDs and there is a Factory classes structure that store/restore information to/from database. |
| Ampersand Zero Code |
SQL-JDBC, Servlet |
Reverse engineers a relational database into a complete servlet application
Web site. |
| AlachiSoft: TierDeveloper |
SQL-JDBC-ODBC, J2EE, JSP (EJB 2.0 CMP/BMP), XML, XSLT, Web services, .Net |
RAD tool Generates middle-tier data objects that can be used in queries,
Web app test stubs, design documents. Can handle multiple databases. Supports servers: WebLogic, WebSphere, Oracle
9i AS, iPlanet, JBoss 3.0 and .Net, databases: Oracle, DB2, MS SQL. See also Product Features. Trial download. |
| Applese (Applese/Alberg) |
JDBC,XML, UML, Swing EJB, Servlets |
Generates source code. Uses a B2B Ontological metamodel |
| Bit Mechanic SQL2Java |
SQL-JDBC: |
Maps each table to two classes: core class represents a row; manager class
(singleton) encapsulates JDBC calls. |
| CodeFutures: Firestorm |
SQL-JDBC, DDL, Ant, EJB 1.1,2.0,CMP,EAR |
Reverse-engineers from DDL or JDBC metadata, has visual designer, generates:
pattern-based persistence tier, Ant build script, and choice of implementation in JDBC or for enterprise edition
in EJBs with EAR including JSP test tier. |
| DataBind |
SQL-JDBC, XML |
Maps Java to data store which can be RDMBS, XML, or other. XML configuration
using JDOM. |
DB XML
Transform and
DB
XML Vision (Data Mirror) |
SQL- XML, XML => XML, WML, HTML, XPATH, SOAP (JAXP) |
DB XML Transform performs customized RDBMS-XML mapping and is JAXM 1.1
SOAP compatible. Visual XML - multi-Database modeling/ query tool and data transform tool that provides customizable
RDBMS-XML transforms for B2B integration. DB XML Vision provides a subset of DB XML Transform features see Feature
Comparison table on this page. |
| DbGen |
SQL-JDBC |
Reverse engineers database tables into Java data and test classes. |
Embarcadero:
. DB Artisan
. ER Studio
. ER
Studio Repository |
SQL-JDBC, XML, |
General database modeling tool. Visual entity relation design tool that
supports logical and physical modeling, generates Java classes and supports round-trip and forward engineering.
Metadata can be saved in RDBMS or as XML (requires Windows to operate). Has a number of related tools |
| ExoLab: Castor |
JDO-like, SQL, OQL, JDBC, LDAP, XML, DSML |
Supports distributed directory transactions, events; Provides classes for
XML, Directory, XADirectory, Provides a type mechanism to assure conversion |
| Fisher
ObjecttoRDBMS |
SQL-JDBC |
Runtime support for instance variables persistence mapped to database by
name. Has object caching, supports non-trivial queries with expressions and object hierarchy. |
| GEBIT:
TREND |
SQL-JDBC, DDL, XMI, UML, EJB, OQL |
Complete enterprise framework including: Access-Layer, easy OR-Mapping,
UML-Meta Model, J2EE-enabled. Can be used from every Java IDE and Supports all major UML-Tools. GUI-framework supports
TREND Beans, activities (GUI-Workflow) and generation of business-object editors. Furthermore it has data-entry
application, UML-Runner, DB schema generation and reverse engineering, resource-editors, RPC-generators, multi-language
support and much more. Delivered with 100% pure Java Source-Code. |
Gemstone:
. Facets
. CMP Accelerator
. GemFire |
JDO, RDBMS, JTA,JSA, JCA, JMS, JCE, JNDI, XML |
Design: Generation of CMP with CocoBase and Toplink integration integrates
with IDEs. Run time: Transaction, high security, clustering, caching with administrative tools integrates with
WebSphere, WebLogic, JBoss. |
| HiT:
jAllora |
SQL-JDBC-XML, JMS, JAXP, SOAP, XSD/ DTD, DDL |
A mapping tool from XML to RDBMS. jAllora provides visual mapping using
XML Schema, DTD, DOM or SAX level 2 to an existing RDBMS. The product can then perform RDBMS extracts into XML
(or Java objects) or update the database from an XML source (or from Java objects). It also supports B2B and EAI
message queuing with XML-JMS using a JMS providers (Sonic, Fiorano, MQ Series, JMQ). Provides IDE wizards (for
Forte for Java, JBuilder, Webgain). Note: HiT Software also publishes an Allora for Windows version - plus a DB2
JDBC driver and other database tools. See datasheet. |
IBM: Crossworlds:
. Map
Designer
. Business
Object Designer
. ODK
. InterChange Server |
SQL-JDBC, XML, various EAI platforms |
CrossWorlds is an integration server rather than a persistence tool - but
it has extensive and interesting data mapping capabilities and it can map XML and other systems with databases.
The Map Designer is a visual tool that integrates with CrossWorlds to provide high-volume transformations in a
business integration environment. Business Object Designer provides Business Object-based mapping with discovery
agents for various data sources (e.g. JDBC, or specific back-end application systems e.g. SAP). These run on top
of InterChange Server. ODK is an discovery agent development kit. |
IBM:
. WrapperGenerator |
XSD, DDL |
Tool transforms XSD (XML Schema) into DDL and XML into SQL tables. Enables
queries of XML using SQL. Does not work with DTD, but alphaWorks also has tools to convert DTD into XSD. |
| JDatabase Wizard |
SQL-JDBC, Swing |
GUI that explores SQL Metadata and generates Java code. Supports tables,
views, stored-procedure calls. Has configurable type mappings. |
| HemTech: JDO Genie |
JDO, J2EE, Multiple VM |
Supports managed and unmanaged JDO. JDO Genie Workbench enables metadata
editing. Has runtime JDO Genie engine but supports persistence management through PMs across multiple JVM. |
| Hibernate |
SQL-JDBC, JMX, J2EE |
ODMG 3.0-like. Tranparent persistance without byte-code, OO Queries, Collections,
extensible type system, multiple O/R strategies, polymorphic associations, lazy instantiation, caching, see feature list. |
| Hywy: PE:J |
SQL-JDBC, XML, JSP, DDL, UML, JDO, J2EE |
Generates Java, JSP, round-trip integration with UML tools. |
| Infoobjects: ObjectDRIVER |
ODMG, SQL-ODBC, XML-QL, EJB, OQL |
ODMG-compliant open Object Wrapper for RDBMS, XML-based repository tool.
Supports re-engineering and data reorganization. Supports data mining and highly complex queries. Provides middleware
layer that supports B2B e-business connections based on a number of XML formats. Performs OQL or SQL queries on
database and on XML data (XML-QL). Has console interface. See architecture diagram (note
implementation uses ODBC, not JDBC). |
| jRelational Framework (IS) |
SQL-JDBC, EJB |
Freeware Java-SQL framework that automates much RDBMS coding and provides
scalable run-time coarse-grained mapping services that is geared tooutperform one-to-one entity to table mappings.
See jRF and EJB for additional explanation. |
| db.apache: OJB: Object Relational
Bridge (Tom Mahler) |
SQL-JDBC, ODMG, XML, OQL, JDO, EJB, LDAP |
Created by Thomas Mahler, OJB provides an ODMG 3.0 facade with dynamic
mapping and an XML-based repository. The mapping uses an identity object as a placeholder enabling lazy proxies. Version 1.0
was released 2004. See Ojb
Wiki. Current work is described on the Wiki OjbNextSteps. See discussion
board and mailing list. See also Source Forge page. |
| Jakarta: Torque |
SQL-JDBC-XML, XSD, DTD, DDL |
Generates database SQL Schema (DDL) from an XSD (XML schema) source - part
of the Turbine project. |
| JavalinSoft: JGenerator |
SQL-JDBC, EJB, JSP, WSDL |
Enterprise Software Automation tool for generating Java that conforms to
J2EE design patterns. JGenerator can create, compile and deploy Beans for in-memory, JDBC, EJB, JSP and Web service
applications. The tool includes JInsight, an entity-relationship fromt-end
that runs in the JSP/Servlet layer. |
| JBoss: JAWS-Minerva |
SQL-JDBC, CMP, Pooling |
Provides CMP-RDBMS mapping and Java-RDBMS data type translation. (Minerva
provides connection pooling). |
| JCorporate:
DB Objects/Expresso |
SQL-JDBC, DDL |
Generates DBObject Java code (like a light-weight entity bean) from existing
database. Or DBObjects in Java can be collected into a "Schema" and used to generate DDL for an RDBMS.. |
| J:Interprises:
JETGen Up Dec 16 |
SQL-JDBC, XML XSLT |
Generates metadata in XML, then uses XSLT to generate Java code for a data
access layer. |
| Kimble: COBRA |
SQL-JDBC, CORBA, RMI |
Dictionary driven object persistence layer that encapsulates persistence
mechanism and supports n-tier architecture. See examples in whitepaper. |
| Knizhnik:
JORA |
SQL-JDBC |
Creates and runs SQL based on supplied table mapping classes. |
| LIBeLIS:
LiDO JDO Drivers |
JDO, SQL, XML, some ODBMS |
JDO interfaces to RDBMS, to Versant, and binary data files. Essentially
the drivers make products like Versant enJin JDO compatible. Eric Samson gave an interesting presentation on on JDO and LIBeLIS
at the 2001 ObjectWeb. |
| MiddleGen |
SQL-JDBC, Ant, XDoclet, CMP 2.0, JDO, Struts, Velocity |
A code generator, Middlegen provides JDO, generates EJB CMP 2.0 and JSP/Struts
and Velocity. See Home
page. |
| MetaMatrix Server |
SQL-JDBC, XML, Servlet |
Scalable metadata management tool. Maps metadata from multiple connected
data sources. Allows query and update of data sources and enables cross-source joins. Supports asynchronous data
sources as well. Includes MetaData Modeler and MetaBase Repository. Supports single sign-on security model. Appears
to developer as a database. Deployed as a suite of EJBs. See data sheets and white papers.
MetaBase Repository is also available separately. |
| MVCSoft Persistence Manager |
SQL-JDBC, EJB, CMP |
Designed to support EJB - enables very detailed control optimistic vs.
pessimistic locking, key configuration. Supports JBoss, Jonas, WebLogic, WebSphere, Orion, OC4J, HPAS, and JRun |
| ObjectDB
JDO Explorer |
ODBMS JDO, JDOQL |
ObjectDB JDO Explorer enables exploration of an ObjectDB (ODBMS) database
model supports IDEs: JBuilder, NetBeans, Eclipse. Java 1.4. |
| ObjectFrontier
FrontierSuite and FrontierSuite for JDO |
SQL-JDBC, JDO, UML, EJB 2.0, CMP 2.0, JTA, JCA, JNDI |
Frontier Suite is a cross-platform JDO and EJB persistence manager that
provides very wide connectivity. CMP 2.0 for an EJB server (container). FrontierModeler is a UML-based modeling
tool with XML interfaces, plus class builder, and object query interface. ReModeler provides model integration
with various RDBMS. Runtime provides JTA transactionality and integrates with JDBC through JCA. |
| Object
Industries JRelay |
SQL-JDBC, EJB, JDO, CORBA, DDL |
Generates SQL for inserting and updating objects. Design time features:
JRelay Workbench, a graphical O/R mapping tool and JDO-compliant source-code enhancer and round-trip engineering
tool - from source code to DDL or from DDL to source code. Provides several inheritance schemes. Run time features:
Object caching, performance optimization , portable across RDBMSs. Enterprise version supports EJB, transactions,
CORBA. |
| Object Style: Cayenne Style |
SQL-JDBC XML., DDL, JSP |
Open source, reverse/forward engineering of RDBMS schema with GUI tool
Cayenne Modeler. Integrates with JSPs, Struts see WebApp Struts tutorial. |
| Orient Technologies ODBMS |
JDO, ODMG, ODBMS, C++. |
Orient ODBMS Just Edition is a small-footprint high speed ODBMS that supports
ODMG plus JDO and a SQL-92 subset. Has free SDK and low-cost run-time system licenses (free for non-commercial
use) for Windows, Linux. Orient ODBMS Enterprise Edition providesa an intelligent distributed cache architecture.
Orient ODBMS is supported by design and management tools: Orient Explorer, Orient Designer, Orient Administrator,
dynamic configuration. |
| Osage Persistence Plus |
SQL-JDBC XML. DDL |
Open source run time dynamically SQL generation enables access to dependent
objects; also generates DDL, Java classes and provides connection pooling. based on Scott Ambler's white paper. Author is planning
on implementing lazy loads (see Martin Fowler's definition .and Rich
Katz's lazy proxies material). |
| |
|
|
| Player Project |
SQL-JDBC |
Open source Run time persistence layer, also based on Scott Ambler's white paper. |
| Propel
Distributed Services Platform |
SQL-JDBC, XML, J2EE, HTML |
Provides scalable, high-speed transactions through persistence queuing;
supports multiple in-memory and disk based databases; XML/API-based object mapping layer ,query interface, global
caching - including HTML fragments for Web page assembly. |
| ObjectMatter: Visual BSF |
SQL-JDBC DDL |
Dynamic mapping. Includes server and GUI (Swing) modeling and mapping tool.
Generates SQL-DDL scripts. Supports DB: stored procedures, "legacy" (SQL-89/92) foreign keys, Java: heterogenous
collections.Example |
| Oracle:
TopLink |
SQL-JDBC, EJB, JDO, EJB 1.1/2.0 BMP, JTS, XML |
Visual editor, dynamic metadata-driven SQL generation runtime. Persist
Java objects or BMPs in J2EE. Supports entity bean mapping (JDO optional), DB stored procedures. views, joins.DDL
and table generation. . See Data Sheet. |
| Poet:
FastObjects |
JDO, ODBMS, ODMG 3.0, XML, C++ |
JDO built on small-footprint ODBMS that provides parallel and nested transactions,
multi-thread. Provides XML import and export. built-in failover/failback. Plug-ins for JBuilder, NetBeans, Rational |
| PrismTech:
Open Fusion |
SQL-JDBC, JDO |
API implements JDO 0.8 - maps Java classes to RDBMS schema See data
sheet and diagram. |
| Rettig: JAXOR |
SQL-JDBC, XML, Ant |
"Pluggable" mapper from XML description generates Java code that
can use Lazy Queries and Lazy Loads. Has philosophy of "don't load more data than you have to." Multiple
columns can share "SuperTypes." Runtime metadata available. See feature list. |
| Sadan:
CMaker |
SQL-JDBC: |
Reverse engineers RDBMS into Java classes. |
| Servertec POS |
SQL-JDBC |
Small footprint (26K). Simple API that looks like Hashtable. POS will run
on JDK 1.1 or better. |
| Secant: Object
Integrator |
SQL-JDBC, C++, UML |
Provides application development, class to RDBMS mapping, run-time performance
and recovery capabilities. Provides UML integration through a link to Rational Rose. |
| Servidium: JayDoh |
SQL-JDBC, JSP, HTML, XML |
Generates JDBC classes (for BMP) from data bindings and combines with templated
WebApps (JSP and DHTML). The tool is XML driven. |
| IntelliBO 2
(Signsoft) |
SQL-JDBC, JDO, CLOB/BLOB SQL |
Graphical development environment generates classes and Swing components
from RDBMS tables and provides JBuilder integration. JDO: "fast adaptive" Class Enhancer. Run time supports
caching, many RDBMS, XADataSource, JNDI DataSource optimistic/pessimistic locking. |
| SimpleORM |
SQL-JDBC, DDL, EJB 2 CMP |
Full featured thin-layer O/R tool. Unique design provides advanced features
yet avoids byte-code enhancement. Provides caching, asynchronous batching of SQL, lazy loads, cascading foreign
keys, generalized get/set methods that can easily detect updates, and appropriate lock processing for short and
long-running transactions. See whitepaper. Open source tool,
by Dr. Anthony Berglas, Univ Queensland. |
| SoftwareTree: JDX |
SQL-JDBC, DDL, JNDI |
Supports metadata, SQL type substitutions, distributed transactions, CORBA;Schema
tool supports reverse engineering of classes; DB: supports views. MS SQL, Oracle, Sybase, DB2, Access, Cloudscape,
Pointbase, Interbase. Has optional runtime server JDXServer and and GUI tool JDXStudio. Supports JNDI data sources,
Collections. See the cute little applet that runs in the fact sheet. |
| SolarMetric:
KodoJDO |
JDO, SQL-JDBC |
Database access without coding SQL or major source code changes; implements
vast majority of JDO final spec - including query filters and maps supports JDBC 1.x, 2, JBoss, WebLogic, a number
of RDBMSs. |
| Sun: JavaBlend |
SQL, OQL,JDBC |
Supports Dynamic OQL, EJBs, collections, transactions (pessimistic or optimistic
concurrency); Supports DB multiple keys, foreign keys, joins, |
| Sybase: PowerDesigner |
SQL-JDBC, UML, XML, PowerBuilder |
Visual class/metadata repository-driven UML-based database engineering
and modeling tool. Supports major databases. Reverse engineers database schema. Generates code for Java (and PowerBuilder). |
| Rexip JDO (TCCybersoft) |
JDO |
JDO implementation. |
| TangoSol Coherence |
EJB CMP, HTTP Session, JTA, J2CA, NIO Cluster jCache (JSR 107) |
Cameron Purdy's Coherent clustering software. TangoSol both supports Caching
for database-related applications and interoperates with a JDO and JDBC solutions. Now works with SoftwareTree
JDX. See Cameron's column /dev/null |
| TextGenerator: UniT |
SQL, XML, HTML, RTF, LaTex |
Generates source code and text files in various formats: SQL, Java, C/C++, |
| Thought Inc: CocoBase |
SQL-JDBC, UML/XMI, EJB (CMP, BMP), JSP, Servlets, metadata API |
CocoBase Enterprise O/R is optimized for EJB and Java and supports BMP,
CMP and session beans. CocoBase maps database tables, generates scaleable/high performance Java, CMP, BMP, JSP's.
It deploys to a wide selection of EJB J2EE App servers (see Data Sheet). Can be developed
using Sun FfJ/NetBeans IBM VAj, and JBuilder. Recent advances to the product allow transparent persistence over
local and distributed environments and the integration of UML/XMI modeling tools (including Together Control Center
and RationalRose). Includes visual mapping and map editing tool, admin tool, metadata repository with APIs, transparent/dynamic
SQL; Supports DB reverse engineering, table creation |
| Versant: enJin |
JDO-like, SQL-JDBC, EJB |
Supports CORBA, Object model to DDL generation, EJB |
| XGen |
XML, JDBC |
Convert XML to JDBC 2.0 compatible bean |
| XORM |
JDOQL, SQL, JDBC |
Extensible Object-Relational Mapping supports JDOQL and a number of database
mapping and JDBC optimization techniques including lazy/partial loads, object caching, connection pooling, custom
SQL queries. See feature
list. |
|