CST(72)-Java Database Connection (JDBC)

JDBC is a set of Java classes that provide an ODBC-like interface to SQL databases. Like ODBC, JDBC uses a driver manager to automatically l...

JDBC is a set of Java classes that provide an ODBC-like interface to SQL databases. Like ODBC, JDBC uses a driver manager to automatically load the right JDBC driver to talk to a given database.

Unlike ODBC, JDBC must pay close attention to mobile code issues. For example, a JDBC driver must prevent an untrusted applet from accessing databases outside its home machine- meaning the machine from which the applet originates. Likewise, a driver that is downloaded as an applet can only be allowed to access its home database. Of course, applets and drivers can get around these limitations by convincing the Java loader that they are trustworthy;

URL based naming scheme: jdbc:<subprotocol><domainname>. For example, the URL to access “MyJavaDB” via a JDBC-to-ODBC bridge might look like this:


In this example, the subprotocol is “odbc” and the hostname is www.bob.com”. You can also use this scheme to provide a level of indirection in database names. You do this specifying a naming service as the subprotocol. Here’s an example of a URL that does this:

In this example, the URL specifies that the DCE naming service is used to resolve the database name “MyJavaDB” into a global name that connects to the database. JDBC recommends that you provide a psuedo-driver that looks up names via a networked name server. It then uses the information to locate the real driver and pass it the connection information.

Best Online Tutorials | Source codes | Programming Languages: CST(72)-Java Database Connection (JDBC)
CST(72)-Java Database Connection (JDBC)
Best Online Tutorials | Source codes | Programming Languages
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content