wood burning stoves*
The moose likes JDBC and the fly likes need solution Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need solution" Watch "need solution" New topic
Author

need solution

Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 289

Hi all
i have developed an DataBase application in java.
my problem is if Data base table's schema is changed, and the code to access that data is not changed. the application is crashed.

i their any software to track this problems and it should inform the developer that table is modified, code is changed like that.

Thanks in advance


-Chiru
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

i their any software to track this problems and it should inform the developer that table is modified, code is changed like that.


No , i don't think there is any software like this, but you can always set the DB parameters when you start your application or set all DB information in .properties files and access those settings, so whenever your BD schema changes, you can reflect those changes in properties file .

Hope this help !!


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Originally posted by Chiru Raj:
i their any software to track this problems and it should inform the developer that table is modified, code is changed like that.


e-mail + a competent employee


My Blog: Down Home Country Coding with Scott Selikoff
Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 289

i did not get you
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

I was trying to point out that I've never worked in an environment in which one employee was allowed to change the database schema without some process for notifying the development team. In fact, all database changes generally require notifying the development team. In some organizations, employees have to get permission from developers even before making the change.

In other words, the best 'automated' tool to inform the developer there's a change in the database is the individual who made the change.
Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 289

Ya you are right.

But its happened by mistake. So i want to know is their any thing to control or track.


Thanks for all these inputs
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Not really. I mean you could write a tool that compares one database structure against another but its kind of unnecessary. If you can't trust the people modifying the database, then they shouldn't be modifying the database in the first place. Really, this is a software developer training and process issue, not a code issue.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need solution