Changes

Jump to: navigation, search

NexJ Express Connecting to PostgreSQL

507 bytes added, 21:38, 9 December 2010
2- Create a PostgreSQL database through some scripts
:: Create a <code>table</code> called 'Mutex' with primary key: <code> CREATE TABLE test.Mutex(id INT PRIMARY KEY); </code>
:: Insert a value into the primary key: <code> INSERT INTO test.Mutex(id) VALUES (1); </code>
 
 
== 3- Creating Schema ==
 
: <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> in
:: The implementation in <code> CREATE INDEX test.xxx </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).
: <code> CREATE Trigger test.xxx // if it's needed for PostgreSQL as well as MySQL</code>
1
edit

Navigation menu