DataNucleus RDBMS supports all of the main RDBMS on the market today. These include Oracle, MSSQL, MySQL, PostgreSQL, Sybase, Informix, Apache Derby, HSQLDB, H2, DB2 as well as some others. We are constantly updating our support when new versions of these datastores hit the market.

DataNucleus RDBMS provides object-relational mapping (ORM) support for the full range of situations demanded by todays enterprise applications. This encompasses the following

• Inheritance : support for table per class, single table, unioned inheritance, or a mix of these in the same inheritance tree.
• Relations : support for 1-1, 1-N, M-N, and N-1 relations using join tables or foreign keys.
• Datastore Identity : support for surrogate identity columns
• Composite Identity : support for compound identity where the identity of one object is (part of) the identity of another, using a foreign-key as part of the primary-key
• Cascading : support for cascade persists and deletes
• Secondary Tables : support for persisting part of an object into a secondary table
• Identifier Control : full control over table/column identifiers
• Constraint Specification : full specification capability for primary keys, indices, unique keys, and foreign keys.
• Versioning : support for surrogate version columns

DataNucleus RDBMS supports querying of data using JDOQL, SQL, and JPQL allowing the user choice over their mechanism for retrieving data dependent on their level of experience with each.