class MSSQLServer extends DatabaseAdapter
- Source
- MSSQLServer.scala
- Alphabetic
- By Inheritance
- MSSQLServer
- DatabaseAdapter
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Instance Constructors
- new MSSQLServer()
Type Members
- class Zip[T] extends AnyRef
- Definition Classes
- DatabaseAdapter
- class ZipIterable[T] extends AnyRef
- Definition Classes
- DatabaseAdapter
Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- def aliasExport(parentOfTarget: QueryableExpressionNode, target: SelectElement): String
- Definition Classes
- DatabaseAdapter
- final def arrayCreationType(ptype: Class[_]): String
- Definition Classes
- DatabaseAdapter
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def bigDecimalTypeDeclaration(precision: Int, scale: Int): String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def bigDecimalTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def binaryTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def booleanTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @native()
- def convertFromBooleanForJdbc(b: Boolean): Boolean
unused at the moment, since all jdbc drivers adhere to the standard that : 1 == true, false otherwise.
unused at the moment, since all jdbc drivers adhere to the standard that : 1 == true, false otherwise. If a new driver would not adhere to this, the call can be uncommented in method convertToJdbcValue
- Definition Classes
- DatabaseAdapter
- def convertFromUuidForJdbc(u: UUID): AnyRef
- Definition Classes
- DatabaseAdapter
- def convertToBooleanForJdbc(rs: ResultSet, i: Int): Boolean
unused for the same reason as def convertFromBooleanForJdbc (see comment)
unused for the same reason as def convertFromBooleanForJdbc (see comment)
- Definition Classes
- DatabaseAdapter
- def convertToJdbcValue(r: AnyRef): AnyRef
Converts field instances so they can be fed, and understood by JDBC will not do conversion from None/Some, so @arg r should be a java primitive type or a CustomType
Converts field instances so they can be fed, and understood by JDBC will not do conversion from None/Some, so @arg r should be a java primitive type or a CustomType
- Definition Classes
- DatabaseAdapter
- def convertToUuidForJdbc(rs: ResultSet, i: Int): UUID
- Definition Classes
- DatabaseAdapter
- def createSequenceName(fmd: FieldMetaData): String
- Definition Classes
- DatabaseAdapter
- def createStatement(conn: Connection): Statement
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def currenSession: AbstractSession
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def databaseTypeFor(fieldMapper: FieldMapper, c: Class[_]): String
- Definition Classes
- DatabaseAdapter
- def databaseTypeFor(fmd: FieldMetaData): String
- Definition Classes
- DatabaseAdapter
- def dateTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def doubleArrayTypeDeclaration: String
- Definition Classes
- DatabaseAdapter
- def doubleTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def dropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String, session: AbstractSession): Unit
- Definition Classes
- DatabaseAdapter
- def dropTable(t: Table[_]): Unit
- Definition Classes
- DatabaseAdapter
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- def exec[A](s: AbstractSession, sw: StatementWriter)(block: (Iterable[StatementParam]) => A): A
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def execFailSafeExecute(sw: StatementWriter, silenceException: (SQLException) => Boolean): Unit
Some methods like 'dropTable' issue their statement, and will silence the exception.
Some methods like 'dropTable' issue their statement, and will silence the exception. For example dropTable will silence when isTableDoesNotExistException(theExceptionThrown). It must be used carefully, and an exception should not be silenced unless identified.
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def executeQuery(s: AbstractSession, sw: StatementWriter): (ResultSet, PreparedStatement)
- Definition Classes
- DatabaseAdapter
- def executeUpdate(s: AbstractSession, sw: StatementWriter): (Int, PreparedStatement)
- Definition Classes
- DatabaseAdapter
- def executeUpdateAndCloseStatement(s: AbstractSession, sw: StatementWriter): Int
- Definition Classes
- DatabaseAdapter
- def executeUpdateForInsert(s: AbstractSession, sw: StatementWriter, ps: PreparedStatement): Int
- Definition Classes
- DatabaseAdapter
- def failureOfStatementRequiresRollback: Boolean
- Definition Classes
- DatabaseAdapter
- def fieldAlias(n: QueryableExpressionNode, fse: FieldSelectElement): String
- Definition Classes
- DatabaseAdapter
- def fillParamsInto(params: Iterable[StatementParam], s: PreparedStatement): Unit
- Definition Classes
- DatabaseAdapter
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable])
- def floatTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def foreignKeyConstraintName(foreignKeyTable: Table[_], idWithinSchema: Int): String
- Definition Classes
- DatabaseAdapter
- def generateAlmostUniqueSuffixWithHash(s: String): String
This will create an probabilistically unique string of length no longer than 11 chars, it can be used to create "almost unique" names where uniqueness is not an absolute requirement, is not ,
This will create an probabilistically unique string of length no longer than 11 chars, it can be used to create "almost unique" names where uniqueness is not an absolute requirement, is not ,
- Definition Classes
- DatabaseAdapter
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
- def getInsertableFields(fmd: Iterable[FieldMetaData]): Iterable[FieldMetaData]
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
- def intArrayTypeDeclaration: String
- Definition Classes
- DatabaseAdapter
- def intTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def isFullOuterJoinSupported: Boolean
- Definition Classes
- MSSQLServer → DatabaseAdapter
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def isNotNullConstraintViolation(e: SQLException): Boolean
Figures out from the SQLException (ex.: vendor specific error code) if it's cause is a NOT NULL constraint violation
Figures out from the SQLException (ex.: vendor specific error code) if it's cause is a NOT NULL constraint violation
- Definition Classes
- DatabaseAdapter
- def isTableDoesNotExistException(e: SQLException): Boolean
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def jdbcDoubleArrayCreationType: String
- Definition Classes
- DatabaseAdapter
- def jdbcIntArrayCreationType: String
- Definition Classes
- DatabaseAdapter
- def jdbcLongArrayCreationType: String
- Definition Classes
- DatabaseAdapter
- def jdbcStringArrayCreationType: String
- Definition Classes
- DatabaseAdapter
- def jdbcTypeConstantFor(c: Class[_]): Int
- Definition Classes
- DatabaseAdapter
- def longArrayTypeDeclaration: String
- Definition Classes
- DatabaseAdapter
- def longTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
- def nvlToken: String
- Definition Classes
- DatabaseAdapter
- def postCreateTable(t: Table[_], printSinkWhenWriteOnlyMode: Option[(String) => Unit]): Unit
When @arg printSinkWhenWriteOnlyMode is not None, the adapter will not execute any statement, but only silently give it to the String=>Unit closure
When @arg printSinkWhenWriteOnlyMode is not None, the adapter will not execute any statement, but only silently give it to the String=>Unit closure
- Definition Classes
- DatabaseAdapter
- def postDropTable(t: Table[_]): Unit
- Definition Classes
- DatabaseAdapter
- def prepareStatement(conn: Connection, statement: String): PreparedStatement
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def quoteIdentifier(s: String): String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def quoteName(s: String): String
- Definition Classes
- DatabaseAdapter
- def setParamInto(s: PreparedStatement, p: StatementParam, i: Int): Unit
- Definition Classes
- DatabaseAdapter
- implicit def string2StatementWriter(s: String): StatementWriter
- Definition Classes
- DatabaseAdapter
- def stringArrayTypeDeclaration: String
- Definition Classes
- DatabaseAdapter
- def stringTypeDeclaration(length: Int): String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def stringTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def supportsAutoIncrementInColumnDeclaration: Boolean
- Definition Classes
- DatabaseAdapter
- def supportsCommonTableExpressions: Boolean
- Definition Classes
- DatabaseAdapter
- def supportsForeignKeyConstraints: Boolean
- Definition Classes
- DatabaseAdapter
- def supportsUnionQueryOptions: Boolean
- Definition Classes
- MSSQLServer → DatabaseAdapter
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def timestampTypeDeclaration: String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def toString(): String
- Definition Classes
- AnyRef → Any
- def uuidTypeDeclaration: String
- Definition Classes
- DatabaseAdapter
- def verifyDeleteByPK: Boolean
Should we verify that when we delete by primary key the JDBC driver reports that no more than one row was affected? MonetDB in particular seems to act badly here
Should we verify that when we delete by primary key the JDBC driver reports that no more than one row was affected? MonetDB in particular seems to act badly here
- returns
true if we should throw an exception if the driver reports more than 1 affected row
- Definition Classes
- DatabaseAdapter
- def viewAlias(vn: ViewExpressionNode[_]): String
- Definition Classes
- DatabaseAdapter
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- def writeColumnDeclaration(fmd: FieldMetaData, isPrimaryKey: Boolean, schema: Schema): String
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeCompositePrimaryKeyConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
- Definition Classes
- DatabaseAdapter
- def writeConcatFunctionCall(fn: FunctionNode, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeConcatOperator(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeCreateTable[T](t: Table[T], sw: StatementWriter, schema: Schema): Unit
- Definition Classes
- DatabaseAdapter
- def writeCteReference(sw: StatementWriter, q: QueryExpressionElements): Unit
- Attributes
- protected[squeryl]
- Definition Classes
- DatabaseAdapter
- def writeDelete[T](t: Table[T], whereClause: Option[ExpressionNode], sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeDropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String): String
- Definition Classes
- DatabaseAdapter
- def writeDropTable(tableName: String): String
- Definition Classes
- DatabaseAdapter
- def writeEndOfFromHint(qen: QueryExpressionElements, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeEndOfQueryHint(isForUpdate: () => Boolean, qen: QueryExpressionElements, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeForeignKeyDeclaration(foreignKeyTable: Table[_], foreignKeyColumnName: String, primaryKeyTable: Table[_], primaryKeyColumnName: String, referentialAction1: Option[ReferentialAction], referentialAction2: Option[ReferentialAction], fkId: Int): String
- Definition Classes
- DatabaseAdapter
- def writeIndexDeclaration(columnDefs: Seq[FieldMetaData], name: Option[String], nameOfCompositeKey: Option[String], isUnique: Boolean): String
- name
the name specified in the Schema, when not None, it must be used as the name
- nameOfCompositeKey
when not None, the column group forms a composite key, 'nameOfCompositeKey' can be used as part of the name to create a more meaningfull name for the constraint, when 'name' is None
- Definition Classes
- DatabaseAdapter
- def writeInsert[T](o: T, t: Table[T], sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeJoin(queryableExpressionNode: QueryableExpressionNode, sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeNvlCall(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writePaginatedQueryDeclaration(page: () => Option[(Int, Int)], qen: QueryExpressionElements, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeQuery(qen: QueryExpressionElements, sw: StatementWriter): Unit
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeQuery(qen: QueryExpressionElements, sw: StatementWriter, inverseOrderBy: Boolean, topHint: Option[String]): Unit
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- def writeRegexExpression(left: ExpressionNode, pattern: String, sw: StatementWriter): Nothing
- Definition Classes
- MSSQLServer → DatabaseAdapter
- def writeSelectElementAlias(se: SelectElement, sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeUnionQueryOptions(qen: QueryExpressionElements, sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeUniquenessConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
- Definition Classes
- DatabaseAdapter
- def writeUpdate(t: Table[_], us: UpdateStatement, sw: StatementWriter): Unit
- Definition Classes
- DatabaseAdapter
- def writeUpdate[T](o: T, t: Table[T], sw: StatementWriter, checkOCC: Boolean): Unit
- Definition Classes
- DatabaseAdapter
- def writeValue(o: AnyRef, fmd: FieldMetaData, sw: StatementWriter): String
- Attributes
- protected
- Definition Classes
- DatabaseAdapter
- implicit def zipIterable[T](i: Iterable[T]): ZipIterable[T]
- Definition Classes
- DatabaseAdapter