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

No comments: