Your book is specifically about JDBC for Oracle databases, I see. Since Oracle is the DB I regularly deal with professionally, I would like to ask you if you discuss in detail the preferred drivers to be used with the different Oracle versions. There is soon to be an upgrade to 10i where I work, and I am curious as to any changes in this regard.
Also, If I may be so bold, I would like to ask you a question about Statements. I've noted that some well respected programmers advocate closing all Statements explicitely, in addition to explicitely closing the Connection.
In my own experience with working on Oracle DBs, when submitting many different queries (executing many Statements), closing the Statements explicitely after each and everyone sometimes breaks the application; whereas not doing so for all intents and purposes gives every indication of working smoothly. Closing the Connection explicitely is not an issue
May I have your own opinion on this?
Originally posted by Maximilian Stocker:
Thank you for your reply. Your book sounds like a worthwhile read. The reason I am not using PreparedStatements for 'the' particular application I refer to is because it is basically an SQL-Plus kind of application that allows free form on the fly SQL query entry and is not part of a production run 'series' of SQLs statements. Otherwise, in other applications I do use PreparedStatements often.
When evil is afoot and you don't have any arms you gotta be hip and do the legwork, but always kick some ... tiny ad:
the value of filler advertising in 2020https://coderanch.com/t/730886/filler-advertising