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

From CDOT Wiki
Jump to: navigation, search
(→‎Table 2)
 
(4 intermediate revisions by the same user not shown)
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
 +
| 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 155:
 
|<code>appendTypeConversion</code>
 
|<code>appendTypeConversion</code>
 
|
 
|
 +
|
 +
|
 +
|x
 +
|
 +
|x
 
|
 
|
 
|-
 
|-
Line 120: Line 165:
 
|
 
|
 
|
 
|
 +
|
 +
|
 +
|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="7" | parameter types
 +
|-
 +
|
 +
| SQLException
 +
| PreparedStatement
 +
| Primitive
 +
| Column
 +
| SQLInsert
 +
| SQLWork
 +
| Index
 
|-
 
|-
 
|<code>getDuplicateKeyName</code>
 
|<code>getDuplicateKeyName</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>getIdentityValue</code>
 
|<code>getIdentityValue</code>
 +
|
 +
|x
 +
|
 +
|x
 +
|x
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>getMaxTime</code>
 
|<code>getMaxTime</code>
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>getMinTime</code>
 
|<code>getMinTime</code>
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>getTestSQL</code>
 
|<code>getTestSQL</code>
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
Line 148: Line 243:
 
|
 
|
 
|
 
|
 +
|
 +
|
 +
|
 +
|
 +
|x
 
|-
 
|-
 
|<code>isBatchSupported</code>
 
|<code>isBatchSupported</code>
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isBatchUpdateCountSupported</code>
 
|<code>isBatchUpdateCountSupported</code>
 +
|
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
Line 159: Line 269:
 
|<code>isBatchable</code>
 
|<code>isBatchable</code>
 
|
 
|
 +
|
 +
|
 +
|
 +
|
 +
|x
 
|
 
|
 
|-
 
|-
 
|<code>isDateRangeException</code>
 
|<code>isDateRangeException</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isDeadlockException</code>
 
|<code>isDeadlockException</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isDuplicateKeyException</code>
 
|<code>isDuplicateKeyException</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isLiteral</code>
 
|<code>isLiteral</code>
 +
|
 +
|
 +
|x
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isLockTimeoutException</code>
 
|<code>isLockTimeoutException</code>
 +
|x
 +
|
 +
|
 +
|
 +
|
 
|
 
|
 
|
 
|
 
|-
 
|-
 
|<code>isQueryTimeoutException</code>
 
|<code>isQueryTimeoutException</code>
 +
|x
 +
|
 
|
 
|
 
|
 
|
−
|-
 
−
|<code>isUnicode</code>
 
 
|
 
|
 
|
 
|
 +
|}
 +
 +
== Table 4 ==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
|-
 
|-
−
| colspan="3" |'''Override'''
+
|method
 +
|colspan="3" | parameter types
 
|-
 
|-
−
| <code>appendLiteral(StringBuffer buf, String sValue)</code>
 
−
|DONE
 
 
|
 
|
 +
| RelationalSchema
 +
| ResultSet
 +
| Column
 +
|-
 +
|<code>isUnicode</code>
 +
|x
 +
|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]

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Research_Notes_1/25/2011&oldid=56360"