Article View: es.comp.lenguajes.java
Article #27423JDBC y PostGres
From: lanza
Date: Sun, 20 Sep 1998 00:00
Date: Sun, 20 Sep 1998 00:00
88 lines
3041 bytes
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-mailShow 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