## ConnectionPooling, set true for container pooling (don't do it).
bugzero.container-pooling=false

## 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
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;SelectMethod=cursor;DatabaseName=bugzero_db
bugzero.mssql.user=sa
bugzero.mssql.password=
bugzero.mssql.expireTime=28800000
bugzero.mssql.updateTime=5400000 

## 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 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.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.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')
oracle.ON_DELETE_CASCADE=ON DELETE CASCADE

#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=ON DELETE CASCADE

access.BIGINT=INT
access.SMALLINT=INT
access.TINYINT=INT
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.LONGTEXT=LONG VARCHAR
#db2.LONGBINARY=LONG VARCHAR FOR BIT DATA
db2.LONGBINARY=BLOB(10M)
db2.TINYINT=SMALLINT
db2.SET_DATE?=?
db2.WHERE_DATE?=?
db2.ON_DELETE_CASCADE=ON DELETE CASCADE

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?=?
postgresql.ON_DELETE_CASCADE=ON DELETE CASCADE

mysql.LONGTEXT=TEXT
mysql.LONGBINARY=LONGBLOB
mysql.SET_DATE?=?
mysql.WHERE_DATE?=?
mysql.ON_DELETE_CASCADE=

pointbase.TINYINT=SMALLINT
pointbase.LONGTEXT=CLOB(64K)
pointbase.LONGBINARY=BLOB(10M)
pointbase.ON_DELETE_CASCADE=ON DELETE CASCADE
