Changes

Jump to: navigation, search

NexJ Express Connecting to PostgreSQL

190 bytes added, 13:15, 2 December 2010
1- Setup the postgresql-connection
</source>
: After activating the connection, the database is locked.
: 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, changes needed to be done to this script:
::
<source lang=java>
/* nexj/core/persistence/sql/etc/postgresql_createcreate table test.sql */Account( id binary(16) not null, contactId binary(16) not null, account Type varchar(16) character set sql_mode = concat(@@sql_modeutf8 not null, 'funds double null,ANSI_QUOTES' constraint Account_PK primary key(id));
</source>
1
edit

Navigation menu