Create a simple db adapter in 11g

I will be creating a simple db adpter in 11g which can be used to insert data in to a table.

I have uploaded the project in the following link

http://arpitrahi.wordpress.com/2009/09/22/hello-world/project1-3/#comment-2

You need to create connection pool and data source as i have already mentioned in my previous posts.

you will get a response page.It means your web service is tested.

Now go to sql and check if the data is inserted there or not.




then you need to create a table in database.

I have created a simple table

create table arpit(f_name char(20),l_name char(20));

then i will use db adapter to put some value in the table.

The result output will be like this



We need one more step in order to deploy this process.

Create a database connection.




























Now log in to em console.

choose the project.

Click on test button you will get a page like this.Provide the input and say

Test Web Service at the right bottom



Now check the result in the sqlplus



The same steps can be followed for aq adapter also simply by creating the queues in database.