Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group