This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes database & JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Reply locked New topic

database & JDBC

Simon Xu
Ranch Hand

Joined: Aug 16, 2000
Posts: 235
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,
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17271

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?

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17271

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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: database & JDBC
It's not a secret anymore!