postgresql and java data types mismatch.....

Hi,

I have got and issue about data types, perhaps I'm missing some info I should
know, or there is anything wrong in the code, but I would like that if
someone knows why this happens, ust explain it to me.

According to documentation, java.sql.Types.BOOLEAN is the equivalence of SQL
BOOLEAN, but a function returning a boolean, returns something matched to
Types.BIT in java. It happens in the following code.

java code:
....... vars declarations, etc...
boolean is_client = false;

//procedure call
cs = conn.prepareCall("{ ? = call get_is_client( ? ) }");

cs.registerOutParameter(1, Types.BOOLEAN);
cs.setInt(2, client_id);
cs.execute();

is_client = cs.getBoolean(1);

.....
plpgsql function :

CREATE OR REPLACE FUNCTION get_is_client() RETURNS boolean AS '
BEGIN
RETURN is_true;
END;
' LANGUAGE plpgsql;

When run the java code, I receive the following message :

A CallableStatement Function was executed and the return was of type
(java.sql.Types=-7) however type=java.sql.Types=16 was registered.

Types = -7 correspond to Types.BIT
Types = 16 correspond to Types.BOOLEAN

That's all. Thanks in advance.

Best regards.

--

Andres Ledesma
=================