From: | Lora Goldston <lgoldsto(at)bbn(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | driver fails to handle strings in query statements properly |
Date: | 2001-10-01 18:32:46 |
Message-ID: | 3BB8B6CE.6020400@bbn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2001-10-01 18:46:27 | Updated jdbc.postgresql.org website now in place |
Previous Message | Jorge Santos | 2001-10-01 16:03:23 | Re: Postgresql 7.1.2 and StarOffice 5.2 |