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

From CDOT Wiki
Jump to: navigation, search
(Table 3)
(Table 2)
 
(2 intermediate revisions by the same user not shown)
Line 101: Line 101:
 
|
 
|
 
| Query
 
| Query
| Operator
 
 
| FunctionOperator
 
| FunctionOperator
 
| SQLJoin
 
| SQLJoin
Line 111: Line 110:
 
|<code>appendPrefixHint</code>
 
|<code>appendPrefixHint</code>
 
|x
 
|x
|
 
 
|
 
|
 
|
 
|
Line 120: Line 118:
 
|-
 
|-
 
|<code>appendStringLengthPrefix</code>
 
|<code>appendStringLengthPrefix</code>
|
 
 
|
 
|
 
|x
 
|x
Line 130: Line 127:
 
|-
 
|-
 
|<code>appendSubstringPrefix</code>
 
|<code>appendSubstringPrefix</code>
|
 
 
|
 
|
 
|x
 
|x
Line 141: Line 137:
 
|<code>appendSuffixHint</code>
 
|<code>appendSuffixHint</code>
 
|x
 
|x
|
 
 
|
 
|
 
|
 
|
Line 151: Line 146:
 
|<code>appendTableHint</code>
 
|<code>appendTableHint</code>
 
|x
 
|x
|
 
 
|
 
|
 
|x
 
|x
Line 160: Line 154:
 
|-
 
|-
 
|<code>appendTypeConversion</code>
 
|<code>appendTypeConversion</code>
|
 
 
|
 
|
 
|
 
|
Line 170: Line 163:
 
|-
 
|-
 
|<code>bindIdentity</code>
 
|<code>bindIdentity</code>
|
 
 
|
 
|
 
|
 
|
Line 180: Line 172:
 
|-
 
|-
 
|<code>createSchemaManager</code>
 
|<code>createSchemaManager</code>
|
 
 
|
 
|
 
|
 
|
Line 193: Line 184:
 
|-
 
|-
 
|method
 
|method
|colspan="6" | parameter types
+
|colspan="7" | parameter types
 
|-
 
|-
 
|
 
|
Line 202: Line 193:
 
| SQLInsert
 
| SQLInsert
 
| SQLWork
 
| SQLWork
 +
| Index
 
|-
 
|-
 
|<code>getDuplicateKeyName</code>
 
|<code>getDuplicateKeyName</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 217: Line 210:
 
|x
 
|x
 
|x
 
|x
 +
|
 
|
 
|
 
|-
 
|-
 
|<code>getMaxTime</code>
 
|<code>getMaxTime</code>
 +
|
 
|
 
|
 
|
 
|
Line 228: Line 223:
 
|-
 
|-
 
|<code>getMinTime</code>
 
|<code>getMinTime</code>
 +
|
 
|
 
|
 
|
 
|
Line 236: Line 232:
 
|-
 
|-
 
|<code>getTestSQL</code>
 
|<code>getTestSQL</code>
 +
|
 
|
 
|
 
|
 
|
Line 250: Line 247:
 
|
 
|
 
|
 
|
 +
|x
 
|-
 
|-
 
|<code>isBatchSupported</code>
 
|<code>isBatchSupported</code>
 +
|
 
|
 
|
 
|
 
|
Line 260: Line 259:
 
|-
 
|-
 
|<code>isBatchUpdateCountSupported</code>
 
|<code>isBatchUpdateCountSupported</code>
 +
|
 
|
 
|
 
|
 
|
Line 274: Line 274:
 
|
 
|
 
|x
 
|x
 +
|
 
|-
 
|-
 
|<code>isDateRangeException</code>
 
|<code>isDateRangeException</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 285: Line 287:
 
|<code>isDeadlockException</code>
 
|<code>isDeadlockException</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 293: Line 296:
 
|<code>isDuplicateKeyException</code>
 
|<code>isDuplicateKeyException</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 303: Line 307:
 
|
 
|
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 309: Line 314:
 
|<code>isLockTimeoutException</code>
 
|<code>isLockTimeoutException</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 317: Line 323:
 
|<code>isQueryTimeoutException</code>
 
|<code>isQueryTimeoutException</code>
 
|x
 
|x
 +
|
 
|
 
|
 
|
 
|
Line 339: Line 346:
 
|x
 
|x
 
|}
 
|}
 +
 +
== Javadoc Documentation [https://cs.senecac.on.ca/~pliu/nexj/Javadoc_MySQLAdapter/index.html]==

Latest revision as of 09:47, 26 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 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 Index
getDuplicateKeyName x
getIdentityValue x x x
getMaxTime
getMinTime
getTestSQL
indexNameMatches x
isBatchSupported
isBatchUpdateCountSupported
isBatchable x
isDateRangeException x
isDeadlockException x
isDuplicateKeyException x
isLiteral x
isLockTimeoutException x
isQueryTimeoutException x

Table 4

method parameter types
RelationalSchema ResultSet Column
isUnicode x x x

Javadoc Documentation [1]