I have been reading the archives trying to fix a problem I had with the -904 error message using Java JDK 1.4 on Win 2000 and Kernel and Runtime 7.3.0 build 020. ( I am running select queries with 60% of the dataspace free on a 600 meg database.)
I appear to have "fixed" the code by rearranging code to reduce the number of prepareStatement calls that are made on the connection. What is interesting was that doing an explicit close of the offending prepared statements does not help. According to the Javadocs for ResultSet. Note: A ResultSet object is automatically closed by the Statement object that generated it when that Statement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet object is also automatically closed when it is garbage collected. Does anyone else have experience of -904 errors running Java on Win2000 where it appears that the problem should not occur? Martin P. Smith Beansmith Technologies. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
