org.postgresql.util.PSQLException: The user property is missing. It is mandatory.

From: Vic Ross <vross(at)fit(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: org.postgresql.util.PSQLException: The user property is missing. It is mandatory.
Date: 2011-07-22 11:01:25
Message-ID: 4E295885.10107@fit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am trying to transition my JSP site to a commercial server (postgresql version 8.1.23),
but every time I try to access the DB using JSP/JSTL I get the following error.

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid:
"org.postgresql.util.PSQLException: The user property is missing. It is mandatory."

The server set up: as per the commercial site
Resource name="jdbc/DBNAME" auth="Container" type="javax.sql.DataSource"
username="UNAME" password="PASS"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost/DBNAME"
maxActive="10" maxIdle="1"

The jsp page giving the error is:
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<sql:setDataSource var="ds" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/DBNAME?user=UNAME&password=PASS" user="UNAME"
password="PASS"/>
<sql:query var="cdate" dataSource="${ds}" sql="SELECT CURRENT_DATE AS date" />

Thank you for any help you might be able to provide!

V/R

Victor Ross
mako-shark(at)pacific-ocean(dot)com

Browse pgsql-novice by date

  From Date Subject
Next Message THOMPSON, JARED (ATTBAPCO) 2011-07-22 14:08:14 Unknown character on copy
Previous Message Greg Sabino Mullane 2011-07-21 17:39:09 Re: Datetime stored in bigint