Обсуждение: PGSQL Connection

Hi,
I have this problem:
I'm developing an application with IBM Visual Age for Java 4.0 and I use PostgreSQL 7.2.3-5.73 on RedHat 7.3.
When I'm getting connection with the driver

Class.forName("org.postgresql.Driver");
dbName = "jdbc:postgresql://mypgsqlhost/mypgsqldb";
con_pgsql = DriverManager.getConnection(dbName, "mypgsqluser", "mypgsqlpassword");

I don't have any exception if I specify a bad password!!!
Why?

Regards

Vincenzo Angelone
System Analyst
tel. 08623490207
fax.08623490240
e-mail: v.angelone@info92.it
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
This message and any attachments are intended only for the person or entity to which they are addressed and are strictly confidential.
Any use not in accord with its purpose, any dissemination or misuse, either whole or partial, is prohibited.
If you receive this mail in error, please contact the sender and delete the material from any computers.
INFO92 does not accept liability for corruption, interception or amendment, if any, or the consequences thereof.
http://www.info92.it
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

What exception are you expecting?

Dave
On Fri, 2003-05-23 at 10:18, Vincenzo Angelone wrote:
> Hi,
> I have this problem:
> I'm developing an application with IBM Visual Age for Java 4.0 and I
> use PostgreSQL 7.2.3-5.73 on RedHat 7.3.
> When I'm getting connection with the driver
>
> Class.forName("org.postgresql.Driver");
> dbName = "jdbc:postgresql://mypgsqlhost/mypgsqldb";
> con_pgsql = DriverManager.getConnection(dbName, "mypgsqluser",
> "mypgsqlpassword");
>
> I don't have any exception if I specify a bad password!!!
> Why?
>
> Regards
>
>
>
> Vincenzo Angelone
> System Analyst
> tel. 08623490207
> fax.08623490240
> e-mail: v.angelone@info92.it
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
> This message and any attachments are intended only for the person or
> entity to which they are addressed and are strictly confidential.
> Any use not in accord with its purpose, any dissemination or misuse,
> either whole or partial, is prohibited.
> If you receive this mail in error, please contact the sender and
> delete the material from any computers.
> INFO92 does not accept liability for corruption, interception or
> amendment, if any, or the consequences thereof.
> http://www.info92.it
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> ______________________________________________________________________
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.483 / Virus Database: 279 - Release Date: 19/05/2003
>
> ______________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>

Vincenzo,

How have you defined authentication in pg_hba.conf?  If the mode is
trust, then no user or password authentication is done.

thanks,
--Barry


Vincenzo Angelone wrote:
> Hi,
> I have this problem:
> I'm developing an application with IBM Visual Age for Java 4.0 and I use
> PostgreSQL 7.2.3-5.73 on RedHat 7.3.
> When I'm getting connection with the driver
>
> Class.forName("org.postgresql.Driver");
> dbName = "jdbc:postgresql://mypgsqlhost/mypgsqldb";
> con_pgsql = DriverManager.getConnection(dbName, "mypgsqluser",
> "mypgsqlpassword");
>
> I don't have any exception if I specify a bad password!!!
> Why?
>
> Regards
>
> Vincenzo Angelone
> System Analyst
> tel. 08623490207
> fax.08623490240
> e-mail: v.angelone@info92.it
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
> This message and any attachments are intended only for the person or
> entity to which they are addressed and are strictly confidential.
> Any use not in accord with its purpose, any dissemination or misuse,
> either whole or partial, is prohibited.
> If you receive this mail in error, please contact the sender and delete
> the material from any computers.
> INFO92 does not accept liability for corruption, interception or
> amendment, if any, or the consequences thereof.
> _http://www.info92.it <http://www.info92.it/>_
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.483 / Virus Database: 279 - Release Date: 19/05/2003
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org