File Adaptor and Database Adaptor

Reading a file using file adaptor and inserting into database using DB Adaptor

configuring Database Adaptor in Application server

Login to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
connection pools->
create Name - filedbconn
Connection Factory Class oracle.jdbc.pool.OracleDataSource
URL : jdbc:oracle:thin:@//localhost:1521/xe
Username : system
Password : oracle

creating Datasource connections

login in to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
Datasources->create ->select Manage Datasource -> continue

Application Name : default
JNDI Location : jdbc/localdbtest
Type : Manage Datasource
Connection Pool : filedbconn(select existing connection pool name)
Transaction Level : Global & Local Transactions
Name : LocalDBDatasource

configuring Database Adaptor

go to em console ->cluster toplogy->oc4j_soa->Applications->default ->DBAdaptor
Connection Factory Interface - javax.resource.cci.ConnectionFactory
JNDI Location - eis/apps/LocalDatabase
xADataSourceName - jdbc/localdbtest (is the name of JNDI Location in Datasource)

Create BPEL Process



select empty BPEL process



Configure file adaptor



Enter Service Name



select Readfile

Connecting to Oracle SOA Server 10g from Jdev 10g

Here I would like to show how to connect Jdeveloper to Oracle SOA Suite servers.
This includes connecting to Oracle XE Database, Oracle Application Server and Integration Server


1) Establish Connection from Jdeveloper to Oracle Database

Start Jdeveloper open the Connections Navigator tab, and double-click Database to launch the Create Database Connection wizard



Right click on Database Server and select New Connection a Connection wizard appears click next

Connection Name: DBDemoConn
Connection Type: Oracle (JDBC)



Click next and enter Database Username/Password system/welcome1



Click next and give Host Name, JDBC Port and SID



Click on Next, and Test Connection



2) Establish Connection from Jdeveloper to Application Server
Open the Connections Navigator tab, and double-click Application Server. Create Application Server Connection wizard appears



I have given Connection Name, Connection Type as SOA_Appserver, Oracle Application Server 10g 10.1.3



Click next and type Username/Password oc4jadmin/admin123

Specify Host Name, OPMN Port, oc4j Instance name
OPMN Port can be found from Runtime Ports in Application Server console






Click on Next, and Test Connection



3) Establish Connection from Jdeveloper to Integration Server (BPEL)
Open the Connections Navigator tab, and double-click Integration Server. Create Integration Server Connection wizard appears



I have given connection name as SOA_Intserver and click next



Once you select Application Server the details will be populated automatically in the Integration Server.



Click next and Test Connection the status of Application Server, BPEL, ESB Servers should be OK