Hi Author and others,
I have a very small question regarding optimizing the performance of Oracle using JDBC. Also what are the best practices to connect to an Oracle Database.
I often face slow connections,
Kindly guide
Thanks
For connecting, almost always you want to use connection pooling as Stu puts elegantly.
For using JDBC performance wise there are many many best practices. Some that pop to the mind immediately are:
1. Knowing and exploiting your database features to the maximum extent (independent of whether you use JDBC or not and regardless of whether you use Oracle, DB2, MySQL or whatever) This is the part most Java developers miss out on typically and this is very important IMHO.
2. Using batch processing (update batching) or fetch size when required.
3. Using bind variables unless you know why you are not using them(i.e. use PreparedStatement and CallableStatements)
among others.
Menon