Re: BUG? res.next() == false, but psql finds tuples?

Palle,

I presume you mixed the two up ?

userid is text (setInt())
courseid is int (setString())

Dave

Palle Girgensohn wrote:

>
>
> --On fredag, april 22, 2005 11.01.32 -0400 Tom Lane
> <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>>
>>> Certainly looks like a bug, in the java version mango is not quoted so
>>> pg thinks it is a column.
>>
>>
>> But that's just sloppiness in the java log message. The TCP dump shows
>> clearly that the values are being sent as $n parameters.
>>
>> I'm wondering about misassignment of data types or something. It's not
>> clear though how that would result in no error but zero rows returned.
>> What are the column data types exactly?
>
>
> userid is text (setInt())
> courseid is int (setString())
>
> lang is text
>
>
> Interesting that the int is transported as text, `38', but I guess
> there are very good reasons for this (not having to duplicate code in
> the jdbvc driver, different endians, etc).
>
> There is no error in the pgsql log, just no result. The same
> connection is beeing used for all queries. It is reproducable, every
> time, in our app.
>
> /Palle
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561