🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: es.comp.lenguajes.java
Article #27423

JDBC y PostGres

#27423
From: lanza
Date: Sun, 20 Sep 1998 00:00
88 lines
3041 bytes
Hola a todos:

Tengo instalada en Linux RedHat 5.0 la versi�n de Postgres 6.3.2-4 con las JDBC
correspondientes.

El problema que tengo es que no s� la manera de acceder al SGBD a trav�s de
Java.

He estado mirando la documentaci�n que acompa�a pero no encuentro nada.

Muchas gracias por adelantado, y hasta otra.


la salida por pantalla es la siguinte:

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=postgresql.Driver,context=null,postgresql.Driver@80cb355]
DriverManager.getConnection("jdbc:postgresql:pruebas")
    trying
driver[className=postgresql.Driver,context=null,postgresql.Driver@80cb355]
-- listing properties --
password=
Protocol=postgresql
user=
PGDBNAME=pruebas
java.sql.SQLException: Connection failed: java.net.ConnectException: Connection
refused
	at postgresql.Connection.<init>(Connection.java:190)
	at postgresql.Driver.connect(Driver.java:87)
	at java.sql.DriverManager.getConnection(DriverManager.java:91)
	at java.sql.DriverManager.getConnection(DriverManager.java:134)
	at sql.main(sql.java:41)
getConnection failed: java.sql.SQLException: Connection failed:
java.net.ConnectException: Connection refused
java.sql.SQLException: Connection failed: java.net.ConnectException: Connection
refused
	at postgresql.Connection.<init>(Connection.java:190)
	at postgresql.Driver.connect(Driver.java:87)
	at java.sql.DriverManager.getConnection(DriverManager.java:91)
	at java.sql.DriverManager.getConnection(DriverManager.java:134)
	at sql.main(sql.java:41)

El Programa:

import java.io.*;
import java.sql.*;
import java.text.*;
import java.net.*;

public class sql {
  static Connection db;
  static Statement  st;
  
  static public void main(String args[]) throws Exception {
    String url="jdbc:postgresql:pruebas";
/* Tambi�n he probado con:
               "jdbc:postgresql://mi_servidor:5432/pruebas";
^*/

    DriverManager.setLogStream(System.err);

    Class.forName("postgresql.Driver");

    db = DriverManager.getConnection(url,"","");

/* Tambi�n he probado con: 
    db = DriverManager.getConnection(url,"root","");
    db = DriverManager.getConnection(url,"root","mi_contrase�a_unix");
    db = DriverManager.getConnection(url,"postgres","");
*/

    st = db.createStatement();

    st.close();
    db.close();
    
  } //Fin Main
}   //Fin Class

=========================================
***** ***** *     ***** ***** *   * ** **
  *   *   * *     ***     *   *   * * * *
  *   ***** ***** *****   *   ***** *   *

lanzaQUITAESTO@accesocero.es
=========================================
Technical Details
Message-ID: <3605332a.1470265@news.accesocero.es>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 1116f3,7fe4ab45d483b76c,start
X-Google-Attributes: gid1116f3,public
From: lanza@accesocero.es
Subject: JDBC y PostGres
Date: 1998/09/20
Message-ID: <3605332a.1470265@news.accesocero.es>
X-Deja-AN: 393025981
Organization: Telefonica Transmision de Datos
Newsgroups: es.comp.lenguajes.java