Skip site navigation (1) Skip section navigation (2)

setObject on PGInterval throws "Unknown Type null"

From: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
To: <pgsql-jdbc(at)postgresql(dot)org>
Cc: "Jean-Pierre Pelletier" <jppelletier(at)e-djuster(dot)com>
Subject: setObject on PGInterval throws "Unknown Type null"
Date: 2005-01-24 18:30:40
Message-ID: BAYC1-PASMTP01298C210325B348452D7995850@cez.ice (view raw or flat)
Thread:
Lists: pgsql-jdbc
We upgraded to JDBC Build 309 on PostgreSQL 8.0 from
JDBC Build 307 on PostgreSQL 7.4 and setObject now fails
on PGInterval

1)
if myPgInterval != null
   Originally code: myPreparedStatement.setObject(i, myPGInterval)
   It throws SQLException "Unknown type null"

   We tried: myPreparedStatement.setObject(i, myPGInterval, Types.OTHER)
   It throws "Unknown type null"

if myPgInterval == null
   Original code: myPreparedStatement.setObject(i,myPGInterval)
   It throws "setObject(i,null) is not supported. Instead, use setNull(i,type) or setObject(i,null,type)"

   We tried: myPreparedStatement.setNull(i, Types.OTHER)
   It throws "setNull(i, Types.OTHER) is not supported; use setObject(i,null, Types.OTHER) instead"

   We tried: myPreparedStatement.setObject(i,myPGInterval,Types.OTHER)
   It throws "setNull(i, Types.OTHER) is not supported; use setObject(i,null, Types.OTHER) instead"

How should setObject be coded with a PGInterval ?

2)
With JDBC Build 309, setObject requires an SQL Type when object == null,
this makes setObject(i, object) useless.

Why do JDBC requires an SQL Type when the same statement can be processed by psql 
without the SQL type specified?

Why is a standard JDBC method setObject(i, object) rendered useless?
Is it supported by other DBMS?

Thanks
Jean-Pierre Pelletier

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-01-24 19:35:54
Subject: Re: PGResultSetMetaData
Previous:From: Dave CramerDate: 2005-01-24 17:53:07
Subject: Re: Versioned vs unversioned jarfile names?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group