Say Java

JDBC (Java Database Connectivity) is an API that allows Java programs to access the database to read or modify data in databases. Below given are various databases and their Type 4(thin) JDBC driver details For each database I have given the driver name and the URL from where you can download the jdbc driver jar file. Oracle Driver name:  oracle.jdbc.driver.OracleDriver URL:  http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html (Drivers for various Oracle versions including 8i, 9i,10g, 11g are available here) Microsoft SQL Server Driver name:  com.microsoft.sqlserver.jdbc.SQLServerDriver URL:  http://www.microsoft.com/download/en/details.aspx?id=21599 ( This driver can connect to SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Server 2000 versions )    IBM DB2 Driver name:  java com.ibm.db2.jcc.DB2Jcc URL:   http://www-01.ibm.com/support/docview.wss?uid=swg21363866 ( DB2 Ve...

Q: What is fully qualified table name pattern? Ans: A fully qualified table name is an unambiguous name that specifies a table in a database. It is advisable to use the fully qualified name of a table so that there are less chances of errors. Various databases have different patterns of fully qualified table names. Below given are the details of various databases and their fully qualified table name patterns Database Fully qualified table Pattern Oracle SCHEMA.TABLE DB2 CATALOG.TABLE MySQL SCHEMA.TABLE Microsoft SQL Server [CATALOG]..[TABLE] PostGre SQL "SCHEMA"."TABLE"