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.2for 0.6.2)
- 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 uselocalhost. - 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). - Create an file
resource/xplanner-custom.propertiesthat you will use to add the properties you override from their default values located inresouces/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.
- Add the oracle connection properties in it
resource/xplanner-custom.properties
- In xplanner.properties, comment out the mysql connection properties by adding a
#at the beginning of each line:resource/xplanner.properties - Run
ant install.db.schema - Configure email by setting the following properties
resource/xplanner-custom.properties
- Further customize xplanner following http://xplanner.org/customization.html
- Run
ant war - Deploy war by copying the xplanner.war to your application server webapps directory (in tomcat it is
<TOMCAT_HOMR>/webapps) - Start your application server (for tomcat it is
<TOMCAT_HOME>/bin/startup.bat>on windows or<TOMCAT_HOME>/bin/startus.sh>on unix) - Login to xplanner (if you are using default tomcat, the url to go to is http://localhost:8080/xplanner) as user
sysadminpasswordadmin
FAQ
Labels:
2 Comments
Hide/Show CommentsJul 13, 2005
Anonymous
regarding oracle and other non-mysql databases:
a small description on how to do changes in oracle-mapping-transform.xsl would be nice.
Mar 08, 2006
Anonymous
1. download and unzip the xplanner-0.7b4-war.zip file in a temp directory,
2. copy D:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar into jakarta-tomcat-5.0.30\webapps\xplanner\WEB-INF\lib\ folder
3. edit the xplanner-custom.properties for Oracle 10g connection info.
4. run the following SQL script to create the database tablespace, user, and access.
5. run xplanner-0.7b4-war\install.bat new
6. copy the xplanner-0.7b4-war\xplanner\ into jakarta-tomcat-5.0.30\webapps\xplanner\
7. start tomcat
8. open the url (http://localhost:8080/xplanner) in the browser to test the application. please find the username/password in the readme file.
* * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** **
The following script is for a fresh installation NOT for upgrade. The username, password must be same as in xplanner-custom.properties.
Open SQLPLUS cli or SQuirrel client to execute this script after edit, cut and paste.
then run install.bat new
CREATE SMALLFILE TABLESPACE "XPLANNER"
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\XPLANNER.DBF'
SIZE 32M REUSE
AUTOEXTEND ON NEXT 32768K
MAXSIZE 2048M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE USER "XPLANNER"
PROFILE "DEFAULT"
IDENTIFIED BY "xp"
DEFAULT TABLESPACE "XPLANNER"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT UNLIMITED TABLESPACE TO "XPLANNER"
GRANT "AUTHENTICATEDUSER" TO "XPLANNER"
GRANT "DBA" TO "XPLANNER"