Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter

309 bytes added, 12:48, 7 December 2010
Current Status
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Dec 2010
|-
|
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts Database 'test' is created in NexJ Express codePostgre.* sample table 'mutex' is created for testing the connection properties. * Going through NexJ MySQL databaseNo need for SET SQL mode in Postgre* Learning about Differences between PostgreSQL and MySQLCreating tables in process - data mapping needs to be done for BINARY primary keys for all the tables.
|}
|
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
* Going through NexJ MySQL databaseSQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes* Learning about Differences between Proper PostgreSQL Driver is installed.* Postgre package url for XADataSource is added to the related files.* cofig and MySQLconnection files are modified based on Postgre properties* Application is now connected to the Postgre database.
|}
1
edit