# =================================================================
# 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.\\=\\\\
