error: 'not in streaming mode'

[Lars Vegas]

hi there,
i have a big problem with my 8i database. i run a java application which is connected to 8i. sometimes, NOT always, i get an exception 'not in streaming mode'. i have no idea why this happens. but when it happens i have to start my server again.
any help appreciated.
thanx, lars

[Lars Vegas]

by the way, this message comes along withborland. "com.borland.dx.dataset.DataSetException: I/O-Exception: Not in Streaming-Mode". but maybe someone in here can help me anyway because it has to to with the access from borland to oracle.

[Beksy Kurian]

Lars,
1) Are you using the proper JDBC driver? Use classes12.zip with 8i.
2) Are you accessing long columns? Are you using resultset.getBytes() method? Have you tried changing the long columns to blobs?
3) Are you getting the resultset out of order?

4) Is the connection getting hosed? Is the application multiple threaded? Are you using connection pooling?

If one of the threads closes the connection and the other one is trying to insert a long value, this error may occur. Also, once you start reading from or writing to a stream, you have to finish it before doing any other operations on that connection.
Try synchronizing the connection object before the 'stream' code.
Regards
Beksy

[Mark Spritzler]

Hey Lars. Is Lars Vegas your real name?
That's pretty funny. I mean it shows your parents had a sense of humor.
I apologize for all those mean children, if you were ridiculed when you were young. They were just stupid kids.
Mark