Re: string de conexao em JAVA

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

In response to

Browse pgsql-jdbc by date

  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