Top X Jdbc Best Practices For Coffee Programmer
Friday, August 3, 2018
Add Comment
Java JDBC Best practices
JDBC Best Practices are some coding practices which Java programmer should follow piece writing JDBC code. As discussed in how to connect to Oracle database from Java, JDBC API is used to connect together with interact alongside a Database administration System. We possess got touched some of the JDBC best practices inwards our in conclusion article 4 JDBC Performance tips, On which nosotros possess got discussed uncomplicated tips to improve functioning of Java application alongside database. By using JDBC you lot tin execute DDL, DML together with Stored Procedures. JDBC Best practices is likely most pregnant laid of coding practices inwards Java because it significantly touching on functioning of Java application. I possess got seen substantial functioning make past times exactly next mutual JDBC best practices similar running queries alongside automobile commit fashion disable. One of the query which nosotros used inwards our instance of JDBC Batch update was taking most xxx minute to destination alongside automobile commit fashion enabled but it exactly took nether 1 minute alongside automobile commit fashion disable together with using explicit commit. This JDBC tutorial is collection of such practices which assist you lot to write ameliorate JDBC code together with inwards most cases number inwards improved performance.
10 JDBC Best pratices inwards Java
Here is my listing of move past times 10 JDBC best practices inwards Java which helps to avoid potential error, to teach ameliorate functioning together with helps to write robust Java database connection code. JDBC Best Practice #1: Use PreparedStatement
This is past times far most pop JDBC practices suggested past times everyone who has worked inwards JDBC API inwards Java. Indeed PreparedStatement deserve that admiration because of useful services it provides similar prevention from SQL injection, Precompiled SQL queries together with purpose of bind variables every bit discussed in why Use PreparedStatement inwards Java
JDBC Best Practice #2: Use ConnectionPool
ConnectionPool every bit JDBC best practise has already gained recognition together with it fifty-fifty teach criterion at nowadays days. Several framework provides inwards built connection Pool facility like Database Connection Pool inwards Spring, DBCP together with if you lot are running inwards managed environs similar J2EE Application Server e.g. WAS or JBOSS, Server volition furnish Connection Pool facility. rational behind this JDBC best practices is that Creating JDBC connection possess got relatively longer fourth dimension which tin increase overall response time, past times caching JDBC connection inwards puddle application tin at nowadays access database.
JDBC Best Practice #3: Disable automobile commit mode
This is 1 of those JDBC best practices which provided substantial functioning make inwards our JDBC batch update example. Its recommended to run SQL query alongside automobile commit fashion disable. Rational behind this JDBC best practise is that alongside automobile commit fashion disabled you lot tin group SQL Statement inwards 1 transaction piece inwards instance of automobile commit fashion every SQL disputation runs inwards its ain transaction together with committed every bit shortly every bit it finishes. So e'er run queries alongside automobile commit fashion disabled
JDBC Best Practice #4: Use JDBC Batch Update
This is some other JDBC best practise which is real popular. JDBC API provides addBatch() method to add together SQL queries into batch together with executeBatch() to mail batch queries for execution. Rational behind this JDBC best practices is that, JDBC batch update potentially bring down number of database roundtrip which number inwards pregnant functioning gain. So e'er Use JDBC batch update for insertion together with update queries.
JDBC Best Practice #5: Access ResultSet using column advert to avoid invalidColumIndexError
JDBC API allows to access information returned past times SELECT query using ResultSet, which tin farther last accessed using either column advert or column index. This JDBC best practise propose using column advert over column index inwards gild to avoid InvalidColumnIndexException which comes if index of column is incorrect, most mutual of them is 0, since ResultSet column Index starts from 1, zero is invalid. Also you lot don't require to alter your JDBC access code if gild of column changed inwards SELECT SQL query, which is a major maintenance make together with a robust agency to write JDBC code. Some Java programmer may debate that accessing column using index is faster than name, which is truthful but if you lot expect inwards damage of maintenance, robustness together with readability, I prefer accessing column using advert inwards ResultSet Iterator.
JDBC Best Practice #6: Use Bind variables instead of String concatenation
In JDBC Best Practice #1 nosotros possess got propose to use PreparedStatement inwards Java because of ameliorate performance. But functioning tin solely last improved if you lot purpose bind variables denoted past times ? or house holders. which allows database to run same query alongside dissimilar parameter. This JDBC best practices also number inwards ameliorate functioning together with also furnish protection against SQL injection.
JDBC Best Practice #7: Always unopen Statement, PreparedStatement together with Connection.
Nothing novel on this JDBC Best practice. Its mutual Java coding practise to unopen whatever resources inwards finally block every bit shortly every bit you lot are done alongside that. JDBC Connection together with other JDBC classes are costly resources together with should last closed inwards finally block to ensure unloose of connection fifty-fifty inwards instance of whatever SQLException. From Java seven onwards you lot tin purpose Automatic Resource Management (ARM) Block to unopen resources automatically.
JDBC Best Practice #8: Choose suitable JDBC driver for your application
There are iv typs of JDBC driver inwards Java together with it tin straight touching on the functioning of DAO layer. e'er purpose latest JDBC Driver if available together with prefer type iv native JDBC Drivers.
JDBC Best Practice #9: Use criterion SQL disputation together with avoid using db specific query until necessary
This is some other JDBC best practise inwards Java which ensures writing portable code. Since most of JDBC code is filled upward alongside SQL query its slow to offset using Database specific characteristic which may introduce inwards MySQL but non inwards Oracle etc. By using ANSI SQL or past times non using DB specific SQL you lot ensure minimal alter inwards your DAO layer inwards instance you lot switch to some other database.
JDBC Best Practice #10: Use right getXXX() method
This is the in conclusion JDBC best practise inwards this article which propose using right getter piece getting information from ResultSet to avoid information conversion fifty-fifty though JDBC allows to teach whatever information type using getString()or getObject().
That's all on JDBC best practices for Java Programmer, I am certain at that spot are many to a greater extent than JDBC best practices unopen to but these are most mutual practices which I tin intend of. allow us know if you lot are familiar alongside whatever other JDBC best practice.
Further Learning
JSP, Servlets together with JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 together with 2
10 best practices to follow piece writing code comments
0 Response to "Top X Jdbc Best Practices For Coffee Programmer"
Post a Comment