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]
