tag:blogger.com,1999:blog-18544104.post8824743971457977098..comments2024-01-13T10:17:55.043-08:00Comments on Stephen's Oracle Blog: Where should data be validated?Stephen Boothhttp://www.blogger.com/profile/18227774573735486445noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-18544104.post-35924295015764510682007-02-19T00:02:00.000-08:002007-02-19T00:02:00.000-08:00Tonguc,That's what I was trying to get at, validat...Tonguc,<BR/><BR/>That's what I was trying to get at, validation <B>must</B> happen in the database layer.<BR/><BR/>It's not just that multiple applications might use the same database schema, in theory you could possibly keep them all in sync with rule changes. The problem is that users have access to tools like SQL*Plus, Ms Access, <BR/>Toad, SQL DEveloper, JDeveloper &c that let them at the Stephen Boothhttps://www.blogger.com/profile/18227774573735486445noreply@blogger.comtag:blogger.com,1999:blog-18544104.post-64953336408653951042007-02-18T23:23:00.000-08:002007-02-18T23:23:00.000-08:00who may guarantee that there will be only one appl...who may guarantee that there will be only one application using your data in time? <BR/><BR/>I think you can only be sure of the integrity if you centeralize validation on the database, but if needed checks can also be done at client or mid tier of course :)Tonguçhttps://www.blogger.com/profile/10296956337243833265noreply@blogger.com