Friday, November 14, 2008
Making connections to Oracle lite Database
If you have done a basic installation of SOA Suite 10.1.3.3 or 10.1.3.4 version, it installs a default Olite database with orabpel, oraesb and orawsm schemas.
Here is the solution to connect to these schemas through sql/Jdev
Using msql, Mobile SQL Client ($ORACLE_HOME\Mobile\Sdk\BIN\msql.exe):
Conencting to orabpel schema:
>msql system/manager@jdbc:polite:orabpel
Conencting to oraesb schema:
>msql system/any@jdbc:polite:oraesb
Using Jdev
Making connections to Orabpel schema:
Connection Type: Olite DB
User id/ Password: system/ manager
Host name: localhost or your SOA server name
Port: 1531
Sid: orabpel
Making Conenctiosn to Oraesb schema:
Connection Type: Olite DB
User id/ Password: system/ any
Host name: localhost or your SOA server name
Port: 1531
Sid: oraesb
For ESB schema connection you to select the driver path located at SOA_HOME/Integration/esb/lib/olite40.jar. This has to be added to your class path
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment