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(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