home *** CD-ROM | disk | FTP | other *** search
- # =================================================================
- # The database properties.
- # =================================================================
- #
- ## the database name is case sensitive:
- ## you can use mysql, oracle, mssql, access, ...
- ## specify what database system to use here (use lower case)
-
- bugzero.database=mysql
-
- ## for MS Access (access) or local DSN
- ## you need replace bugzero_db with your dsn you created.
- bugzero.access.driver=sun.jdbc.odbc.JdbcOdbcDriver
- bugzero.access.url=jdbc:odbc:bugzero_db
- bugzero.access.user=
- bugzero.access.password=
- bugzero.access.expireTime=28800000
- bugzero.access.updateTime=5400000
-
- ## for MySQL (mysql)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.mysql.driver=com.mysql.jdbc.Driver
- bugzero.mysql.url=jdbc:mysql://localhost:3306/bugzero_db?autoReconnect=true
-
- # UTF-8: use the following url if your mysql server does not support it directly (prior to MySQL 4.1).
- # For MySQL 4.1 or newer, use utf8 as the default server character set.
- #bugzero.mysql.url=jdbc:mysql://localhost:3306/bugzero_db?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
- bugzero.mysql.user=
- bugzero.mysql.password=
- bugzero.mysql.expireTime=28800000
- bugzero.mysql.updateTime=5400000
-
- ## for MS SQL Server (mssql)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
- bugzero.mssql.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bugzero_db;SelectMethod=cursor
- bugzero.mssql.user=sa
- bugzero.mssql.password=
- bugzero.mssql.expireTime=28800000
- bugzero.mssql.updateTime=5400000
- bugzero.mssql.fetchSize=10
-
- ## for Oracle (oracle)
- ## you need replace the database_hostname(localhost), sid_name, and username/password
- bugzero.oracle.driver=oracle.jdbc.driver.OracleDriver
- bugzero.oracle.url=jdbc:oracle:thin:@localhost:1521:sid_name
- bugzero.oracle.user=bugzero
- bugzero.oracle.password=
- bugzero.oracle.maxConnection=100
- bugzero.oracle.expireTime=28800000
- bugzero.oracle.updateTime=5400000
-
- ## for Sybase (sybase)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.sybase.driver=com.sybase.jdbc2.jdbc.SybDriver
- bugzero.sybase.url=jdbc:sybase:Tds:localhost:5000/bugzero_db
- bugzero.sybase.user=
- bugzero.sybase.password=
- bugzero.sybase.expireTime=28800000
- bugzero.sybase.updateTime=5400000
-
- ## for IBM db2 (db2)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.db2.driver=COM.ibm.db2.jdbc.net.DB2Driver
- bugzero.db2.url=jdbc:db2://localhost/bugzero_db
- bugzero.db2.user=
- bugzero.db2.password=
- bugzero.db2.expireTime=28800000
- bugzero.db2.updateTime=5400000
-
- ## for IBM db2 on AS/400 (as400)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.as400.driver=com.ibm.as400.access.AS400JDBCDriver
- bugzero.as400.url=jdbc:as400://bug;date format=iso;time format=iso
- bugzero.as400.user=
- bugzero.as400.password=
- bugzero.as400.expireTime=28800000
- bugzero.as400.updateTime=5400000
-
- ## for PostgreSql (postgresql)
- ## you need replace the database_hostname(localhost), bugzero_db, and username/password
- bugzero.postgresql.driver=org.postgresql.Driver
- bugzero.postgresql.url=jdbc:postgresql://localhost:5432/bugzero_db
- #bugzero.postgresql.url=jdbc:postgresql://localhost:5432/bugzero_db?charSet=UNICODE
- bugzero.postgresql.user=
- bugzero.postgresql.password=
- bugzero.postgresql.expireTime=28800000
- bugzero.postgresql.updateTime=5400000
-
- ## for PointBase
- ## you need replace bugzero_db.
- bugzero.pointbase.driver=com.pointbase.jdbc.jdbcUniversalDriver
- bugzero.pointbase.url=jdbc:pointbase:bugzero_db,new
- bugzero.pointbase.user=
- bugzero.pointbase.password=
- bugzero.pointbase.expireTime=28800000
- bugzero.pointbase.updateTime=5400000
-
- ## weblogic datasource
- ## you need create a datasource called bugzero.db.datasource
- bugzero.jndi.context=weblogic.jndi.WLInitialContextFactory
- bugzero.jndi.url=t3://localhost:7001
- bugzero.db.datasource=bugzero.db.datasource
-
- ## database data type convertion
- ##
- oracle.VARCHAR=VARCHAR2
- oracle.BIGINT=NUMBER(19)
- oracle.SMALLINT=NUMBER(3)
- oracle.TINYINT=NUMBER(2)
- oracle.TEXT=VARCHAR2(4000)
- oracle.LONGTEXT=VARCHAR2(4000)
- oracle.LONGBINARY=LONG RAW
- oracle.DATETIME=DATE
- oracle.TIMESTAMP=DATE
- oracle.SET_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
- oracle.WHERE_DATE?=TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
-
- #For Ms SQL 7, set BIGINT to NUMERIC(19) and set ON\ DELETE\ CASCATE to empty
- #mssql.BIGINT=NUMERIC(19)
- mssql.LONGTEXT=TEXT
- mssql.LONGBINARY=IMAGE
- mssql.TIMESTAMP=DATETIME
- mssql.SET_DATE?=?
- mssql.WHERE_DATE?=?
- #mssql.ON\ DELETE\ CASCADE=
-
- # For SQL Servers that have a datetime format different from YYYY-MM-DD HH:MI:SS
- #mssql.SET_DATE?=CONVERT(DATETIME,?,120)
- #mssql.WHERE_DATE?=CONVERT(DATETIME,?,120)
-
- access.BIGINT=INT
- access.SMALLINT=INT
- access.TINYINT=INT
- access.TEXT=MEMO
- access.LONGTEXT=MEMO
- access.SET_DATE?=?
- access.WHERE_DATE?={ts ?}
- access.ON\ DELETE\ CASCADE=
-
- # if you use MS SQL Server through a local DSN, un comment out the following.
- #access.LONGTEXT=TEXT
- #access.LONGBINARY=IMAGE
- #access.TIMESTAMP=DATETIME
- #access.WHERE_DATE?=?
-
- sybase.LONGTEXT=TEXT
- sybase.LONGBINARY=IMAGE
- sybase.TIMESTAMP=DATETIME
- sybase.SET_DATE?=?
- sybase.WHERE_DATE?=?
- # Sybase does not support ON DELETE CASCADE
- sybase.ON\ DELETE\ CASCADE=
-
- db2.TEXT=LONG VARCHAR
- db2.LONGTEXT=LONG VARCHAR
- #db2.LONGBINARY=LONG VARCHAR FOR BIT DATA
- db2.LONGBINARY=BLOB(10M)
- db2.TINYINT=SMALLINT
- db2.SET_DATE?=?
- db2.WHERE_DATE?=?
-
- as400.TEXT=VARCHAR(2000)
- as400.LONGTEXT=VARCHAR(10240)
- as400.LONGBINARY=BLOB(10M)
- as400.TINYINT=SMALLINT
- as400.SET_DATE?={ts ?}
- as400.WHERE_DATE?={ts ?}
-
- postgresql.TINYINT=SMALLINT
- postgresql.LONGTEXT=TEXT
- #for postgresql 7.1 or earlier, use postgresql.LONGBINARY=OID
- #postgresql.LONGBINARY=OID
- postgresql.LONGBINARY=bytea
- postgresql.SET_DATE?=?
- postgresql.WHERE_DATE?=?
-
- mysql.LONGTEXT=TEXT
- mysql.LONGBINARY=LONGBLOB
- mysql.SET_DATE?=?
- mysql.WHERE_DATE?=?
- mysql.ON\ DELETE\ CASCADE=
-
- pointbase.TINYINT=SMALLINT
- pointbase.TEXT=CLOB(64K)
- pointbase.LONGTEXT=CLOB(64K)
- pointbase.LONGBINARY=BLOB(10M)
-
- # some databases need special escapes for the record value
- #
- escape.mysql.\\=\\\\
-