21 Day @ Apex : Connectivity with Oracle

-
Hi Readers,
Now i now about JDBC
Lets Connect my Java project with Oracle database, you can also connect with different database systems like MySQL. But here I am using Oracle, you can choose yours process is similar

To connect java application with the oracle database, we need to follow 5 following steps. In this example, we are using Oracle 10g as the database. So we need to know following information for the oracle database:


Driver class: The driver class for the oracle database is oracle.jdbc.driver.OracleDriver.


Connection URL: The connection URL for the oracle10G database is jdbc:oracle:thin:@localhost:1521:xe where jdbc is the API, oracle is the database, thin is the driver, localhost is the server name on which oracle is running, we may also use IP address, 1521 is the port number and XE is the Oracle service name. You may get all these information from the tnsnames.ora file.


Username: The default username for the oracle database is system.


Password: It is the password given by the user at the time of installing the oracle database.


Comments

Post a Comment

Thank you!

Popular posts from this blog

How to add Internet download manager extension in the Chrome browser

-
Image
Internet download manager  is an important tool to download youtube videos and also it improves the downloading speed. It is helpful to download any file over the internet with huge speed. Now I am going to show you how we can add an extension of the IDM in chrome. Actually, It is very simple to do. What we have to do is just copy a file and paste to the chrome. steps: 1. open the folder 2. On the other hand, open the Chrome browser and click on  three dots  on the right. 3. Look for the  more tools  and click on the  extension 4. Drag  IDMGCExt.crx  from the folder and drop to the extension of chrome. Now you are able to download youtube videos. Enjoy the downloading! If you liked it then please subscribe and share this article.
Read more

A Day in Noida: Learning Begins

-
Image
Today was my first day in Apex Pvt Ltd and I have learnt the basic elements of Java. These elements are given below: 1. What are the uses of println() and printf? Ans: println( )  prints a new blank line and then your message.  printf() provides string formatting similar to the printf function in C .  printf() is primarily needed when you need to print big strings to avoid string concatenation in println() which can be confusing at times (Although both can be used in almost all cases). Eg. int a = 10;int b = 20;  println("a: " + a + " b: " + b);      //Tedious String Concatenation printf("a: %d b: %d\n", a, b);     // Output using string formatting.  While printf() enables you to print fractional outputs up to any decimal place in a single line, the same task using println() can get very complex. 2. What is the use of Java? Ans: Java is a programming language that developers use to create applications on your computer. Chance
Read more

Python Deciding factor

-
Image
Decision making is anticipation of conditions occurring while execution of the program and specifying actions taken according to the conditions. Decision structures evaluate multiple expressions which produce TRUE or FALSE as outcome. You need to determine which action to take and which statements to execute if outcome is TRUE or FALSE otherwise. Following is the general form of a typical decision making structure found in most of the programming languages − Python programming language assumes any  non-zero  and  non-null  values as TRUE, and if it is either  zero  or  null , then it is assumed as FALSE value.
Read more