RE: Help with Java

2002-12-04 Thread DENNIS WILLIAMS
Alex - And the funny part is that the person who nailed the solution, Steve Ollig, also works for us and isn't a part of our official Java initiative. Do you think he'll ever get good enough to be sent to Java training? -Original Message- Sent: Tuesday, December 03, 2002 4:20 PM To: Multip

RE: Help with Java

2002-12-03 Thread Alex
My condolences to you. On Tue, 3 Dec 2002, DENNIS WILLIAMS wrote: > John - I forwarded your message to one of our newly-trained Java > programmers. He replied with: >The code is incomplete, how are they handling the connection. >Obviously the while loops are messing each other up. >Th

RE: Help with Java

2002-12-03 Thread DENNIS WILLIAMS
John - I forwarded your message to one of our newly-trained Java programmers. He replied with: The code is incomplete, how are they handling the connection. Obviously the while loops are messing each other up. There are multiple ways of handling this. If I see the complete code I can b

Re: Help with Java

2002-12-03 Thread Alex
comment out myDataFiles.close(); and see what happens. On Tue, 3 Dec 2002, John Weatherman wrote: > All, > > I am beginning the journey into JAVA and have hit an odd behavior > (well, probably not, but I can't see any reason for it). I am > building a list of tablespaces and the datafiles that

RE: Help with Java

2002-12-03 Thread John Weatherman
Steve, This was it exactly. Thanks! John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Tuesday, December 03, 2002 2:44 PM To: Multiple recipients of list ORACLE-L John - your problem is that you are reusing the Statement named myStatement within your

RE: Help with Java

2002-12-03 Thread STEVE OLLIG
John - your problem is that you are reusing the Statement named myStatement within your while (myTablespaces.next()) loop. just declare and use a second Statement and i suspect all will be well once again. from http://java.sun.com/j2se/1.3/docs/api/index.html : java.sql Interface Statement All

Help with Java

2002-12-03 Thread John Weatherman
All, I am beginning the journey into JAVA and have hit an odd behavior (well, probably not, but I can't see any reason for it). I am building a list of tablespaces and the datafiles that belong to them. The open to the database is working fine. When I use: ResultSet myTablespaces = myStatemen