Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter Project - Extending SQLAdapter

1,586 bytes added, 20:32, 26 January 2014
no edit summary
[[category: NexJ Express PostgreSQL]]{{Admon/obsolete}}
Task [[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/>==Tasks==
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
| colspan="3" |'''Implement'''
|-
|<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
|-
|appendMatchStatementa<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>