Page tree
Skip to end of metadata
Go to start of metadata

JdbcDataContext

The Apache MetaModel JDBC module is built such that we use as much of the powerful SQL capabilities of JDBC databases as possible (see Query execution strategies). So as such the module does little, except translate JDBC into the MetaModel API, but on the other hand it provides a single interface which translates into any of the many SQL dialects that are out there.

Features of the connector includes:

  • Full implementation of DataContext and UpdateableDataContext.
  • Mapping of MetaModel's data types to the particular set of data types available for the database. For instance MetaModel's STRING will be automatically converted to 'VARCHAR', 'TEXT' etc. depending on the database.
  • Automatic formatting and narrowing of values when interacting with the database.
  • Contains specialization and optimization for many databases, including:
    • PostgreSQL
    • MySQL
    • Microsoft SQL Server
    • Oracle
    • IBM DB2
    • Apache Hive
    • H2
    • SQLite
    • Hsqldb
    • Apache Derby
  • Support for JDBC batch operations when you use BatchUpdateScript.
  • Support for reusable prepared statements (as Compiled queries in MetaModel).
  • Works with single Connections or connection pools (DataSource)

Creating from plain old java code - JdbcDataContext

This is really simple - if you have a JDBC based Connection or a DataSource, simply pass it to new JdbcDataContext(...).

Creating from properties - JdbcDataContextFactory

The JDBC connector can also be driven by properties via MetaModel's DataContextFactory SPI:

final DataContextPropertiesImpl properties = new DataContextPropertiesImpl();
properties.put("type", "jdbc");
properties.put("url", "jdbc:postgresql://localhost:5432/mydb");
DataContext dataContext = DataContextFactoryRegistryImpl.getDefaultInstance().createDataContext(properties);

The following table outlines all the relevant properties for this style of instantiation:

 

Property

Example valueRequiredDescription
typejdbc(tick)Must be set to 'jdbc' or else another type of DataContext will be constructed.
urljdbc:mysql://localhost/sakila(tick)The JDBC URL to use.
driver-classcom.mysql.jdbc.Driver The JDBC driver class name.
usernamejohndoe The username to use when connecting.
passwordqwerty The password to use when connecting.
table-typesTABLE,VIEW A comma-separated list of table types to include in JDBC metadata discovery.
catalogcat01 The JDBC 'catalog' value

Additional behaviour configuration

The module contains a few features that are specific to the JDBC interactions. These are all configured as Java system properties.
System propertyDefault valueDescription
metamodel.jdbc.convert.lobs"false"Whether or not to automatically convert CLOBs into String and BLOBs into byte[].
metamodel.jdbc.batch.updatesDatabaseMetaData.supportsBatchUpdates()Whether or not using the JDBC batch API should be allowed. Set to "true" or "false" to override the default dynamic behavior.
metamodel.jdbc.compiledquery.pool.max.size-1The maximum number of open prepared statements to keep in a pool for the compiled queries.
metamodel.jdbc.compiledquery.pool.idle.timeout500The minimum idle timeout before a prepared statement is marked as evictable.
metamodel.jdbc.compiledquery.pool.eviction.period.millis1000The time between eviction runs in the compiled queries pool.
  • No labels