Not having used postgreSQL with JDBC yet, I would guess that the
properties you are passing to create a DB Connection did not include
the user property. This may be the username of the person running the
server or something similar.
If you are using a property file, a line like this might do:
user=yui
Otherwise, you could add a line to your program:
props.put("user", "yui");
These properties are used in the DriverManager.getConnection() method.
I usually also store the server URL in these properties, and do
something like this:
con = DriverManager.getConnection(
props.getProperty("server"), props);
-walter
From: Hiro <[EMAIL PROTECTED]>
Subject: JSP does not connect postgresql with jdbc
Date: Tue, 30 Mar 2004 07:28:07 +0900
> HI!
>
> I am using JSP through JDBC with postgreSQL. But I can not connect
> postgreSQL with JDBC. So I got a error message. The
> message is "org.postgresql.util.PSQLException: The user property is
> missing. It is mandatory. "
>
> Please give me a advice or help.
>
>
> postgresql.jar and postgresql-examples.jar are generated by ANT.
>
>
>
>
> The evironment is:
> OS : Redhat8
> Kernel : 2.4.18-14
> Tomcat : tomcat-5.0.18
> PostgreSQL : postgresql-7.4
> ANT : apache-ant-1.6.1
> CLASSPATH=.:/usr/local/pgsql/share/java/postgresql.jar:/usr/local/pgsql/share/java/postgresql-examples.jar
> java : j2sdk1.4.2_03
>
> Regards,
> hiro
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]