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