How do I switch to an Oracle database from PostgreSQL for Focal Point?

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.
5.3, 5.4AnswerProduct versionPartner ContentInternal ContentCategoryReference ID

Historical Number

10726

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Focal Point
General Information

Software version:

Version Independent

Operating system(s):

Platform Independent

Reference #:

1323874

Modified date:

2011-01-28

Translate my page

Machine Translation

Content navigation