Re: Cursornames - Mailing list pgsql-jdbc

From Felipe Schnack
Subject Re: Cursornames
Date
Msg-id 20030805132555.19a5b376.felipes@ritterdosreis.br
Whole thread Raw
In response to Re: Cursornames  (Fernando Nasser <fnasser@redhat.com>)
List pgsql-jdbc
> > I can write it today...
> I would appreciate if you could take the time to do it.
  Ok, I will

> >   Anyway, I know in the spec setFetchSize() is just a hint for the
> > driver, but the current pgsql's driver behavior isn't to create a
> >cursor?
> Only if it can, if it cannot it just sends the query as is and gets
> the full result set.
  When it can't? When there are multiple queries in the SQL or when you're using DECLARE I can understand... there are
moresituations? It can use a cursor when I'm not using servir-side prepared statements? 

> It is meant as a way to match the "impedance" between host languages
> which usually specify scalar variables to receive the data retrieved
> and SQL (which can return sets).
  Hm... impedance? I don't think I understand you. Maybe you can send me a private message in portuguese, as far as I
rememberyou're also a Brazilian :-) 
  But which are the situations that pgsql loads all data from the query to server's memory? I had this once, can't
rememberhow I fixed it. 
--

 /~\ The ASCII        Felipe Schnack (felipes@ritterdosreis.br)
 \ / Ribbon Campaign  Analista de Sistemas
  X  Against HTML     Cel.: 51-91287530
 / \ Email!           Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone: 51-32303341

pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: Cursornames
Next
From: Fernando Nasser
Date:
Subject: Re: Cursornames