Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
    Bookmark Topic Watch Topic
  • New Topic

database & JDBC

 
Simon Xu
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,
I am looking for the references (or papers) on this topic (or related topic):
How the change in the tables in database side affect the change of the Java code (or SQL) in JDBC part?
If we change the database part (such as delete a table, an attribute), which part of code in JDBC should be changed?
Thanks you very much,
Simon
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
Um, this sounds more like a JDBC question rather than an Oracle question. It should have been posted in the JDBC forum.
But, other than that, changes on the database, in essence, have absolutely nothing to do with your code or JDBC.
Meaning, If you drop a contraint or add an index, you don't have to do any changes to Java code. And JDBC is just the connectivity device to connect your Java code to the database. Also, if you drop a table, and in your Java code you query on the table, of course that code won't work.
Is there something to this question that isn't stated?
Mark
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
Oh, actually I see that you also posted this question in the JDBC forum.
Please refrain from duplicate posting in more than one forum. There is always going to be one most appropriate forum to post your question in, and this saves others from wasting their time responding when you already have an answer on the other thread.
I am going to first close this thread, then tomorrow I will delete it.
Thanks
Mark
 
    Bookmark Topic Watch Topic
  • New Topic