Method and apparatus for caching multiple Java-database connectivity

A recording medium that implements by types a program of commands executable by a digital processing apparatus to perform a cache management method in a multi-layer Java-database connectivity unification system having a Java-database connectivity driver and a database server, and that is readable by the digital processing apparatus, the recording medium performing the steps of:

• if a database query statement is received from the Java-database connectivity driver, judging a kind of the query statement by analyzing the received query statement;
• a) if the kind of the query statement is a data change statement and data changed according to the data change statement is stored in a cache, setting the corresponding data to be in a “changed” state, and b) if the changed data does not exist in the cache, transferring the data change statement to the database server so that the database server changes the data according to the data change statement;
• and
• a) if the kind of the query statement is a data search statement, and if the data to be searched according to the data search statement exists in the cache and the data is in an “updated” state, transferring the data to the Java-database connectivity driver, and b) if the data to be searched exists in the cache and the data is not in the “updated’ state, transferring the search statement to the database server to have the database server process the data search statement, checking if it is necessary to store a search result in the cache, and adding the searched data in the cache.