Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"

From CDOT Wiki
Jump to: navigation, search
(Tasks)
 
(3 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
{{Admon/obsolete}}
 +
 
[[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]]
 
[[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]]
 
==Summary==
 
==Summary==
Line 28: Line 30:
 
| DONE
 
| DONE
 
|-
 
|-
|<code>appendInfixHint</code> <br/> PostgreSQL doesn't support HINTS [[ http://xzilla.net/blog/2011/Feb/Why-the-F%25-Doesnt-Postgres-Have-Hints!!.html ]]
+
|<code>appendInfixHint</code> <br/> PostgreSQL doesn't support HINTS [http://xzilla.net/blog/2011/Feb/Why-the-F%25-Doesnt-Postgres-Have-Hints!!.html ]
 
| N/A
 
| N/A
 
| N/A
 
| N/A

Latest revision as of 19:32, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

Summary

  • Extend SQLAdapter to support PostgreSQL.
  • SQLAdapter is used to manipulate data in existing schemas (DML)

Tasks

Task Status Test Status
Implement
appendIdentityColumn DONE DONE
appendIdentityPrefix DONE DONE
appendIdentitySuffix DONE DONE
appendIdentityValue DONE DONE
appendInfixHint
PostgreSQL doesn't support HINTS [1]
N/A N/A
appendLiteral DONE DONE
appendMatchStatement DONE DONE
appendNoRowsBlock
NOTE: Cannot use conditional statement outside
stored procedure
N/A N/A
appendNoRowsEnd
see note above
N/A N/A
appendNoRowsStart
see note above
N/A N/A
appendPrefixHint N/A N/A
appendStringLengthPrefix DONE DONE
appendSubstringPrefix DONE DONE
appendSuffixHint DONE DONE
appendTableHint N/A N/A
appendTypeConversion DONE DONE
bindIdentity DONE DONE
createSchemaManager DONE DONE
getDuplicateKeyName DONE DONE
getIdentityValue DONE DONE
getMaxTime DONE DONE
getMinTime DONE DONE
getTestSQL DONE DONE
indexNameMatches DONE DONE
isBatchSupported DONE DONE
isBatchUpdateCountSupported DONE DONE
isBatchable DONE DONE
isDateRangeException DONE DONE
isDeadlockException DONE ? DONE
isDuplicateKeyException DONE DONE
isLiteral DONE DONE
isLockTimeoutException DONE ? DONE
isQueryTimeoutException DONE DONE
isUnicode DONE DONE
Override
appendLiteral(StringBuffer buf, String sValue) DONE DONE

Resources

String Literals
Database Encoding
Error Codes