What is the difference in use of JDBC drivers provided by Sun and Oracle?
What will be an ideal response?
Using Sun’s driver
Connection conn =
DriverManager.getConnection("jdbc:odbc:shah_ora", userName, passWord);
Where “jdbc:odbc:shah_ora” is the url suited for Sun’s jdbc.odbc.JdbcOdbcDriver. The
url contains data source name shah_ora. Data source is created with Windows operating
system’s Administrative tool Data Sources (ODBC) in the control panel. ODBC (Open
DataBase Connectivity) is a programming interface that enables applications to access
data in database management systems that use SQL as a data access standard. User name
and password can be passed as String objects or hard-coded literals.
Using Oracle’s driver
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@nshah-monroe:1521:oracle","nshah","india_usa");
Where url is suited for Oracle’s oracle.jdbc.driver.OracleDriver, and it contains driver type thin, server name nshah-monroe, default port number 1521, and database sid oracle. If you want to connect to Oracle server from your PC, you will need the server name as well as domain name. For example, if server name is oracleadmin at domain indo-us.edu,
you will use oracleadmin.indo-us.edu.
You might also like to view...
Shortcuts can be retrieved from the Recycle Bin
Indicate whether the statement is true or false
Which interface status code type is generally used to display the Layer 2 status of an interface?
A) Line status B) Interface status C) Protocol status D) MAC status
The ____ format displays the first line of text at the left margin and indents all other lines to the first tab.
A. First-line paragraph indent B. Hanging indent C. Left indent D. Left and right indent
You can use the delete() function to delete files.
Answer the following statement true (T) or false (F)