Timeline for Efficient use of MySQL Connections with Java
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 23, 2015 at 16:35 | comment | added | Phrancis | Yes, using prepared statements is a good habit to keep with any DB-accessing code. Remember, database administrators don't deal with bugs, only with regrets! | |
Mar 23, 2015 at 16:21 | comment | added | Bob Stout | As for the case-sensitivity, I had to rewrite part of that query and didn't notice I used both "end" and "End". It reads either the same, but good catch nonetheless. Also, I'm not using PreparedStatements because there's no user interaction in the code -- it's all driven from the database. While it's moot in this case, I probably should default to PreparedStatements just to stay in the habit of using them. | |
Mar 23, 2015 at 16:16 | history | answered | Mathieu Guindon | CC BY-SA 3.0 |