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
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
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