Hibernate db2

In this section, you will learn about the db2 configuration in Hibernate.

Hibernate db2

Hibernate db2

In this section, you will learn about the db2 configuration in Hibernate.

Since Hibernate is independent of database, if you are using db2, then you need to change the hibernate.cfg.xml .

The hibernate.cfg.xml configuration file for the db2 is given below :

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
<property name="connection.url">jdbc:db2://192.168.10.13:3306/anky</property>
<property name="connection.username">user</property>
<property name="connection.password">pass</property>

<property name="connection.pool_size">1</property>
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="show_sql">true</property>

<mapping class="net.roseindia.Student" />
<mapping class="net.roseindia.Course" />

</session-factory>
</hibernate-configuration>

The description of the tags of the above configuration file is given below :

  • connection.driver_class : This property element is used to provide the name of the driver class.
  • connection.url : This property element is used to provide the URL for the database connection.
  • connection.username : This property element is used to provide the username by which you are logging to the database.
  • connection.password : This property element is used to provide the password by which you are logging to the database.
  • connection.pool_size : This property element configures the number of connections of connection pool of the built-in Hibernate.
  • dialect : This property defines the particular SQL variant with which the Hibernate will carry on a conversation. Use of this property is necessary when there are multiple databases are targeted by an application.

At last of you will be required to map the persistent class(POJO) file to the configuration.



Tutorials

  1. Introduction To Hibernate 4.0
  2. Complete Hibernate 4.0 Tutorial
  3. Hibernate 4 Tutorial
  4. What's New In Hibernate 4.0 release
  5. Hibernate Architecture
  6. Download Hibernate 4
  7. Hibernate create POJO classes
  8. Hibernate Configuration File
  9. First Hibernate Application
  10. First Hibernate 4 Example with Eclipse
  11. Hibernate 4 Supported Databases List
  12. Hibernate generator Element
  13. Hibernate 4 Annotations
  14. Hibernate 4 Annotation Example
  15. Hibernate 4 One to One Mapping using Annotation
  16. Hibernate 4 One to Many mapping using Annotation
  17. Hibernate One to One Mapping using XML
  18. Hibernate 4 One to Many mapping using XML
  19. Hibernate 4 Many to Many Mapping using Annotation
  20. Hibernate 4 Many to Many Mapping using Xml
  21. Hibernate update Method
  22. Hibernate persist Method
  23. Hibernate saveOrUpdate Method
  24. Hibernate SELECT Clause
  25. Hibernate FROM Clause
  26. Hibernate One to Many Bi-directional Mapping
  27. Hibernate WHERE Clause
  28. Hibernate ORDER BY Clause
  29. Introduction To Hibernate Query Language (HQL)
  30. Hibernate One to One Bi-directional Mapping
  31. Hibernate One to Many Indexed Mapping
  32. Hibernate One to many XML Mapping bag example
  33. Hibernate One to Many XML Mapping list Example
  34. Hibernate One to many XML mapping array Example
  35. Hibernate One to Many Self Join using Annotations
  36. Hibernate GROUP BY Clause
  37. Hibernate Many to Many Self Join using Annotations
  38. Hibernate update Query
  39. Hibernate delete Query
  40. Hibernate insert Query