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.
i have this JSP where i'm getting rows of data displayed from the database. Some of the feilds in the row are editable and on one click of a submit button all the rows that are changed should be updated. All this works fine but SOMETIMES, the database gets updated wiht previous value... i don;t know whether the connection is using cached resources.... but i don't want that... how can i avoid this...!!??? Is there any feature for setting the connection string to "set cache false". Im using jdbc:mysql connection string.
My connection string is as below --------------------------------- Connection conn=DriverManager.getConnection("jdbc:mysql://126.96.36.199:3306/itsupport","net","123");
I have already used: -------------------- response.setHeader("Pragma", "no-cache"); response.setHeader("Cache-Control", "no-cache"); response.setDateHeader("Expires", 0);
but this doesnot work... coz the problem is not in the display of the data but my problem is that my connection uses cached resources... How can i avoid it.. please help...
Joined: Jan 29, 2004
I tried searching through google as to how the above is possible... the only way how i can see is to use oracle connection.
i have downloaded the oracle-jdbc.jar and the ojdbc14.jar file..and attached to my class path.