Technote (FAQ)
Question
How do I switch to an Oracle database from PostgreSQL for Focal Point?
Answer
Following are the steps to point you current Focal Point installation to an Oracle database:
- Stop Apache Tomcat server for Focal Point
- Browse to <TOMCAT HOME>\conf\Catalina\localhost
- Edit fp.xml in a text editor
-
Change the following Parameter values:
driverClassName: From "org.postgresql.Driver" to "oracle.jdbc.OracleDriver"
url: from "jdbc:postgresql://servername:5432/focalpoint" to
"jdbc:oracle:thin:@<Hostname of Oracle Server>:<Listener Port>:<Database Name>"
Ex: jdbc:oracle:thin:@ORA_Server:1521:Focalpoint
username: from "postgres" to "system"
password = "<System User Password>"
jdbc.username: From "postgres" to "system"
database.className: From "se.focalpoint.tools.database.PostgreSQL"
to "se.focalpoint.tools.database.Oracle"
-
Copy jdbc drivers (ojdbc14.jar and ojdbc14_g.jar) from <ORACLE HOME>\db_1\jdbc\lib to <TOMCAT HOME>\common\lib
- Delete fp folder from <Apache Tomcat installation Directory>\webapps
- Start Apache Tomcat Server for Focal Point.
Historical Number
10726
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.