cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/types/SqlServer2005DatabaseType.java

   1 /**
   2 * Copyright (C) 2007 EDIT
   3 * European Distributed Institute of Taxonomy
   4 * http://www.e-taxonomy.eu
   5 *
   6 * The contents of this file are subject to the Mozilla Public License Version 1.1
   7 * See LICENSE.TXT at the top of this package for the full license terms.
   8 */
   9
  10 package eu.etaxonomy.cdm.database.types;
  11
  12
  13 /**
  14  * @author a.mueller
  15  *
  16  */
  17 public class SqlServer2005DatabaseType extends DatabaseTypeBase {
  18
  19         //name
  20         protected String typeName = "SQL Server";
  21
  22         //driver class
  23         protected String classString = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  24
  25         //url
  26         protected String urlString = "jdbc:sqlserver://";
  27
  28         //[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
  29
  30     //default port
  31     private int defaultPort = 1433;
  32
  33     //hibernate dialect
  34     private String hibernateDialect = "SQLServerDialect";
  35
  36     public String getConnectionString(String server, String database, int port){
  37         return getConnectionString(server, database, port, null);
  38     }
  39
  40     public String getConnectionString(String server, String database, int port, String instanceName){
  41         String instance = "";
  42         if (instanceName != null && ! instanceName.equals("")){
  43                         instance = "\\" + instanceName;
  44                 }
  45         return urlString + server + instance + ":" + port + ";databaseName=" + database+";SelectMethod=cursor";
  46     }
  47
  48         //Constructor
  49     public SqlServer2005DatabaseType() {
  50         init (typeName, classString, urlString, defaultPort,  hibernateDialect );
  51         }
  52
  53 }