home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / conf / db.properties < prev    next >
Encoding:
Text File  |  2005-02-08  |  6.3 KB  |  192 lines

  1. # =================================================================
  2. # The database properties.
  3. # =================================================================
  4. #
  5. ## the database name is case sensitive:
  6. ## you can use mysql, oracle, mssql, access, ...
  7. ## specify what database system to use here (use lower case)
  8.  
  9. bugzero.database=mysql
  10.  
  11. ## for MS Access (access) or local DSN 
  12. ## you need replace bugzero_db with your dsn you created.
  13. bugzero.access.driver=sun.jdbc.odbc.JdbcOdbcDriver
  14. bugzero.access.url=jdbc:odbc:bugzero_db
  15. bugzero.access.user=
  16. bugzero.access.password=
  17. bugzero.access.expireTime=28800000
  18. bugzero.access.updateTime=5400000 
  19.  
  20. ## for MySQL (mysql)
  21. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  22. bugzero.mysql.driver=com.mysql.jdbc.Driver
  23. bugzero.mysql.url=jdbc:mysql://localhost:3306/bugzero_db?autoReconnect=true
  24.  
  25. # UTF-8: use the following url if your mysql server does not support it directly (prior to MySQL 4.1).
  26. # For MySQL 4.1 or newer, use utf8 as the default server character set.
  27. #bugzero.mysql.url=jdbc:mysql://localhost:3306/bugzero_db?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
  28. bugzero.mysql.user=
  29. bugzero.mysql.password= 
  30. bugzero.mysql.expireTime=28800000
  31. bugzero.mysql.updateTime=5400000 
  32.  
  33. ## for MS SQL Server (mssql)
  34. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  35. bugzero.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
  36. bugzero.mssql.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bugzero_db;SelectMethod=cursor
  37. bugzero.mssql.user=sa
  38. bugzero.mssql.password=
  39. bugzero.mssql.expireTime=28800000
  40. bugzero.mssql.updateTime=5400000 
  41. bugzero.mssql.fetchSize=10 
  42.  
  43. ## for Oracle (oracle)
  44. ## you need replace the database_hostname(localhost), sid_name, and username/password
  45. bugzero.oracle.driver=oracle.jdbc.driver.OracleDriver
  46. bugzero.oracle.url=jdbc:oracle:thin:@localhost:1521:sid_name
  47. bugzero.oracle.user=bugzero
  48. bugzero.oracle.password=
  49. bugzero.oracle.maxConnection=100
  50. bugzero.oracle.expireTime=28800000
  51. bugzero.oracle.updateTime=5400000 
  52.  
  53. ## for Sybase (sybase)
  54. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  55. bugzero.sybase.driver=com.sybase.jdbc2.jdbc.SybDriver
  56. bugzero.sybase.url=jdbc:sybase:Tds:localhost:5000/bugzero_db
  57. bugzero.sybase.user=
  58. bugzero.sybase.password= 
  59. bugzero.sybase.expireTime=28800000
  60. bugzero.sybase.updateTime=5400000 
  61.  
  62. ## for IBM db2 (db2)
  63. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  64. bugzero.db2.driver=COM.ibm.db2.jdbc.net.DB2Driver
  65. bugzero.db2.url=jdbc:db2://localhost/bugzero_db
  66. bugzero.db2.user=
  67. bugzero.db2.password= 
  68. bugzero.db2.expireTime=28800000
  69. bugzero.db2.updateTime=5400000 
  70.  
  71. ## for IBM db2 on AS/400 (as400)
  72. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  73. bugzero.as400.driver=com.ibm.as400.access.AS400JDBCDriver
  74. bugzero.as400.url=jdbc:as400://bug;date format=iso;time format=iso
  75. bugzero.as400.user=
  76. bugzero.as400.password=
  77. bugzero.as400.expireTime=28800000
  78. bugzero.as400.updateTime=5400000 
  79.  
  80. ## for PostgreSql (postgresql)
  81. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  82. bugzero.postgresql.driver=org.postgresql.Driver
  83. bugzero.postgresql.url=jdbc:postgresql://localhost:5432/bugzero_db
  84. #bugzero.postgresql.url=jdbc:postgresql://localhost:5432/bugzero_db?charSet=UNICODE
  85. bugzero.postgresql.user=
  86. bugzero.postgresql.password= 
  87. bugzero.postgresql.expireTime=28800000
  88. bugzero.postgresql.updateTime=5400000 
  89.  
  90. ## for PointBase 
  91. ## you need replace bugzero_db.
  92. bugzero.pointbase.driver=com.pointbase.jdbc.jdbcUniversalDriver
  93. bugzero.pointbase.url=jdbc:pointbase:bugzero_db,new
  94. bugzero.pointbase.user=
  95. bugzero.pointbase.password= 
  96. bugzero.pointbase.expireTime=28800000
  97. bugzero.pointbase.updateTime=5400000 
  98.  
  99. ## weblogic datasource
  100. ## you need create a datasource called bugzero.db.datasource
  101. bugzero.jndi.context=weblogic.jndi.WLInitialContextFactory
  102. bugzero.jndi.url=t3://localhost:7001
  103. bugzero.db.datasource=bugzero.db.datasource
  104.  
  105. ## database data type convertion
  106. ##
  107. oracle.VARCHAR=VARCHAR2
  108. oracle.BIGINT=NUMBER(19)
  109. oracle.SMALLINT=NUMBER(3)
  110. oracle.TINYINT=NUMBER(2)
  111. oracle.TEXT=VARCHAR2(4000)
  112. oracle.LONGTEXT=VARCHAR2(4000)
  113. oracle.LONGBINARY=LONG RAW
  114. oracle.DATETIME=DATE
  115. oracle.TIMESTAMP=DATE
  116. oracle.SET_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
  117. oracle.WHERE_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
  118.  
  119. #For Ms SQL 7, set BIGINT to NUMERIC(19) and set ON\ DELETE\ CASCATE to empty
  120. #mssql.BIGINT=NUMERIC(19)
  121. mssql.LONGTEXT=TEXT
  122. mssql.LONGBINARY=IMAGE
  123. mssql.TIMESTAMP=DATETIME
  124. mssql.SET_DATE?=?
  125. mssql.WHERE_DATE?=?
  126. #mssql.ON\ DELETE\ CASCADE=
  127.  
  128. # For SQL Servers that have a datetime format different from YYYY-MM-DD HH:MI:SS
  129. #mssql.SET_DATE?=CONVERT(DATETIME,?,120)
  130. #mssql.WHERE_DATE?=CONVERT(DATETIME,?,120)
  131.  
  132. access.BIGINT=INT
  133. access.SMALLINT=INT
  134. access.TINYINT=INT
  135. access.TEXT=MEMO
  136. access.LONGTEXT=MEMO
  137. access.SET_DATE?=?
  138. access.WHERE_DATE?={ts ?}
  139. access.ON\ DELETE\ CASCADE=
  140.  
  141. # if you use MS SQL Server through a local DSN, un comment out the following.
  142. #access.LONGTEXT=TEXT
  143. #access.LONGBINARY=IMAGE
  144. #access.TIMESTAMP=DATETIME
  145. #access.WHERE_DATE?=?
  146.  
  147. sybase.LONGTEXT=TEXT
  148. sybase.LONGBINARY=IMAGE
  149. sybase.TIMESTAMP=DATETIME
  150. sybase.SET_DATE?=?
  151. sybase.WHERE_DATE?=?
  152. # Sybase does not support ON DELETE CASCADE 
  153. sybase.ON\ DELETE\ CASCADE=
  154.  
  155. db2.TEXT=LONG VARCHAR
  156. db2.LONGTEXT=LONG VARCHAR
  157. #db2.LONGBINARY=LONG VARCHAR FOR BIT DATA
  158. db2.LONGBINARY=BLOB(10M)
  159. db2.TINYINT=SMALLINT
  160. db2.SET_DATE?=?
  161. db2.WHERE_DATE?=?
  162.  
  163. as400.TEXT=VARCHAR(2000)
  164. as400.LONGTEXT=VARCHAR(10240)
  165. as400.LONGBINARY=BLOB(10M)
  166. as400.TINYINT=SMALLINT
  167. as400.SET_DATE?={ts ?}
  168. as400.WHERE_DATE?={ts ?}
  169.  
  170. postgresql.TINYINT=SMALLINT
  171. postgresql.LONGTEXT=TEXT
  172. #for postgresql 7.1 or earlier, use postgresql.LONGBINARY=OID
  173. #postgresql.LONGBINARY=OID
  174. postgresql.LONGBINARY=bytea
  175. postgresql.SET_DATE?=?
  176. postgresql.WHERE_DATE?=?
  177.  
  178. mysql.LONGTEXT=TEXT
  179. mysql.LONGBINARY=LONGBLOB
  180. mysql.SET_DATE?=?
  181. mysql.WHERE_DATE?=?
  182. mysql.ON\ DELETE\ CASCADE=
  183.  
  184. pointbase.TINYINT=SMALLINT
  185. pointbase.TEXT=CLOB(64K)
  186. pointbase.LONGTEXT=CLOB(64K)
  187. pointbase.LONGBINARY=BLOB(10M)
  188.  
  189. # some databases need special escapes for the record value
  190. #
  191. escape.mysql.\\=\\\\
  192.