driver fails to handle strings in query statements properly

Поиск
Список
Период
Сортировка
От Lora Goldston
Тема driver fails to handle strings in query statements properly
Дата
Msg-id 3BB8B6CE.6020400@bbn.com
обсуждение исходный текст
Ответы Re: driver fails to handle strings in query statements properly
Список pgsql-jdbc
    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.java:432
)


Is there a fix for this?

Thanks in advance,

Lora Goldston


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tanesh Sehgal
Дата:
Сообщение: jdbc2.0 compliance
Следующее
От: Grant Edwards
Дата:
Сообщение: Errors when building jdbc dirver jar file