Why Java Classes in Databases?
Extensible database servers have been available for several years, but Java in the database arrived with great promise. Performance improvements, memory management and adoption by SQL database vendors have caused Java to become a favored tool for creating database extensions. Programmers have often used C/C++ when developing dynamic link libraries (DLLs) to extend servers such as Raima Velocis, Sybase Adaptive Server, IBM Informix Dynamic Server, and Microsoft SQL Server. Database servers are often doing mission-critical processing, so installing a faulty extension can be an invitation to a server crash. Programmers writing C/C++ DLLs must exercise care to avoid memory leaks, runaway pointers and buffer overruns — problems that Java was designed to eliminate. Java is versatile enough to be suitable for programming all tiers of a multi-tier application. This solves the problem of using different languages for programming clients, servers, components, and stored procedures. Java adds a