Обсуждение: InputStream as parameter not supported

Поиск
Список
Период
Сортировка

InputStream as parameter not supported

От
Travis Bauer
Дата:
I'm using the JDBC driver 7.1.  I'm trying to write data into
prepared statements using InputStreams.  When I use the sample
program with a simple example, it works great.  When I use the
'real world' code, I get the above error.

Are there any known flaws or exceptions in the 7.1 JDBC driver that would
occassionally produce the "InputStream as parameter not supported"
error?

Thanks

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

Re: InputStream as parameter not supported

От
Travis Bauer
Дата:
Okay, I have found an old posting from Tom about setBytes that
said you had to use explicit begin and ends.  So I started
sending explicit "BEGIN" and "COMMIT" statements to the backend
and it worked.

But why do you have to use explicit BEGIN and COMMIT statements
if you have autocommit turned off?  I appearantly have to send
both a "COMMIT" statement to the back end and then execute the
Connection's commit() method to get the transactions committed.
Why is that?

Thanks,

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

Travis Bauer (trbauer@indiana.edu) wrote:

> I'm using the JDBC driver 7.1.  I'm trying to write data into
> prepared statements using InputStreams.  When I use the sample
> program with a simple example, it works great.  When I use the
> 'real world' code, I get the above error.
>
> Are there any known flaws or exceptions in the 7.1 JDBC driver that would
> occassionally produce the "InputStream as parameter not supported"
> error?
>
> Thanks
>