Thread: Driver Information-PostgreSQL 8

Driver Information-PostgreSQL 8

From

"Julie Cottin"

Date:

08 January 2005, 00:01:50

I am hoping someone can answer this question, I have search the web and can not find the information. I am trying to connect uPortal (http://uportal.org) to PostgreSQL 8.0.0-RC3 on Windows XP. There are four areas that refer to the PostgreSQL drivers and I am stumped on the answer, nothing seems to be working.

I am running JDK version: J2SDK 1.4.2_06 so I copied pg801.308.jdbc3.jar into the uPortal_2.4.1 /lib directory

What I am missing is the name of the driver(s) I should be referencing.

I did get MySQL to connect and load---- logging in from the local was a problem. Anyway, in MySQL it needed two different drivers reference. The jdbc .jar driver located in the /lib was referenced in the build.properties. A second driver in the lib/org/... called Driver.sql was referenced in dbloader.xml, rdbm.properties, and PersonalDir.xml. Is there a second driver I should be aware of for PostgreSQL and what is the correct referencing... the uPortal files have the following code:

from the rdbm.properties I tried- but I don't see any driver under /lib/org or any other folder:

##### PostgreSQL - example
jdbcDriver=org.postgresql.Driver
jdbcUrl=jdbc:postgresql://localhost:5432
jdbcUser=uportal
jdbcPassword=uportal

from the file: dbloader.xml I tried:

<db-type-mapping>
    <db-name>PostgreSQL</db-name>
    <db-version>8.0.0RC3</db-version>
    <driver-name>PostgreSQL Native Driver</driver-name>
    <driver-version>8.0.b1 JDBC3</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>INTEGER</generic><local>integer</local></type>
</db-type-mapping>

from the PersonDir I tried:

     <driver>org.postgresql.Driver</driver>
        <url>jdbc:postgresql://localhost:5432</url>
        <logonid>uportal</logonid>
        <logonpassword>uportal</logonpassword>
        <uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST,
FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?></uidquery>

and from the build.properties (which copies the files from the uPortal site to the TomCat uportal directory I referred to the .jar driver:

jdbcDriver.jar=${lib.path}/pg80b1.308.jdbc3.jar

Any light you can shed on this would be really helpful. I have spent hours trying to resolve this and I am at wits end.

Julie Cottin

Re: Driver Information-PostgreSQL 8

From

Kris Jurka

Date:

08 January 2005, 00:58:06


On Fri, 7 Jan 2005, Julie Cottin wrote:

> jdbcUrl=jdbc:postgresql://localhost:5432

I don't know anything about uportal, but postgresql urls usually specify a
database:

jdbc:postgresql://localhost:5432/mydb

Kris Jurka