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: [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 > 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 [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
