Java ADF connecting to a Data Base

When you open Oracle JDeveloper Studio you will be prompted to the following screen

Select Connect to a Data Base












Select 'Create a Data Base Connection'
Give a name to your connection
Select the connection  type you use. Here we are using a MySql Data Base
Type the username and the password and give the Data Base name. Then
test the connection and press 'Ok' , if the connection is unsuccessful
check the username, password and the Data Base name 
Click the not started button and change it to 'Done'

Comments

Post a Comment

Popular posts from this blog

Getting started with MySQL using wamp server

After installing the wamp server on your computer follow the below steps. Step 1 : Run the command prompt.  Step 2 : Copy the path of the bin folder of the wamp server. usually it is, C:\wamp64\bin\mysql\mysql5.7.19\bin Step 3 : Go back to the command prompt and change the directory to the path you copied C:\Users\admin>cd C:\wamp64\bin\mysql\mysql5.7.19\bin Step 4 : Then type the command "mysql -u root -p", then press enter. C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -u root -p Step 5 : Then it will request the password, just enter because there isn't a password. Enter password: Step 6 : If you have successfully connected following message will be prompted. Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and
Read more

Java ADF surfing through pages using buttons

Image
Open 'Oracle JDeveloper Studio' by double clicking on the icon. Select Studio Developer (All Features) and press 'Ok'.  Press 'Finish' We need to create a folder before creating page fragments. Select from gallery Add a folder name and press 'Ok'.  Then create page fragments. Here we are studying the connection between two pages therefore we need to create two page fragments. Change the file name and press 'Ok'. At the components panel search 'panel box' then drag and drop a panel box onto the page fragment.  Then drag and drop a button from the panel 'General Controls'. You can change the names of the button and the panel box at the 'Common' tab. Then go to page flow in web content (in Applications tab) and create a ADF Task Flow.
Read more

SQL vs ORM

Creating a table In SQL the table can be created using the CREATE TABLE command CREATE TABLE people( name VARCHAR(30), NIC VARCHAR(10) PRIMARY KEY, phone VARCHAR(20) ); In ORM we can create types and use them to create a table. Object Type syntax CREATE TYPE <object_type_name> AS OBJECT( <attribute1> <datatype>, <attribute2> <datatype> ); First, we have to create a type as an object using the CREATE TYPE command CREATE TYPE person AS OBJECT( name VARCHAR(30), phone VARCHAR(20) ); Then we can create the table using the above type CREATE TABLE person_table OF person( NIC PRIMARY KEY ); Inserting data into a table We can insert data in two ways Method 1 Without specifying the object name INSERT INTO person_table VALUES(101, 'John', 'Smith', 'jsmith@example.com', '1-650-555-0135'); Method 2 Using the object name INSERT INTO person_table VALUES(person(101, 'John', 'Smith', &#
Read more