1
edit
Changes
no edit summary
For testing the connection, the 'PostgreSQLAdapterTest.java' is being used.
* [[PostgreSQL_Adapter-nexj/test-env/todo |TODOs]]
: Create and Configure the work/ws/core/test/nexj/postgresql.config
:: for now, the contents of default.config is changed to postgresql specifications instead of mysql
: walk-through lines from 214-218 in SQLManagementConnectionFactory.java
: Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database
: Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122
: Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443
* Done
: Installed the <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> and added it to the libraries in JDK
:: The driver class which is being used for NexJ Express Model is: <code> org.postgresql.xa.PGXADataSource </code>
:: The driver is loaded from RelationalDatabaseFragment.java and RelationalDatabase.java
: Metadata is loaded from the particular driver
::
: Configured the work/ws/core/test/nexj/postgresql.connection
: Configured system.dstype
: Configured DatabaseToolDatabaseTools.java // This file calles SQLSchemaMangerFactory.java and creates the connection: Configured RelationalDatabase.java // Sets the default properties for the supported drivers: Configured RelationalDatabaseFragmentSQLRAConnectionFactory.java // Sets the custom fragment properties for the supported drivers
: Configured Driver type and some other properties in JDBCInfo.java
: Configured : SQLSchemaManagerFactorySQLSchemaMangerFactory.java
=== 2- Create a PostgreSQL database through some scripts===
: Through the process in postgresql_setup.sql::: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test </code>:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>:: Login to the database 'test' with username 'test': <code> psql -U test test </code>:: Create a <code> Schema </code> called 'test' inside the database 'test' with particular owner 'test': <code> CREATE SCHEMA test AUTHORIZATION test;</code>:: 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- Create the extended PostgreSQL source files ===