SOA Database Adapter experiment

Hey, Here I am going to create a Database user which can be used for demonstrate the database adapter.

 grant connect, resource to soademo identified by soademo;

create a table

 CREATE TABLE CREDITCARDINFO
(
SSN VARCHAR2(15) NOT NULL,
FIRST_NAME VARCHAR2(30),
LAST_NAME VARCHAR2(30),
CCNUMBER VARCHAR2(20) NOT NULL,
CREDITRATING NUMBER,
STATUS VARCHAR2(20) NOT NULL
);

create a Table using XE Apex tool

Insert records in to table
Now, lets do insert operation on the table that was created following records for testing purpose

 insert into CREDITCARDINFO VALUES (
    '111-11-1111',
    'Neena',
    'Kochhar',
    '1234-1234-1234-1234',
 '3'
 , 'VALID'
);

insert into CREDITCARDINFO VALUES (
    '222-22-2222',
    'Steven',
    'King',
    '5678-5678-5678-5678',
 '4'
 , 'VALID'
);

insert into CREDITCARDINFO VALUES (
    '333-33-3333',
    'Lex',
    'Devarakonda',
    '4321-4321-4321-4321',
 '5'
 , 'INVALID'
);

insert into CREDITCARDINFO VALUES (
    '444-44-4444',
    'Alexander',
    'Hunold',
    '8765-8765-8765-8765',
 '1'
 , 'VALID'
);

Now lets create a datasource that uses above created schema that is soademo.