Oracle jdbc class name thin driver

The most common approach to register a driver is to use Java's Class. This method is preferable because it allows you to make the driver registration configurable and portable. The second approach you can use to register a driver, is to use the static DriverManager. After you've loaded the driver, you can establish a connection using the DriverManager. For easy reference, let me list the threeoverloaded DriverManager.

Here each form requires a database URL. A database URL is an address that points to your database. Formulating a database URL is where most of the problems associated with establishing a connection occurs. All the highlighted part in URL format is static and you need to change only the remaining part as per your database setup. We have listed down three forms of DriverManager.

The most commonly used form of getConnection requires you to pass a database URL, a username , and a password :. Assuming you are using Oracle's thin driver, you'll specify a host:port:databaseName value for the database portion of the URL.

A third form of the DriverManager. To make the Oracle driver behave in a Java EE-compliant manner, you must set this system property as true : oracle.

DataDirect DataSource Classname: com. Optional: only needed if both non-XA and XA connections are retrieved from the same connection pool.

Class class to load the JDBC drivers directly. For example: Class. OracleDriver" ;. However, this method is valid only for JDK-compliant Java virtual machines. It is not valid for Microsoft Java virtual machines. Once you have registered the driver, you can open a connection to the database with the static getConnection method of the java. The type of the object returned is java. The following example connects user scott with password tiger to a database with SID orcl through port of host myhost , using the Thin driver.

After the class is loaded system can connect to Oracle using it. An alternative would to use the jdbc. Use oracle. OracleDriver, not oracle. Save this as test. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. What is the actual use of Class. OracleDriver" while connecting to a database? Ask Question. Asked 10 years, 2 months ago. Active 4 years, 8 months ago.

Viewed k times. What will the command Class. OracleDriver" exactly do while connecting to a Oracle database? Mark Rotteveel Aravind Aravind 2, 3 3 gold badges 24 24 silver badges 28 28 bronze badges. Related: stackoverflow. OracleDriver" in class A constructor, and I create A's object to get connection field for each servlet where I need connection then java will skip Class.