Hibernate方言まとめ

ここでは、DB 2、Sqlサーバ、MySQLなど、各データベースのHIBERNATE方言についてまとめます.

      DB2 :

         1.  < bean id="dataSource" 
         2.    class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
         3.    < property name="driverClassName" 
         4.     value="com.ibm.db2.jcc.DB2Driver"> 
         5.    < /property> 
         6.    < property name="url" 
         7.     value="jdbc:db2://localhost:50000/MyDB"> 
         8.    < /property> 
         9.    < property name="username" value="sp">< /property> 
        10.    < property name="password" value="spspsp">< /property> 
        11. < /bean> 
        12.  
        13. < bean id="sessionFactory" 
        14.    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
        15.    < property name="dataSource"> 
        16.     < ref bean="dataSource" /> 
        17.    < /property> 
        18.    < property name="hibernateProperties"> 
        19.     < props> 
        20.      < prop key="hibernate.dialect"> 
        21.       org.hibernate.dialect.DB2Dialect  
        22.      < /prop> 
        23.      < prop key="hibernate.show_sql">true< /prop> 
        24.     < /props> 
        25.    < /property> 

      sql2005  : SQL2000    .

         1. < bean id="dataSource" 
         2.    class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
         3.    < property name="driverClassName" 
         4.     value="net.sourceforge.jtds.jdbc.Driver"> 
         5.    < /property> 
         6.    < property name="url" 
         7.     value="jdbc:jtds:sqlserver://192.168.1.64:1435"> 
         8.    < /property> 
         9.    < property name="username" value="sp">< /property> 
        10.    < property name="password" value="sp">< /property> 
        11. < /bean> 
        12.  
        13. < bean id="sessionFactory" 
        14.    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
        15.    < property name="dataSource"> 
        16.     < ref bean="dataSource" /> 
        17.    < /property> 
        18.    < property name="hibernateProperties"> 
        19.     < props> 
        20.      < prop key="hibernate.dialect"> 
        21.       org.hibernate.dialect.SQLServerDialect  
        22.      < /prop> 
        23.      < prop key="hibernate.show_sql">true< /prop> 
        24.     < /props> 
        25.    < /property> 
        26.  

      MySQL: 5 6     .

         1. < bean id="dataSource" 
         2.    class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
         3.    < property name="driverClassName" 
         4.     value="com.mysql.jdbc.Driver"> 
         5.    < /property> 
         6.    < property name="url" 
         7.     value="jdbc:mysql://localhost:3306/DBNAME?useUnicode=true&characterEncoding=gbk"> 
         8.    < /property> 
         9.    < property name="username" value="root">< /property> 
        10.    < property name="password" value="">< /property> 
        11. < /bean> 
        12.  
        13. < bean id="sessionFactory" 
        14.    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
        15.    < property name="dataSource"> 
        16.     < ref bean="dataSource" /> 
        17.    < /property> 
        18.    < property name="hibernateProperties"> 
        19.     < props> 
        20.      < prop key="hibernate.dialect"> 
        21.       org.hibernate.dialect.MySQLDialect  
        22.      < /prop> 
        23.      < prop key="hibernate.show_sql">true< /prop> 
        24.     < /props> 
        25.  

以上が3大データベースのHibernate方言です.DB 2は比較的強い、パスワードを強制し、6ビット以上である.さもないと使いません.