Difference between revisions of "Research Findings - PostgreSQLAdapter"

From CDOT Wiki
Jump to: navigation, search
(Work of Grace Batumbya and Anastasia Semionova)
(Work of Grace Batumbya and Anastasia Semionova)
Line 1: Line 1:
  
 
== Work of Grace Batumbya and Anastasia Semionova ==
 
== Work of Grace Batumbya and Anastasia Semionova ==
* the timeout feature is implemented by the MySQL JDBC driver, but NOT by PostgreSQL
+
* The timeout feature is implemented by the MySQL JDBC driver, but NOT by PostgreSQL.
* CLOB is supported by MySQL, but NOT by PostgreSQL
+
* CLOB is supported by MySQL, but NOT by PostgreSQL.
* the records are ordered by MySQL, but NOT by PostgreSQL
+
** problem solved with feedback from NexJ
 +
* The records are ordered by MySQL, but NOT by PostgreSQL.
 +
** problem solved with feedback from NexJ
 
* [[Default orderBy research 2/17/2011]] (NULL values are organized differently by PostgreSQL.)
 
* [[Default orderBy research 2/17/2011]] (NULL values are organized differently by PostgreSQL.)
 
* [[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]
 
* [[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]

Revision as of 15:12, 26 March 2011

Work of Grace Batumbya and Anastasia Semionova

  • The timeout feature is implemented by the MySQL JDBC driver, but NOT by PostgreSQL.
  • CLOB is supported by MySQL, but NOT by PostgreSQL.
    • problem solved with feedback from NexJ
  • The records are ordered by MySQL, but NOT by PostgreSQL.
    • problem solved with feedback from NexJ
  • Default orderBy research 2/17/2011 (NULL values are organized differently by PostgreSQL.)
  • Unit Testing for non Default SQL Adapter

Work of Grace Batumbya and Minoo Ziaei