Difference between revisions of "Research Notes 1/25/2011"

From CDOT Wiki
Jump to: navigation, search
Line 1: Line 1:
−
== Summary ==
+
== Table 1 ==
 
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
|-
 
|-
Line 91: Line 91:
 
|
 
|
 
|
 
|
 +
|}
 +
 +
== Table 2 ==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
|method
 +
|colspan="8" | parameter types
 +
|-
 
|
 
|
 +
| Query
 +
| Operator
 +
| FunctionOperator
 +
| SQLJoin
 +
| Primitive
 +
| SQLInsert
 +
| SQLGenerator
 +
| PreparedStatement
 
|-
 
|-
 
|<code>appendPrefixHint</code>
 
|<code>appendPrefixHint</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>appendStringLengthPrefix</code>
 
|<code>appendStringLengthPrefix</code>
 +
|
 +
|
 +
|x
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>appendSubstringPrefix</code>
 
|<code>appendSubstringPrefix</code>
 +
|
 +
|
 +
|x
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>appendSuffixHint</code>
 
|<code>appendSuffixHint</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>appendTableHint</code>
 
|<code>appendTableHint</code>
 +
|x
 +
|
 +
|
 +
|x
 +
|
 +
|
 
|
 
|
 
|
 
|
Line 115: Line 161:
 
|<code>appendTypeConversion</code>
 
|<code>appendTypeConversion</code>
 
|
 
|
 +
|
 +
|
 +
|
 +
|x
 +
|
 +
|x
 
|
 
|
 
|-
 
|-
Line 120: Line 172:
 
|
 
|
 
|
 
|
 +
|
 +
|
 +
|
 +
|x
 +
|
 +
|x
 
|-
 
|-
 
|<code>createSchemaManager</code>
 
|<code>createSchemaManager</code>
 
|
 
|
 
|
 
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 +
== Table 3 ==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
|method
 +
|colspan="6" | parameter types
 +
|-
 +
|
 +
| SQLException
 +
| PreparedStatement
 +
| Primitive
 +
| Column
 +
| SQLInsert
 +
| SQLWork
 
|-
 
|-
 
|<code>getDuplicateKeyName</code>
 
|<code>getDuplicateKeyName</code>
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>getIdentityValue</code>
 
|<code>getIdentityValue</code>
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|

Revision as of 21:31, 25 January 2011

Table 1

method parameter types
SQLInsert Query Primitive Column SQLJoin Pair
appendIdentityColumn x
appendIdentityPrefix x
appendIdentitySuffix x
appendIdentityValue x
appendInfixHint x
appendLiteral x
aappendMatchStatement x x x
appendNoRowsBlock
appendNoRowsEnd
appendNoRowsStart

Table 2

method parameter types
Query Operator FunctionOperator SQLJoin Primitive SQLInsert SQLGenerator PreparedStatement
appendPrefixHint x
appendStringLengthPrefix x
appendSubstringPrefix x
appendSuffixHint x
appendTableHint x x
appendTypeConversion x x
bindIdentity x x
createSchemaManager

Table 3

method parameter types
SQLException PreparedStatement Primitive Column SQLInsert SQLWork
getDuplicateKeyName
getIdentityValue
getMaxTime
getMinTime
getTestSQL
indexNameMatches
isBatchSupported
isBatchUpdateCountSupported
isBatchable
isDateRangeException
isDeadlockException
isDuplicateKeyException
isLiteral
isLockTimeoutException
isQueryTimeoutException
isUnicode
Override
appendLiteral(StringBuffer buf, String sValue) DONE
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Research_Notes_1/25/2011&oldid=56335"