Hibernate方言总结
本文总结了各个数据库的HIBERNATE方言，包括DB2，Sql Server以及MySQL的。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.
以上就是三大数据库的Hibernate方言。DB2的比较强悍,强制密码,并且6位以上.否则不用.
页:
[1]