From: | "Julie Cottin" <julie(dot)cottin(at)wmich(dot)edu> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Driver Information Please |
Date: | 2005-01-07 18:41:20 |
Message-ID: | 00ae01c4f4e8$7b1573d0$cfddfea9@TOSHIBAJULIE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-01-07 19:45:41 | Re: count(*) index |
Previous Message | Tomka Gergely | 2005-01-07 18:22:56 | count(*) index |