Ce contenu n'est pas disponible dans la langue sélectionnée.
Chapter 7. Using Hibernate with JBoss Data Virtualization
7.1. Configure Hibernate for Use with JBoss Data Virtualization
Prerequisites
- You must have the JBoss Data Virtualization JDBC API client JAR file (
teiid-client.jar) and the JBoss Data Virtualization hibernate dialect JAR file (teiid-hibernate-dialect-VERSION.jar) in Hibernate's classpath. These files are found inEAP_HOME/modules/system/layers/dv/org/jboss/teiid/client/main/.These are required for theorg.teiid.dialect.TeiidDialect,org.teiid.jdbc.TeiidDriverandorg.teiid.jdbc.TeiidDataSourceclasses.
Procedure 7.1. Configure Hibernate for Use with JBoss Data Virtualization
Open the Hibernate configuration file
Open thehibernate.cfg.xmlfile.Specify the JBoss Data Virtualization driver class
Specify the JBoss Data Virtualization driver class in theconnection.driver_classproperty:<property name="connection.driver_class"> org.teiid.jdbc.TeiidDriver </property>
Set the Connection URL
Specify the URL for the VDB in theconnection.urlproperty:<property name="connection.url"> jdbc:teiid:VDB-NAME@mm://HOST:POST;user=USERNAME;password=PASSWORD </property>
Note
Be sure to use a local connection if Hibernate is in the same VM as the application server. .Specify the dialect class
Specify the JBoss Data Virtualization dialect class in thedialectproperty:<property name="dialect"> org.teiid.dialect.TeiidDialect </property>
Note
Alternatively, the connection properties can be added to the
hibernate.properties file instead of hibernate.cfg.xml:
hibernate.connection.driver_class=org.teiid.jdbc.TeiidDriver hibernate.connection.url=jdbc:teiid:VDB-NAME@mm://HOST:PORT hibernate.connection.username=USERNAME hibernate.connection.password=PASSWORD hibernate.dialect=org.teiid.dialect.TeiidDialect
Note
Since your VDBs will likely contain multiple source and view models with identical table names, you will need to fully qualify table names specified in Hibernate mapping files:
<class name="CLASSNAME" table="SOURCE/VIEW_MODEL_NAME.[SCHEMA_NAME.]TABLENAME"> ... </class>
For example:
<class name="org.teiid.example.Publisher" table="BOOKS.BOOKS.PUBLISHERS"> ... </class>
