DevQuickStart_Eclipse

• Introduction
• Details
  • 1. Check out the projects
  • 2. Edit the settings
  • Edit properties file carbones_local.properties
  • Edit web.xml

Introduction

How to get started developing the CARBONES web application in Eclipse

Details

1. Check out the projects

In Eclipse SVN Repository perspective, add a repository. Use the URL displayed on the Source tab of the Google Code website, removing "/trunk" from the end of the URL.

In the SVN repositories view, expand the trunk node and select the CarbonesConfig project. Right click, and choose "Check out". You should check out as a project in the workspace.

In the SVN repositories view, expand the trunk node and select the Carbones project. Right click, and choose "Check out". You should check out as a project in the workspace.

Hint Eclipse will probably run its JavaScript validator against all the JavaScript in the project. You might like to cancel this, as it is very time consuming.

2. Edit the settings

Edit properties file carbones_local.properties

Edit carbones_local.properties. The username, password and database name should match those used to create your local PostGreSQL database

/Carbones/external_config_files/carbones_local.properties

Property
Typical value
Notes

carbones.jdbc.username
postgres
PostGreSQL username. Default PostGreSQL installation creates a "postgres" user with password "postgres"

carbones.jdbc.password
postgres
PostGreSQL password.

carbones.jdbc.url
jdbc:postgresql://localhost:5432/carbones_graph
Final part of the URL is the database name (recommend carbones_graph). You may also need to change the port if you chose a different port when installing PostGreSQL.

TIMESERIES_SQL_STRING
select * from linegraph ( ? ,?,?,?,?,?)
You may need to change the name of the stored procedure. linegraph is defined in the SQL stored on P:\ NB there is no underscore in linegraph!

TIMESERIES_MULTIREGION_SQL_STRING
select <<regions>> from linegraph_multiregion ( ? ,?,?,<<regionValues>>,?,?) As (<<regionTypes>>)
You should not need to change the name of the stored procedure. linegraph_multiregion is defined in the SQL stored on P:\

The procedure linegraph_multiregion was added to the SQL on 11 Aug 2011. It is also available at Q:\CRs\Utilities\CARBONES_F862\Website\CR0004 Change CSV to show region data in different columns\ChangedFilesAfterReview\linegraph_multiregion.txt

Edit web.xml

Right-click the carbones_local.properties file and copy the location onto the clipboard.

Now edit the file /Carbones/WebContent/WEB-INF/web.xml and paste the location into the parameter node externalConfigurationFilesLocation

• Change backslashes to forward slashes
• Enter the directory location only (delete the filename)

For example

    <context-param>
        <description>Absolute path of the directory containing the Carbones configuration files (use forward slashes eg. C:/external_config_files)</description>
        <param-name>externalConfigurationFilesLocation</param-name>
        <param-value>G:/Java/CARBONESWeb/Carbones/external_config_files</param-value>
    </context-param>