PM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]
Subject: Re: [JDBC] driver fails to handle strings in query statements
properly
As I said, I have no idea how the backend handles it when it is quoted.
You mention that it's not a column reference, but it does get data from
the id column?
16 PM
To: [EMAIL PROTECTED]
Cc: 'Barry Lind'; [EMAIL PROTECTED]
Subject: Re: [JDBC] driver fails to handle strings in query statements
properly
"Dave Cramer" <[EMAIL PROTECTED]> writes:
> I tried it on a table which id was an int
> Using "select 'id&#
"Dave Cramer" <[EMAIL PROTECTED]> writes:
> I tried it on a table which id was an int
> Using "select 'id' as xxx from ..." Returns xxx as an unknown type
> Using "select id as xxx from... " returns xxx as an int
> I have no idea how the backend handles this, but if it can figure it out
> in one i
't it figure it out when I put single quotes
around it?
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: October 2, 2001 5:19 PM
To: Barry Lind
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [JDBC] driver fails to handle s
her types it should be returned as?
>
> Dave
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Lora Goldston
> Sent: October 1, 2001 2:33 PM
> To: [EMAIL PROTECTED]
> Subject: [JDBC] driver fails to handle strings in query statements
Barry Lind <[EMAIL PROTECTED]> writes:
> My thoughts as well. If we encounter an 'unknown' type, just return it
> as a String. Do you have time to fix this?
>> I suppose we could return it as a string when we are in doubt? Is this
>> reasonable since there are many other types it should be ret
are many other types it should be returned as?
>
> Dave
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Lora Goldston
> Sent: October 1, 2001 2:33 PM
> To: [EMAIL PROTECTED]
> Subject: [JDBC] driver fails to handle strings in q
PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Lora Goldston
Sent: October 1, 2001 2:33 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] driver fails to handle strings in query statements
properly
I am using jdbc7.0-1.2.jar. I am getting a "No class found for
unkown" when I use strings i
I am using jdbc7.0-1.2.jar. I am getting a "No class found for
unkown" when I use strings in my query statements such as 'Container'
seen in the query below. These queries work fine when I use Oracle or
MySQL. This looks like a bug to me. I can work around this by
explicitly casting t
