Difference between revisions of "NexJ Express Connecting to PostgreSQL"

From CDOT Wiki
Jump to: navigation, search
(→‎1- Setup the postgresql-connection)
Line 5: Line 5:
 
For testing the connection, the 'PostgreSQLAdapterTest.java' is being used.
 
For testing the connection, the 'PostgreSQLAdapterTest.java' is being used.
 
* [[PostgreSQL_Adapter-nexj/test-env/todo |TODOs]]
 
* [[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
 
* Done
 
: Installed the <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> and added it to the libraries in JDK
 
: 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 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
+
:: The driver is loaded from RelationalDatabaseFragment.java
 
: Metadata is loaded from the particular driver
 
: Metadata is loaded from the particular driver
 
::
 
::
Line 28: Line 34:
 
: Configured the work/ws/core/test/nexj/postgresql.connection
 
: Configured the work/ws/core/test/nexj/postgresql.connection
 
: Configured system.dstype
 
: Configured system.dstype
−
: Configured DatabaseTool.java  // This file calles SQLSchemaMangerFactory.java and creates the connection
+
: Configured DatabaseTools.java  // This file calles SQLSchemaMangerFactory.java and creates the connection
−
: Configured RelationalDatabase.java // Sets the default properties for the supported drivers
+
: Configured RelationalDatabase.java SQLRAConnectionFactory.java
−
: Configured RelationalDatabaseFragment.java // Sets the custom fragment properties for the supported drivers
 
 
: Configured Driver type and some other properties in JDBCInfo.java
 
: Configured Driver type and some other properties in JDBCInfo.java
−
: Configured : SQLSchemaManagerFactory.java
+
: Configured : SQLSchemaMangerFactory.java
  
 
=== 2- Create a PostgreSQL database through some scripts===
 
=== 2- Create a PostgreSQL database through some scripts===
−
: Through the process in postgresql_setup.sql:
+
: 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 ===
 
=== 3- Create the extended PostgreSQL source files ===

Revision as of 11:29, 1 December 2010

PostgreSQL Adapter for NexJ - Create Test Environment

1- Setup the postgresql-connection

For testing the connection, the 'PostgreSQLAdapterTest.java' is being used.

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 JDBC3 Postgresql Driver, Version 9.0-801 and added it to the libraries in JDK
The driver class which is being used for NexJ Express Model is: org.postgresql.xa.PGXADataSource
The driver is loaded from RelationalDatabaseFragment.java
Metadata is loaded from the particular driver 
   /* MySQLAdapterTest.java */
      try
      {
         s_metadata = loadMetadata(ADAPTER_NAME);
      }

   /* SQLDataTest.java */
   protected static Metadata loadMetadata(String sAdapter)
   {
      Properties props = SysUtil.getConfigProperties();  // sets DEFAULT_CONFIG_URL = '/' + NAMESPACE + "/default.config"
      props = new Properties(props);
      props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");  // sets the properties to postgresql.connection
Configured the work/ws/core/test/nexj/postgresql.connection
Configured system.dstype
Configured DatabaseTools.java // This file calles SQLSchemaMangerFactory.java and creates the connection
Configured RelationalDatabase.java SQLRAConnectionFactory.java
Configured Driver type and some other properties in JDBCInfo.java
Configured : SQLSchemaMangerFactory.java

2- Create a PostgreSQL database through some scripts

postgresql_setup.sql

3- Create the extended PostgreSQL source files

PostgreSQLAdapter.java
PostgreSQLSchemaManger.java

4- Create the extended PostgreSQL test files

PostgreSQLAdapterTest.java
PostgreSQLSchemaMangerTest.java
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=NexJ_Express_Connecting_to_PostgreSQL&oldid=51041"