• 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

JDBC start/stop database needed

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Solaris 2.8
Hardware Sun Microsystems
Oracle 8.1.6
Java 1.4
Oracle JDBC class111.zip
I have a Java application that creates a JDBC connection to Oracle database and queries a table called foo, printing out the values. The table has three columns. I the do the following:
1. I close the resultset and statement, etc. and terminate the program.
2. I go into Oracle sqlplus session and drop the table foo and recreate the data (insert).
3. I re-run the Java application and the resulting query is 0 rows; No errors.
4. I stop and start the Oracle listener and retry the java application with not result.
5. I stop the Oracle listener and shutdown the Oracle database.
6. I startup the Oracle database and Oracle listener.
7. I run the Java application again and it gets the new data.
How to prevent restart of database for change in tables?
 
Ranch Hand
Posts: 227
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
LOL - I just did this same thing the other day! It really messed with my head. In SQL Plus, after the insert, do a commit! It doesn't autocommit for you...
 
James Redpath
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Correct that was it. I never disconnected from the database which would provide a commit.
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I wanna to see your source code.
 
Dana Hanna
Ranch Hand
Posts: 227
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There was no source code, this was a general database question. Read the thread!!!
 
reply
    Bookmark Topic Watch Topic
  • New Topic