Re: driver fails to handle strings in query statements properly

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@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Lora Goldston
Sent: October 1, 2001 2:33 PM
To: pgsql-jdbc@postgresql.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