home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / conf / db.properties < prev    next >
Encoding:
Text File  |  2003-06-04  |  5.1 KB  |  160 lines
  1. ## ConnectionPooling, set true for container pooling (don't do it).
  2. bugzero.container-pooling=false
  3.  
  4. ## the database name is case sensitive:
  5. ## you can use mysql, oracle, mssql, access, ...
  6. ## specify what database system to use here (use lower case)
  7. bugzero.database=mysql
  8.  
  9. ## for MS Access (access) or local DSN 
  10. ## you need replace bugzero_db with your dsn you created.
  11. bugzero.access.driver=sun.jdbc.odbc.JdbcOdbcDriver
  12. bugzero.access.url=jdbc:odbc:bugzero_db
  13. bugzero.access.user=
  14. bugzero.access.password=
  15. bugzero.access.expireTime=28800000
  16. bugzero.access.updateTime=5400000 
  17.  
  18. ## for MySQL (mysql)
  19. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  20. bugzero.mysql.driver=com.mysql.jdbc.Driver
  21. bugzero.mysql.url=jdbc:mysql://localhost:3306/bugzero_db?autoReconnect=true
  22. bugzero.mysql.user=
  23. bugzero.mysql.password= 
  24. bugzero.mysql.expireTime=28800000
  25. bugzero.mysql.updateTime=5400000 
  26.  
  27. ## for MS SQL Server (mssql)
  28. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  29. bugzero.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
  30. bugzero.mssql.url=jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=bugzero_db
  31. bugzero.mssql.user=sa
  32. bugzero.mssql.password=
  33. bugzero.mssql.expireTime=28800000
  34. bugzero.mssql.updateTime=5400000 
  35.  
  36. ## for Oracle (oracle)
  37. ## you need replace the database_hostname(localhost), sid_name, and username/password
  38. bugzero.oracle.driver=oracle.jdbc.driver.OracleDriver
  39. bugzero.oracle.url=jdbc:oracle:thin:@localhost:1521:sid_name
  40. bugzero.oracle.user=bugzero
  41. bugzero.oracle.password=
  42. bugzero.oracle.maxConnection=100
  43. bugzero.oracle.expireTime=28800000
  44. bugzero.oracle.updateTime=5400000 
  45.  
  46. ## for Sybase (sybase)
  47. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  48. bugzero.sybase.driver=com.sybase.jdbc2.jdbc.SybDriver
  49. bugzero.sybase.url=jdbc:sybase:Tds:localhost:5000/bugzero_db
  50. bugzero.sybase.user=
  51. bugzero.sybase.password= 
  52. bugzero.sybase.expireTime=28800000
  53. bugzero.sybase.updateTime=5400000 
  54.  
  55. ## for IBM db2 (db2)
  56. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  57. bugzero.db2.driver=COM.ibm.db2.jdbc.net.DB2Driver
  58. bugzero.db2.url=jdbc:db2://localhost/bugzero_db
  59. bugzero.db2.user=
  60. bugzero.db2.password= 
  61. bugzero.db2.expireTime=28800000
  62. bugzero.db2.updateTime=5400000 
  63.  
  64. ## for PostgreSql (postgresql)
  65. ## you need replace the database_hostname(localhost), bugzero_db, and username/password
  66. bugzero.postgresql.driver=org.postgresql.Driver
  67. bugzero.postgresql.url=jdbc:postgresql://localhost:5432/bugzero_db
  68. bugzero.postgresql.user=
  69. bugzero.postgresql.password= 
  70. bugzero.postgresql.expireTime=28800000
  71. bugzero.postgresql.updateTime=5400000 
  72.  
  73. ## for PointBase 
  74. ## you need replace bugzero_db.
  75. bugzero.pointbase.driver=com.pointbase.jdbc.jdbcUniversalDriver
  76. bugzero.pointbase.url=jdbc:pointbase:bugzero_db,new
  77. bugzero.pointbase.user=
  78. bugzero.pointbase.password= 
  79. bugzero.pointbase.expireTime=28800000
  80. bugzero.pointbase.updateTime=5400000 
  81.  
  82. ## weblogic datasource
  83. ## you need create a datasource called bugzero.db.datasource
  84. bugzero.jndi.context=weblogic.jndi.WLInitialContextFactory
  85. bugzero.jndi.url=t3://localhost:7001
  86. bugzero.db.datasource=bugzero.db.datasource
  87.  
  88. ## database data type convertion
  89. ##
  90. oracle.VARCHAR(=VARCHAR2(
  91. oracle.BIGINT=NUMBER(19)
  92. oracle.SMALLINT=NUMBER(3)
  93. oracle.TINYINT=NUMBER(2)
  94. oracle.LONGTEXT=VARCHAR2(4000)
  95. oracle.LONGBINARY=LONG RAW
  96. oracle.DATETIME=DATE
  97. oracle.TIMESTAMP=DATE
  98. oracle.SET_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
  99. oracle.WHERE_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
  100. oracle.ON_DELETE_CASCADE=ON DELETE CASCADE
  101.  
  102. #For Ms SQL 7, set BIGINT to NUMERIC(19) and set ON_DELETE_CASCATE to empty
  103. #mssql.BIGINT=NUMERIC(19)
  104. mssql.LONGTEXT=TEXT
  105. mssql.LONGBINARY=IMAGE
  106. mssql.TIMESTAMP=DATETIME
  107. mssql.SET_DATE?=?
  108. mssql.WHERE_DATE?=?
  109. mssql.ON_DELETE_CASCADE=ON DELETE CASCADE
  110.  
  111. access.BIGINT=INT
  112. access.SMALLINT=INT
  113. access.TINYINT=INT
  114. access.LONGTEXT=MEMO
  115. access.SET_DATE?=?
  116. access.WHERE_DATE?={ts ?}
  117. access.ON_DELETE_CASCADE=
  118.  
  119. # if you use MS SQL Server through a local DSN, un comment out the following.
  120. #access.LONGTEXT=TEXT
  121. #access.LONGBINARY=IMAGE
  122. #access.TIMESTAMP=DATETIME
  123. #access.WHERE_DATE?=?
  124.  
  125. sybase.LONGTEXT=TEXT
  126. sybase.LONGBINARY=IMAGE
  127. sybase.TIMESTAMP=DATETIME
  128. sybase.SET_DATE?=?
  129. sybase.WHERE_DATE?=?
  130. # Sybase does not support ON DELETE CASCADE 
  131. sybase.ON_DELETE_CASCADE=
  132.  
  133. db2.LONGTEXT=LONG VARCHAR
  134. #db2.LONGBINARY=LONG VARCHAR FOR BIT DATA
  135. db2.LONGBINARY=BLOB(10M)
  136. db2.TINYINT=SMALLINT
  137. db2.SET_DATE?=?
  138. db2.WHERE_DATE?=?
  139. db2.ON_DELETE_CASCADE=ON DELETE CASCADE
  140.  
  141. postgresql.TINYINT=SMALLINT
  142. postgresql.LONGTEXT=TEXT
  143. #for postgresql 7.1 or earlier, use postgresql.LONGBINARY=OID
  144. #postgresql.LONGBINARY=OID
  145. postgresql.LONGBINARY=bytea
  146. postgresql.SET_DATE?=?
  147. postgresql.WHERE_DATE?=?
  148. postgresql.ON_DELETE_CASCADE=ON DELETE CASCADE
  149.  
  150. mysql.LONGTEXT=TEXT
  151. mysql.LONGBINARY=LONGBLOB
  152. mysql.SET_DATE?=?
  153. mysql.WHERE_DATE?=?
  154. mysql.ON_DELETE_CASCADE=
  155.  
  156. pointbase.TINYINT=SMALLINT
  157. pointbase.LONGTEXT=CLOB(64K)
  158. pointbase.LONGBINARY=BLOB(10M)
  159. pointbase.ON_DELETE_CASCADE=ON DELETE CASCADE
  160.