Thread

1. Question about jdbc

   Natali Kolker <natali@u.washington.edu> — 1998-06-12T16:52:25Z

   Hi,
   
   
   I compiled JDBC  sources ,  that comes with version  6.3 .
   
   When I  am trying to connect to  data base ,
   
   "DriverManager.getConnection("jdbc:postgresql://haver:5432/natali",
   "natali", "Elina);"
   I got a response:
   
   
   >
   > java.sql.SQLException: User authentication failed
   >         at java.lang.Throwable.<init>(Compiled Code)
   >         at java.lang.Exception.<init>(Compiled Code)
   >         at java.sql.SQLException.<init>(Compiled Code)
   >         at postgresql.Connection.<init>(Compiled Code)
   >         at postgresql.Driver.connect(Compiled Code)
   >         at java.sql.DriverManager.getConnection(Compiled Code)
   >         at java.sql.DriverManager.getConnection(Compiled Code)
   >         at db.init_database(Compiled Code)
   >         at db.main(Compiled Code)
   >
   My jdbc drivers in dir $CLASSPATH/postgresql,
   I created my database with command:
   createdb -u natali
   Username : natali,
   Password: Elina
   
   In perl   I write : $conn = Pg::connectdb("dbname = natali");,
   and I have connection.
   
   If somebody can help me , with my  " authentification" problem , I would
   really  appriciate it.
   
   Natali Kolker
   --
   
   --------------------------------------------------------------------
   Natali Kolker
   Dept of Molecular Biotechnology, Box 357730   Tel: +1-206-685-7334
   University of Washington School of Medicine   Fax: +1-206-685-7301
   Seattle, WA 98195-7730, USA                   natali@u.washington.edu
   
   
   
   

2. Re: [GENERAL] Question about jdbc

   Peter Mount <pgsqlgen@retep.org.uk> — 1998-06-12T17:49:04Z

   On Fri, 12 Jun 1998, Natali Kolker wrote:
   
   > I compiled JDBC  sources ,  that comes with version  6.3 .
   
   If possible, upgrade to 6.3.2, as it has a more fuller JDBC
   implementation, and fewer bugs.
   
   > When I  am trying to connect to  data base ,
   > 
   > "DriverManager.getConnection("jdbc:postgresql://haver:5432/natali",
   > "natali", "Elina);"
   > I got a response:
   > >
   > > java.sql.SQLException: User authentication failed
   
   What do you have set in your pg_hba.conf file?
   
   > My jdbc drivers in dir $CLASSPATH/postgresql,
   > I created my database with command:
   > createdb -u natali
   > Username : natali,
   > Password: Elina
   > 
   > In perl   I write : $conn = Pg::connectdb("dbname = natali");,
   > and I have connection.
   > 
   > If somebody can help me , with my  " authentification" problem , I would
   > really  appriciate it.
   
   JDBC only works using TCP/IP, but (someone correct me if I'm wrong), the
   Perl interface can use Unix domain sockets, so if you have a different
   setting in pg_hba.conf, it can cause the fact that perl can connect, but
   JDBC not.
   
   Also, if you defined pg_hba.conf to use password or crypt authentication,
   ensure you have defined the user in the database, AND a password. A blank
   password doesn't work.
   
   Postgresql-JDBC FAQ: http://www.retep.org.uk/postgres
   
   -- 
   Peter T Mount peter@retep.org.uk or petermount@earthling.net
   Main Homepage: http://www.retep.org.uk
   ************ Someday I may rebuild this signature completely ;-) ************
   Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk