Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Testing The Configuration

Start Postgres .
In and then in your portal development directory, issue the command:

Code Block
ant dbtest

If it works correct you should see something like

Code Block
TODO

Edit /uPortal/uportal-impl/src/main/resources/properties/db/dbloader.xml and verify that there is an entry just like the database version you displayed in the last step:

Code Block

  <db-type-mapping>
    <db-name>PostgreSQL</db-name>
    <db-version>7.4.5</db-version>
    <driver-name>PostgreSQL Native Driver</driver-name>
    <driver-version>PostgreSQL 7.4.5 JDBC3 with SSL (build 215)</driver-version>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
    <type><generic>LONGVARBINARY</generic><local>BYTEA</local></type>
    <type><generic>VARBINARY</generic><local>BYTEA</local></type>
    <type><generic>BLOB</generic><local>OID</local></type>
  </db-type-mapping>

If there is not an exact match, then add it.
Execute

Code Block
ant 

...

initportal

to build the database tables

...

Code Block
ant deploy

...

and copy files to your servlet container

Start your servlet container.

If you upgrade Postgres, you should replace postgresql.jar update the referenced JAR in uportal-impl/pom.xml and update entries in dbloader.xml. The jar file may
also be placed in the Tomcat common/lib directory.