Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/schema-test

1 byte added, 10:46, 10 December 2010
no edit summary
</source>
: After activating the connection, the database is locked.
 === Modifying Syntax ===* '''''PostgreSQLSchemaManager.java''''': <code> CREATE TABLE test.xxx </code>:: data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.:: In MySQL, the storage engine is set to a transactional safe engine such as [http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#MySQL:InnoDB InnoDB], whereas PostgreSQL has a single built in engine. So, implementation of <code> appendTableSuffix() </code> in PostgreSQLManager.java was removed
::
<source lang=java>
)ENGINE=InnoDB CHARACTER SET=utf8; // PostgreSQL version with no ENGINE and CHARACTER
</source>
 
=== Modifying Syntax ===
* '''''PostgreSQLSchemaManager.java'''''
: <code> CREATE TABLE test.xxx </code>
:: data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.
:<code> crateTextTable </code>
::The implementation in <code> crateTextTable </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).
1
edit