|
From: Robert M. <rob...@gm...> - 2011-12-01 21:00:53
|
The "Make Editable" feature of SQuirreL that allows you to load table data, then modify cell contents and submit that data in the form of an update statement uses a conservative approach to determining if the data has been updated on the server. It doesn't merely use the primary key in the where clause. It uses all columns in the where clause to determine first if the record exists (that is no one has modified it) before making the change. For executing update SQL statements from the SQL Editor, there is no "loaded data" in SQuirreL that could become stale. Rob On Thu, Dec 1, 2011 at 12:22 PM, Cefalu, Giuseppa <GC...@pa...>wrote: > ** > > Thank you, > > You are correct. Since Squarrel runs with my SQL, all the previous > questions are answered. I guess, my question really is, whether muliple > users can insert, edit and delete records concurrently without interfearing > with each other. In other words, does Squirrel implement locks to protect > the data (data corruption) while users work with the data concurrenlty? I > am still confused about Java capabilities. Based on what I know; the java > language does not offer the capability of multiprocess creation within the > application. There is not code to implement myltiprocessing from inside > the application; however; you can write a server for the application that > creates multiple threads bases on user request. When threads are > implemented, the corresponding locks are put in place to protect data > integrity. > > Could you pelase explain a little bit how does Squirell work in this > respect? > > Giuseppa > > *Giuseppa Cefalu, M.S* > IS Programmer/Analyst II > Thoracic Surgery Research Department > 221 Longwood Avenue > Phone: (617) 525-3072 > E-mail: gc...@pa... > > > The information in this e-mail is intended only for the person to whom it > is > addressed. If you believe this e-mail was sent to you in error and the > e-mail > contains patient information, please contact the Partners Compliance > HelpLine at > http://www.partners.org/complianceline . If the e-mail was sent to you in > error > but does not contain patient information, please contact the sender and > properly > dispose of the e-mail. > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
