Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Will ESB work with OLite (DB adapter) that comes with SOA suite?

Kevin Li-Oracle
Member Posts: 10
I have managed to configure the toplink connection from the JPA/EJB 3.0 and ADF. The only thing that I need to do is changing the default setting to point to the data-source (e.g. jdbc/OracleDS) without the use of URL, (e.g. jdbc:[email protected]:1531:orabpel). I could not find the way to change that in ESB, so I am getting the usual error "No suitable driver".
You might argue that I should run it with OracleXE, or so. But I am trying to run the SOA suite + JDev + Olite (DB) on a laptop with 1GB memory. If I use the OracleXE, it will run very slowwwww.
Cheers,
Kevin
You might argue that I should run it with OracleXE, or so. But I am trying to run the SOA suite + JDev + Olite (DB) on a laptop with 1GB memory. If I use the OracleXE, it will run very slowwwww.
Cheers,
Kevin
Comments
-
I found the way of configuring the Database Adapter that can connect to the OLite DB.
1. Go to the directory <SOA_HOME>\j2ee\home\application-deployments\default\DbAdapter. Open the file oc4j-ra.xml.
2. Copy the following text:
<connector-factory location="eis/DB/FulfillmentESB" connector-name="Database Adapter">
<config-property name="xADataSourceName" value="jdbc/fulfillmentDS"/>
<config-property name="dataSourceName" value=""/>
<config-property name="platformClassName" value="oracle.toplink.platform.database.Oracle9Platform"/>
<config-property name="usesNativeSequencing" value="true"/>
<config-property name="sequencePreallocationSize" value="50"/>
<config-property name="defaultNChar" value="false"/>
<config-property name="usesBatchWriting" value="false"/>
<connection-pooling use="none">
</connection-pooling>
<security-config use="none">
</security-config>
</connector-factory>
3. Save the file
4. Go to EM, JDBC resource
5. Create the Connection Pool and Data Source (with the same name that you have provided in the oc4j-ra.xml)
6. Restart oc4j - home instance (or e.g. opmnctl stopall/startall)
Cheers,
Kevin
This discussion has been closed.