Project

General

Profile

Actions

Bug #1238

closed

postgresql JDBC config problem in metacat

Added by David Kaplan over 20 years ago. Updated over 18 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
metacat
Target version:
Start date:
12/11/2003
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1238

Description

I was looking at the configuration information for using postgresql in metacat
and I think that the current JDBC setup in build.properties and build.xml needs
modification for newer versions of postgresql. For newer versions, the JDBC
driver (that comes in a standard package) looks like:

/usr/share/pgsql/pg73jdbc3.jar

where 73 refers to the version and the 3 relates to the java version
(unfortunately, the 3 does not imply jre-1.3). The driver that comes with
metacat will not work with these versions of postgresql. I recommend dropping
this driver from the distribution as it could create more problems than solutions.

The easiest fix for this is to change (in build.xml):

<property name="jdbc" value="lib/jdbc7.1-1.2.jar" />

to

<property name="jdbc" value="${jdbc-base}"/>

and put in build.properties:

  1. Location of postgresql JDBC driver
    #jdbc-base=/usr/share/pgsql/pg73jdbc3.jar

This has the disadvantage of having jdbc-base mean slightly different things for
the different backends.

I also noticed that in build.xml you have jdbc-base in some places and jdbc_base
in others.

Actions

Also available in: Atom PDF