Bug #1238


postgresql JDBC config problem in metacat

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

Target version:
Start date:
Due date:
% Done:


Estimated time:


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


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" />


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

and put in

  1. Location of postgresql JDBC driver

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 #1

Updated by Matt Jones about 20 years ago

Interestingly, I have a current version of metacat running using the original
jdbc .jar file that is checked into lib. I have tested insert, update, and
delete operations through metacat using this jar without any problems. I have
the follwoing properties set in the

  1. Select the database to use for metadata storage
  2. Valid values are oracle, postgresql, sqlserver
  1. The JDBC connection string used to connect to the database
  1. The base directory for locating JDBC jar files (not needed for postgresql)

It still might be a good idea to remove the jar file, but so far I have found it
convenient. The changes you suggest change the meaning of the 'jdbc-base"
property, which for other databases represents the directory in which the jdbc
jar file(s) can be found. If we were to change it, I would want to use the
properties consistently across the databases we support (oracle, postgres, mssql

What did you try that did not work for you? Are you sure you ran postmaster
with -i and enabled tcp/ip access, and had the right jdbc connect string when
testing it? What OS was it failing on? Thanks for the further info.

Actions #2

Updated by David Kaplan about 20 years ago

What version of postgresql are you running? Generally, the drivers are forward
compatible as far as java is concerned - i.e. they will work with java-1.4 if
they work with 1.1. But I don't think the older driver will work with newer
versions of postgresql. It didn't appear to work for me, but then again I
didn't fuss much. In any case, perhaps the solution would be a new parameter
jdbc-jar that would only be used by postgresql.

Actions #3

Updated by Matt Jones about 20 years ago

I am running postgresql 7.3, the most recent version for redhat 9 as of two days
ago. From what I can see the old jdbc jar file works fine with the new version
of postgres, but I agree we should look into this. One of the initial reasons
for checking it in was we were trying to make a standalone version of metacat
that had everything needed for it to run. We might have other ways of
accomplishing that now that we are closer to a binary installer capability.

Actions #4

Updated by Matt Jones over 18 years ago

Upgraded the driver to the Postgresql version 8 JDBC driver. Tested against
postgres 7.4 and still seems to work. Marking as fixed for the 1.6 metacat release.

Actions #5

Updated by Redmine Admin almost 11 years ago

Original Bugzilla ID was 1238


Also available in: Atom PDF