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

help with front/backend datatype converting

From: "Do, Leon (Leon)" <leondo(at)lucent(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: help with front/backend datatype converting
Date: 2006-11-10 20:58:16
Message-ID: D1EE06BA46B1E4449AF9A4F2FBEE1861223C37@ILEXC2U01.ndc.lucent.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

 

It looks like PostgreSQL JDBC always converting a column value to text
before sending it to the Backend server.  Is there a way to stop this
behavior? 

 

I am using the following piece of code to set the timestamp value:

 

ByteArrayInputStream is = new ByteArrayInputStream(bdata);

 

prepstmt.setBinaryStream(1,is,bdata.length);

                 

java.sql.Timestamp sqltime = new  

 
java.sql.Timestamp(System.currentTimeMillis());

prepstmt.setTimestamp(2,sqltime);

 

 

When the backend server receives the parse message, the oid type for
binary data is set but the oid type for timestamp is not set.

 

When the bind message arrives, the format type for binary data is binary
and the format type for timestamp is text and there is no way to know
what is the type of the value anymore.   Can I configure to disable text
converting feature?

 

thanks

 

 

Leon Do

Lucent Technologies

Mobility Software Engineer

 

 

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2006-11-10 21:15:06
Subject: Re: help with front/backend datatype converting
Previous:From: Heikki LinnakangasDate: 2006-11-10 16:25:19
Subject: Re: [Fwd: FAQ update about transaction interleaving]

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