Re: SQLException: Function sequence error

Ciao,
fully agree,
or retry to open the same object.

On Fri, 9 Jan 2004 10:38:55 -0800, Paul Holm wrote:

>Andy,

>I have seen this issue when you are trying to work with the connection or
>result set and it has been closed.

>In other words the sequence of your code is "out of sequence".  Possible
>causes:

>a)  Trying to read from a RS when it is closed
>b)  Trying to close a connection when it was already closed
>c)  File IO against a result set when it is not opened, etc...

>d)  Possible Threading issue when 1 thread may be closing or using the
>connection and another is also?

>Also it might help on the tool box driver to turn tracing on and look at the
>output.

> .......getConnection("mysys;trace=true", "myuser", "MYPWD")

>Check out toolbox JDBC properties for details.

>Hope this helps.

>Paul Holm
>Senior Web Architect
>PlanetJ Corp.
>Phone: 760-432-0600, Cell: 760-415-8830
>WOW, Web Applications In Under 5 Minutes
>http://www.gotWebData.net
>>


>End of JAVA400-L Digest, Vol 2, Issue 3
>***************************************

>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.



-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne