1 50 package com.ivata.groupware.container.persistence.hibernate; 51 52 58 59 public final class HibernateSetupConstants { 60 63 public final static String AUTOMATIC_DATABASE_DIALECT 64 = "net.sf.hibernate.dialect.HSQLDialect"; 65 69 public final static String AUTOMATIC_DATABASE_DRIVER 70 = "org.hsqldb.jdbcDriver"; 71 74 public final static String AUTOMATIC_DATABASE_MEMORY_URL = 75 "jdbc:hsqldb:res:" 76 + HibernateSetupConstants.START_DB; 77 80 public final static String AUTOMATIC_DATABASE_PASSWORD = ""; 81 86 public final static String AUTOMATIC_DATABASE_TMP_URL = "jdbc:hsqldb:file:" 87 + System.getProperty("user.home").replace('\\', '/') 88 + "/.ivatagroupware/tmpdb/tmp"; 89 93 public final static String AUTOMATIC_DATABASE_URL = "jdbc:hsqldb:file:" 94 + System.getProperty("user.home").replace('\\', '/') 95 + "/.ivatagroupware/db/hsqldb"; 96 99 public static final String AUTOMATIC_DATABASE_URL_START 100 = "jdbc:hsqldb:file:"; 101 104 public final static String AUTOMATIC_DATABASE_USER_NAME = "sa"; 105 111 public final static String CONFIRM_ATTRIBUTE = "setupConfirmed"; 112 115 public static final String [] DATABASE_DIALECTS = { 116 "", 117 "net.sf.hibernate.dialect.DB2Dialect", 118 "net.sf.hibernate.dialect.DB2400Dialect", 119 "net.sf.hibernate.dialect.DB2390Dialect", 120 "net.sf.hibernate.dialect.FirebirdDialect", 121 "net.sf.hibernate.dialect.FrontbaseDialect", 122 "net.sf.hibernate.dialect.HSQLDialect", 123 "net.sf.hibernate.dialect.InformixDialect", 124 "net.sf.hibernate.dialect.IngresDialect", 125 "net.sf.hibernate.dialect.InterbaseDialect", 126 "net.sf.hibernate.dialect.MckoiDialect", 127 "net.sf.hibernate.dialect.SQLServerDialect", 128 "net.sf.hibernate.dialect.MySQLDialect", 129 "net.sf.hibernate.dialect.OracleDialect", 130 "net.sf.hibernate.dialect.Oracle9Dialect", 131 "net.sf.hibernate.dialect.PointbaseDialect", 132 "net.sf.hibernate.dialect.PostgreSQLDialect", 133 "net.sf.hibernate.dialect.ProgressDialect", 134 "net.sf.hibernate.dialect.SAPDBDialect", 135 "net.sf.hibernate.dialect.SybaseAnywhereDialect", 136 "net.sf.hibernate.dialect.SybaseDialect", 137 }; 138 141 public static final String [] DATABASE_DRIVERS = { 142 "", 143 "COM.ibm.db2.jdbc.net.DB2Driver", 144 "COM.ibm.db2.jdbc.net.DB2Driver", 145 "COM.ibm.db2.jdbc.net.DB2Driver", 146 "org.firebirdsql.jdbc.FBDriver", 147 "com.frontbase.jdbc.FBJDriver", 148 "org.hsqldb.jdbcDriver", 149 "com.informix.jdbc.IfxDriver", 150 "ca.edbc.jdbc.EdbcDriver", 151 "interbase.interclient.Driver", 152 "com.mckoi.JDBCDriver", 153 "com.internetcds.jdbc.tds.Driver", 154 "org.gjt.mm.mysql.Driver", 155 "oracle.jdbc.driver.OracleDriver", 156 "oracle.jdbc.driver.OracleDriver", 157 "com.pointbase.net.netJDBCDriver", 158 "org.postgresql.Driver", 159 "com.progress.sql.jdbc.JdbcProgressDriver", 160 "com.sap.dbtech.jdbc.DriverSapDB", 161 "com.sybase.jdbc2.jdbc.SybDriver", 162 "com.sybase.jdbc2.jdbc.SybDriver" 163 }; 164 167 public static final String [] DATABASE_TYPES = { 168 "Choose one...", 169 "DB2", 170 "DB2 AS/400", 171 "DB2 OS390", 172 "Firebird", 173 "FrontBase", 174 "HypersonicSQL", 175 "Informix", 176 "Ingres", 177 "Interbase", 178 "Mckoi SQL", 179 "Microsoft SQL Server", 180 "MySQL", 181 "Oracle (any version)", 182 "Oracle 9/10g", 183 "Pointbase", 184 "PostgreSQL", 185 "Progress", 186 "SAP DB", 187 "Sybase", 188 "Sybase Anywhere" 189 }; 190 193 public static final String [] DATABASE_URLS = { 194 "", 195 "jdbc:db2//{host_name}:6789/{dbname}", 196 "jdbc:db2//{host_name}:6789/{dbname}", 197 "jdbc:db2//{host_name}:6789/{dbname}", 198 "jdbc:firebirdsql:[//host[:port]/]{database}", 199 "jdbc:FrontBase://{host}:{port}/{database}", 200 "jdbc:hsqldb:http://{server}[:{1476}]", 201 "jdbc:informix-sqli://{host}:{port}/{dbname}: INFORMIXSERVER={ServerName}", 202 "jdbc:edbc://{host}:21072/{host}::{dbname}", 203 "jdbc:interbase://{server}/{full_db_path}", 204 "jdbc:mckoi://{host}[:9157][/{schema}]", 205 "jdbc:freetds:sqlserver://{hostname}[:{4100}]/{dbname}[;{property}={value}[;...]]", 206 "jdbc:mysql://{hostname}[{:3306}]/{dbname}", 207 "jdbc:oracle:thin:@{server}[:{1521}]:{dbname}", 208 "jdbc:oracle:thin:@{server}[:{1521}]:{dbname}", 209 "jdbc:pointbase:embedded:{dbname}", 210 "jdbc:postgresql:[{//host}[{:5432}/]]{dbname}", 211 "jdbc:progress:T:{host}:{port|service-name}:{dbname} -user {userid} -password {password}", 212 "jdbc:sapdb:[//host/]dbname[?name=value[&name=value]*]", 213 "jdbc:sybase:Tds:{host}:{port}/{DBNAME}", 214 "jdbc:sybase:Tds:{host}:{port}?ServiceName={DBNAME}" 215 }; 216 219 public static final String HIBERNATE_CONFIG = "/WEB-INF/classes/hibernate" 220 + ".cfg.xml"; 221 222 225 public final static String HIBERNATE_PROPERTY_DATABASE_DIALECT = 226 "dialect"; 227 230 public final static String HIBERNATE_PROPERTY_DATABASE_DRIVER = 231 "hibernate.connection.driver_class"; 232 235 public final static String HIBERNATE_PROPERTY_DATABASE_PASSWORD = 236 "hibernate.connection.password"; 237 240 public final static String HIBERNATE_PROPERTY_DATABASE_URL = 241 "hibernate.connection.url"; 242 245 public final static String HIBERNATE_PROPERTY_DATABASE_USER_NAME = 246 "hibernate.connection.username"; 247 250 public static final String HSQLDB_LOCK_SUFFIX = ".lck.lck"; 251 254 public static final String HSQLDB_PROPERTIES_SUFFIX = ".properties"; 255 258 public static final String HSQLDB_SCRIPT_SUFFIX = ".script"; 259 263 public static final String START_DB = "/db/igwstart"; 264 265 268 private HibernateSetupConstants() { 269 } 270 } 271 | Popular Tags |