1
edit
Changes
→Debugging a Non-Default SQL Adapter
==== Environment/Connection Files ====
These files are located in the ''test'' source folder in the package <code>nexj</code>
#DefaultEdit the files: '''default.config, filestorage.connections, filestoragefragment.connections'''##In the <code>DataSourceConnections</code> elemement##Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>##Change all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections<br>For the PostgreSQL Adapter, the following configuration is used<source lang="xml"><DataSourceConnections> <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="DefaultRelationalDatabase" database="test" host="localhost" password="test" port="5432" unicode="true" user="test"/> <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test" host="localhost" password="test" port="5432" unicode="true" user="test"/> ... </DataSourceConnections></source>#*Create a connections file for the new adapter##Create the file '''[DbName].connections'''##Copy and paste the contents of '''mysql.connections''' into the new connections file##In the <code>DataSourceConnections</code> elemement#*#Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>#*Edit #Change all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections
<br>For the PostgreSQL Adapter, the following configuration is used
<source lang="xml">
<RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
host="localhost" password="test" port="5432" unicode="true" user="test"/>
</DataSourceConnections>
</source>
==== SQL Scripts ====
==== Unit Test Files ====