database.properties 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. ##########################
  2. ### DataBase Platforms ###
  3. ##########################
  4. jdbc.rowMapperFactory defaultRowMapperFactory
  5. jdbc.handler defaultLobHandler
  6. #jdbc.handler defaultLobHandler
  7. hibernate.jdbc.batch_size 10
  8. ### Oracle
  9. #hibernate.dialect org.hibernate.dialect.Oracle9Dialect
  10. #hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
  11. #hibernate.connection.username wkh
  12. #hibernate.connection.password wkh
  13. #hibernate.connection.url jdbc:oracle:thin:@cftest:1521:oracle
  14. #Sybase 15.0
  15. #hibernate.dialect org.hibernate.dialect.SybaseDialect
  16. #hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
  17. #hibernate.connection.url jdbc:jtds:sybase://cf-yjp:5000/cf;charset=utf-8;SendStringParameterAsUnicode=true
  18. #hibernate.connection.username
  19. #hibernate.connection.password
  20. ## MySQL
  21. #hibernate.dialect org.hibernate.dialect.MySQLDialect
  22. #hibernate.connection.driver_class com.mysql.jdbc.Driver
  23. #hibernate.connection.url jdbc\:mysql\://192.168.1.159\:3306/clis
  24. #
  25. #hibernate.connection.username root
  26. #hibernate.connection.password bhadmin
  27. #hibernate.dialect org.hibernate.dialect.MySQLDialect
  28. #hibernate.connection.driver_class com.mysql.jdbc.Driver
  29. #hibernate.connection.url jdbc\:mysql\://localhost\:3306/clis
  30. #
  31. #hibernate.connection.username root
  32. #hibernate.connection.password xmadage
  33. jdbc.driver=com.mysql.jdbc.Driver
  34. jdbc.url=jdbc:mysql://172.16.0.71:3306/clis?characterEncoding=utf8
  35. jdbc.username=root
  36. jdbc.password=ewms
  37. #jdbc.driver=com.mysql.jdbc.Driver
  38. #jdbc.url=jdbc:mysql://192.168.1.157:3306/clis?characterEncoding=utf8
  39. #jdbc.username=root
  40. #jdbc.password=root
  41. hibernate.dialect=org.hibernate.dialect.MySQLDialect
  42. jdbc.initialPoolSize=20
  43. jdbc.maxIdleTime=3600
  44. jdbc.minPoolSize=20
  45. jdbc.maxPoolSize=20
  46. jdbc.testConnectionOnCheckin=true
  47. jdbc.automaticTestTable =sys_c3potest
  48. jdbc.idleConnectionTestPeriod = 600
  49. #hibernate.dialect org.hibernate.dialect.MySQLDialect
  50. #hibernate.connection.driver_class com.mysql.jdbc.Driver
  51. #hibernate.connection.url jdbc\:mysql\://192.168.1.109\:3306/clis
  52. #
  53. #hibernate.connection.username root
  54. #hibernate.connection.password root
  55. ## SQLServer2000
  56. #hibernate.dialect org.hibernate.dialect.SQLServerDialect
  57. #hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
  58. #hibernate.connection.url jdbc:jtds:sqlserver://localhost:1433/cute
  59. #hibernate.connection.username sa
  60. #hibernate.connection.password sa
  61. ## SQLServer2005
  62. #hibernate.dialect org.hibernate.dialect.SQLServerDialect
  63. #hibernate.connection.driver_class com.microsoft.sqlserver.jdbc.SQLServerDriver
  64. #hibernate.connection.url jdbc:sqlserver://server:1433;DatabaseName=Test
  65. #hibernate.connection.username
  66. #hibernate.connection.password
  67. ## Informix
  68. #hibernate.dialect org.hibernate.dialect.Informix9Dialect
  69. #hibernate.connection.driver_class com.informix.jdbc.IfxDriver
  70. #hibernate.connection.url jdbc:informix-sqli://server:7515/uaas:INFORMIXSERVER=k460secsoc
  71. #hibernate.connection.username
  72. #hibernate.connection.password
  73. ## DB2
  74. #hibernate.dialect org.hibernate.dialect.DB2820Dialect
  75. #hibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver
  76. #hibernate.connection.url jdbc:db2://cftest:50000/cf
  77. #hibernate.connection.username
  78. #hibernate.connection.password
  79. # Derby
  80. #hibernate.dialect org.hibernate.dialect.DerbyDialect
  81. #hibernate.connection.driver_class org.apache.derby.jdbc.EmbeddedDriver
  82. #hibernate.connection.url jdbc:derby:src/webapp/WEB-INF/derby;create=true
  83. #hibernate.connection.username
  84. #hibernate.connection.password
  85. ## DO NOT specify hibernate.connection.sqlDialect