>>>>> "Amit" == Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
Amit> Andrew also mentioned a workaround in his reply to use setString
Amit> such that JDBC doesn't pass 'MONTH' as of type 'text' and instead
Amit> as of unknown type. I could't find the documentation of Postgres
Amit> JDBC's setString to see how one can do that, but maybe you can
Amit> try it out.
Disclaimer: I don't do java stuff myself, all I know about this is from
reading the code.
First, there's a connection parameter stringtype=unspecified that
affects all setString calls on the connection. Second, there may be a
way to use setObject instead; setObject(1, str, Types.DISTINCT) looks
like it might work (or maybe Types.OTHER) - unless I'm completely
misreading the pgjdbc code, that should end up sending the right thing
to the server.
--
Andrew (irc:RhodiumToad)
