Re: JDBC driver writes binary data ONLY as Large Object

Peter Mount wrote:

> The problem here is that there is no metadata available to check.
>
> If the backend was able to precompile the query, then we would know the
> column type, but as it stands currently there is no way of finding out what
> the column type is.
>
> Peter

Ok. Suppose there was metadata available. How would you
rewrite the function PreparedStatement.writeBytes() such that
it writes the bytes directly into the column? Since that class
does everything through heavy use of String manipulation, I
can't see how to do it. Is there a way? I tried this:

public void setBytes(int parameterIndex, byte x[]) throws SQLException
{
set(parameterIndex, new String(x));
}

It barfed.

Bill