Re: driver fails to handle strings in query statements properly

Dave,

My thoughts as well. If we encounter an 'unknown' type, just return it
as a String. Do you have time to fix this?

As a work around using an explicit cast should also work:
select container_20_ft_qty AS QTY_OH, 'Container'::text AS NOMENCLATURE
from ue_summary_mtmc where uic = 'WAQJAA'

thanks,
--Barry

Dave Cramer wrote:

> This is coming back from the backend as type unknown. If the single
> quotes are removed it works ok?
>
> 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 returned as?
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Lora Goldston
> Sent: October 1, 2001 2:33 PM
> To: pgsql-jdbc(at)postgresql(dot)org
> 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 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 the string in the query statement like:
> 'Container'::varchar.
>
> *****************Inside LDMSQLPLUGIN About to query db ----> select
> container_20_ft_qty AS QTY_OH, 'Container' AS NOMENCLATURE from
> ue_summary_mtmc
> where uic = 'WAQJAA'
> EEEEEEEEEEEEEEE I caught an exception on resultSet.getObject(i + 1) -->
>
> Container
> No class found for unknown.
> at org.postgresql.Connection.getObject(Connection.java:621)
> at org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:741)
> at
> org.cougaar.domain.mlm.plugin.ldm.LDMSQLPlugIn.executeSQL(LDMSQLPlugIn.j
> ava:432
> )
>
>
> Is there a fix for this?
>
> Thanks in advance,
>
> Lora Goldston
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>