From: | Nahum Castro <nahumcastro(at)gmail(dot)com> |
---|---|
To: | "sandrigo(dot)lezcano(at)gmail(dot)com" <sandrigo(dot)lezcano(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: string de conexao em JAVA |
Date: | 2005-03-01 18:59:11 |
Message-ID: | 714bb51a05030110592ffb47e3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hola pedes hacer la conexión como sigue.
primero das de alta el driver
Class.forName("org.postgresql.Driver");
para conectarte usas
String url = "jdbc:postgresql://localhost/test";
Properties props = new Properties();
props.setProperty("user","fred");
props.setProperty("password","secret");
props.setProperty("ssl","true");
Connection conn = DriverManager.getConnection(url, props);
String url = "jdbc:postgresql://localhost/test?user=fred&password=secret&ssl=true";
Connection conn = DriverManager.getConnection(url);
Saludos y espero que me entiendas por que no se portuges.
On Tue, 1 Mar 2005 08:43:05 -0300, sandrigo(dot)lezcano(at)gmail(dot)com
<sandrigo(dot)lezcano(at)gmail(dot)com> wrote:
> No Visual FoxPro pode-se usar uma string de conexao tipo:
> SEM usar DSN.
>
> pgsqlStringConnec = ;
> 'DRIVER={PostgreSQL};DATABASE=template1;SERVER=localhost;'+;
> 'PORT=5432;UID=postgres;PWD=dbtest;'+;
> 'a06=;a07=100;a08=4069;b0=254;b1=8190;bi=0;c2=dd_;;cx=1a403ab'
>
> STORE SQLSTRINGCONNECT(pgsqlStringConnec ) TO gnHandle_pgsql
> IF gnHandle_pgsql < 0
> = MESSAGEBOX('Erro!!', 16, 'Erro de SPT/ODBC ao PostgreSQL')
> ENDIF
>
> como poso fazelo no JAVA para nao usar um DSN-ODBC
> GRATO.
> --
> ___________________________________
> sandrigo(dot)lezcano(at)gmail(dot)com
> RUA INDEPENDENCIA 135 - BOA VISTA
> CEP 06411-050 - Barueri/SP/Brazil
> FONE 11 4198-1095
> Vip-Systems Informatica
> http://www.vip-systems.com.br
> ===============================
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Nahum Castro González
León, Guanajuato, México
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-03-01 20:23:08 | Re: Connection pool problem |
Previous Message | Tom Lane | 2005-03-01 18:03:48 | Re: impossible to update rows specifying columns with NULL |