Java is a software development tool used to make Web, desktop and mobile applications. Databases are the central component for dynamic content, so Java supports connecting to the common database solutions. Java is capable of connecting to Oracle, MySQL and SQL Server databases. The Java language connects using the JDBC driver available in the Java library.
MySQL
- MySQL is a popular database solution. MySQL continues to be popular due to its affordable price (free for home users), and the availability of plug-ins and content tools. Many blogs such as Blogger and Wordpress use the MySQL database solution to host dynamic content. MySQL is also used for free Web forums such as PHP BB. The Java JDBC connects to MySQL and allows developers to run stored procedures, inline SQL and table creations within the Java application.
SQL Server
- SQL Server is a database solution distributed by Microsoft. SQL Server has several versions still used in small to large businesses such as 2000, 2005 and 2008. SQL Server is used with the Microsoft .NET framework, which allows developers to code in several languages. Java also supports the Microsoft SQL Server environment using the JDBC driver. Using the JDBC Java drivers, developers can execute stored procedures, views, table creation and deletions and even maintain SQL Server security and user permissions.
Oracle
- Oracle is a back-end database solution for large enterprises. Oracle is also commonly used in telephony environments, so it is commonly used to host PDA and mobile communications content. Java is used heavily in the mobile phone industry, so it works seamlessly with the Oracle database server. Connecting Java to an Oracle database uses the same JDBC driver connection, so Java developers can connect to several database platforms together. Since Oracle database environments sometimes use other solutions such as MySQL or SQL Server for Web content, the Java developer can implement a heterogeneous connection to Oracle and other databases together.
