home *** CD-ROM | disk | FTP | other *** search
- ## 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
-