Update to http://xplanner.org/install.html

• copy the jdbc driver into a new directory under xplanner/lib/jdbc-driver in 0.6.2 xplanner/lib/webapp/jdbc-driver in 0.6.3
• no need to create a build.properties

Oracle installation.

Dear Oracle xplanner users. I am calling upon your generosity to update this page to make it as accurate as possible

In following steps:

• Replace the <xxx> with your own values.
• All file paths are relative to the root of the distribution zip file (usually xplanner_x.x.x, xplanner_0.6.2 for 0.6.2)
  
  

1. Create a database <dbname> on the oracle server. This server will be named <server> for the rest of the instructions. If xplanner and oracle runs on the same server you can just use localhost.
2. Create an oracle user with name <user> and password <password>. Grant <user> all access rights to <dbname> (schema and data manipulation is needed during install).
3. Create an file resource/xplanner-custom.properties that you will use to add the properties you override from their default values located in resouces/xplanner.properties.

   Doing it this way instead of just copying the xplanner.properties entirely usually makes upgrading easier since you won't have to find what properties you modified.

4. Add the oracle connection properties in it
   resource/xplanner-custom.properties

   # Oracle
   hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerOracleDialect
   hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
   hibernate.connection.url=jdbc:oracle:thin:@<server>:1521:<dbname>
   hibernate.connection.username=<user>
   hibernate.connection.password=<password>
   xplanner.hibernate.mappingtransform=oracle-mapping-transform.xsl

5. In xplanner.properties, comment out the mysql connection properties by adding a # at the beginning of each line:
   resource/xplanner.properties

   # Hibernate MySQL Configuration
   #hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
   #hibernate.connection.driver_class=com.mysql.jdbc.Driver
   #hibernate.connection.url=jdbc:mysql://localhost/xplanner?autoReconnect=true
   #hibernate.connection.username=xplanner
   #hibernate.connection.password=

6. Run ant install.db.schema
7. Configure email by setting the following properties
   resource/xplanner-custom.properties

   xplanner.mail.smtp.host=localhost        # enter your SMTP host
   xplanner.mail.from=xplanner@example.org  # enter the email sender for XPlanner messages

8. Further customize xplanner following http://xplanner.org/customization.html
9. Run ant war
10. Deploy war by copying the xplanner.war to your application server webapps directory (in tomcat it is <TOMCAT_HOMR>/webapps)
11. Start your application server (for tomcat it is <TOMCAT_HOME>/bin/startup.bat> on windows or <TOMCAT_HOME>/bin/startus.sh> on unix)
12. Login to xplanner (if you are using default tomcat, the url to go to is http://localhost:8080/xplanner) as user sysadmin password admin

FAQ

XPlanner installation FAQ