Unable to connect to database

Поиск
Список
Период
Сортировка
От Peter Rogers
Тема Unable to connect to database
Дата
Msg-id 3B7D7E00.D2638FD7@earthlink.net
обсуждение исходный текст
Ответы RE: Unable to connect to database
Список pgsql-jdbc
Please have mercy on this poor beginner!

I am totally new to both postgresql and jdbc, so I'm probably committing
some very basic error, but I am unable to make a connection to my
database via jdbc.  I am using postgresql 7.1.2 which seems to  be
running OK (under Suse Linux 7.1); at least I can run the sample
interactive scripts with pqsl.  I built and installed jdbc according to
the instructions in the readme file, and I am using Java 1.3.  I used
"createdb" to create my own database "petesdb" with username "progers".
However, when I run the small piece of code below, the driver gets
registered, but getConnection fails with a segmentation fault.



import java.sql.*;
import java.lang.reflect.*;
import java.io.*;
import java.util.*;

public class TestDb
{

   public static void main(String args[])
    {
        Connection db;  // The connection to the database
        Statement  st;  // Our statement to run queries with

        try
        {
          // This line outputs debug information to stderr
          DriverManager.setLogStream(System.err);

          Class.forName("org.postgresql.Driver");
          System.out.println("Db driver OK");

          // Connect to database
          String url = "jdbc:postgresql:petesdb";
          String usr = "progers";
          String pwd = "petesdb_pwd";
          System.out.println("Connecting to Database URL = " + url);
          db = DriverManager.getConnection(url, usr, pwd);
          System.out.println("Db connection OK");

        }
        catch(Exception e)
        {
          // your error handling code goes here
          System.out.println("Hey! no db driver or no db connection");
        }
    }
}

The console output is as follows:

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=org.postgresql.Driver,org.postgresql.Driver@4b222f]
Db driver OK
Connecting to Database URL = jdbc:postgresql:petesdb
DriverManager.getConnection("jdbc:postgresql:petesdb")
    trying
driver[className=org.postgresql.Driver,org.postgresql.Driver@4b222f]
Segmentation fault


My thanks for any help anyone can offer.

--Pete Rogers

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Rene Pijlman
Дата:
Сообщение: Re: postgresql ID
Следующее
От: Whitney Hunter
Дата:
Сообщение: RE: Unable to connect to database