• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Object has been closed

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm new to jsp and need help. I have this code working in php, but cant get it to work in jsp. Please help. This page produces this error... I'm running JRun4 with jre1.4.2. I've tried several dsn connections using macromedia's driver, oracle's thin driver and jdbc to odbc bridge and get the same results every time.
Exception in main try block
Error:java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Object has been closed.

[ March 18, 2004: Message edited by: Bear Bibeault ]
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Despite the fact that you are doing all this processing in a JSP (which I would highly recommend against), this is really a database question. So I'm moving this along to the JDBC forum for you.
 
Jeremy Taylor
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Like I said, I'm new to this. I haven't grasped the concept of javabeans yet. What do you recommend I do? What am I looking at? 3 servlets, 3 javabeans, and a jsp page that calls all 3 javabeans and loops over the results? Can you point me to some docs on javabeans?
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Here in this topic, let's keep to the JDBC problem you are having. With regards to web app architecture, please look through the JSP and Servlets forums for tips and best-practice patterns (hint: search for terms MVC and 'Model 2'). Any questions you may have on web app structure will be gladly handled there.
Another hint: use the UBB code tags around your code fragments (I added them to your original post) to preserve the code formatting. Most people will not take the time to try and decipher unformatted code.
Is there any chance you could post the entire stack trace displaying the exact line number where the problem is occurring?
 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You are using the dbstatement object for all the resultsets. try using different statement for each resultset.
Gowrishankar
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic