1,234
edits
Changes
no edit summary
{{Admon/obsolete}} [[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]]==Summary==
* Extend SQLAdapter to support PostgreSQL.<br/>
* SQLAdapter is used to manipulate data in existing schemas (DML)<br/>
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
|-
|<code>appendIdentityColumn</code>
|DONE|DONE
|-
|<code>appendIdentityPrefix</code>
|DONE|DONE
|-
|<code>appendIdentitySuffix</code>
|DONE|DONE
|-
|<code>appendIdentityValue</code>
|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 ]|N/A|N/A
|-
|<code>appendLiteral</code>
|DONE|DONE
|-
|a<code>ppendMatchStatement</code>|DONE |DONE
|-
|<code>appendNoRowsBlock</code><br/> NOTE: Cannot use conditional statement outside<br/> stored procedure|N/A|N/A
|-
|<code>appendNoRowsEnd</code><br/>see note above|N/A|N/A
|-
|<code>appendNoRowsStart</code><br/> see note above|N/A|N/A
|-
|<code>appendPrefixHint</code>
|N/A|N/A
|-
|<code>appendStringLengthPrefix</code>
|DONE|DONE
|-
|<code>appendSubstringPrefix</code>
|DONE|DONE
|-
|<code>appendSuffixHint</code>
|DONE|DONE
|-
|<code>appendTableHint</code>
|N/A|N/A
|-
|<code>appendTypeConversion</code>
|DONE|DONE
|-
|<code>bindIdentity</code>
|DONE|DONE
|-
|<code>createSchemaManager</code>
|DONE|DONE
|-
|<code>getDuplicateKeyName</code>
|DONE|DONE
|-
|<code>getIdentityValue</code>
|DONE|DONE
|-
|<code>getMaxTime</code>
|DONE|DONE
|-
|<code>getMinTime</code>
|DONE|DONE
|-
|<code>getTestSQL</code>
|DONE|DONE
|-
|<code>indexNameMatches</code>
|DONE|DONE
|-
|<code>isBatchSupported</code>
|DONE|DONE
|-
|<code>isBatchUpdateCountSupported</code>
|DONE|DONE
|-
|<code>isBatchable</code>
|DONE|DONE
|-
|<code>isDateRangeException</code>
|DONE|DONE
|-
|<code>isDeadlockException</code>
|DONE ?|DONE
|-
|<code>isDuplicateKeyException</code>
|DONE |DONE
|-
|<code>isLiteral</code>
|DONE|DONE
|-
|<code>isLockTimeoutException</code>
|DONE ?|DONE
|-
|<code>isQueryTimeoutException</code>
|DONE|DONE
|-
|<code>isUnicode</code>
|DONE|DONE
|-
| colspan="3" |'''Override'''
| <code>appendLiteral(StringBuffer buf, String sValue)</code>
|DONE
|DONE
|}
==Resources==
[http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html String Literals] <br>
[http://www.postgresql.org/docs/9.0/static/catalog-pg-database.html Database Encoding] <br>
[http://www.postgresql.org/docs/9.0/static/errcodes-appendix.html Error Codes] <br>