Open main menu

CDOT Wiki β

Changes

NexJ Express Connecting to PostgreSQL

155 bytes added, 11:08, 1 December 2010
1- Setup the postgresql-connection
: Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443
* Done
: Configure Installed the work<code> JDBC3 Postgresql Driver, Version 9.0-801 </ws/core/test/nexj/postgresql.connection: Load code> and added it to the driver from RelationalDatabaseFragment.javalibraries in JDK:: The package that driver class which is being importedused for NexJ Express Model is: <code> org.postgresql.xa.PGXADataSource </code>: Load metadata : The driver is loaded from RelationalDatabaseFragment.java: Metadata is loaded from the particular driver
::
<source lang=java>
props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections"); // sets the properties to postgresql.connection
</source>
 : Configured the work/ws/core/test/nexj/postgresql.connection: Configure Configured system.dstype: Configure Configured DatabaseTools.java // This file calles SQLSchemaMangerFactory.java and creates the connection: Configure Configured RelationalDatabase.java SQLRAConnectionFactory.java: Configure Configured Driver type and some other properties in JDBCInfo.java: Configure Configured : SQLSchemaMangerFactory.java
=== 2- Create a PostgreSQL database through some scripts===
1
edit