JDBC - Tutorial
Posted in Database, JAVA on March 27, 2008 | No Comments »
gfdgfd
Archive for the ‘Database’ Category
Optimization with Statement
Posted in Database on February 21, 2008 | No Comments »
Statement interface represents SQL query and execution and they provide number of methods and constants to work with queries. They also provide some methods to fine tune performance. Programmer may overlook these fine tuning methods that result in poor performance. The following are the tips to improve performance by using statement interfaces
[...]
Optimization with Connection
Posted in Database on February 21, 2008 | No Comments »
java.sql package in JDBC provides Connection interface that encapsulates database connection functionality. Using Connection interface, you can fine tune the following operations :
1. Set optimal row pre-fetch value
2. Use Connection pool
3. [...]
Practices to improve performance in JDBC
Posted in Database on February 21, 2008 | No Comments »
Overview of JDBC
JDBC defines how a Java program can communicate with a database. This section focuses mainly on JDBC 2.0 API. JDBC API provides two packages they are java.sql and javax.sql . By using JDBC API, you can connect virtually any database, send SQL queries to the database and process the results.
A Relational Database Overview
Posted in Database on February 19, 2008 | No Comments »
A database is a means of storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns. A table is referred to as a relation in the sense that it is a collection of objects [...]
