EJB design: How to use Oracle rather then Cloudscape
- Posted by: Bhagawan Das ak
- Posted on: September 19 2004 14:58 EDT
can u pl. tell me how to use oracle 8i in Beans(CMP) as DataBase rather Cloudscape DB
dear friends, can u pl. tell me how to use oracle 8i in Beans(CMP) as DataBase rather Cloudscape DBthankQ-dasWell first you need to create the DB pool using the web-based admin interface. If you have already installed the app server and started it then you should have access to your local app server using port 4848:
Then you should configure you database connection and pool through that interface. You also need to declare the connection in your ejb-jar.xml and the sun-ejb-jar.xml.
This process requires that you know how to work with the app server. Refer to the on-line documentation to learn more as how to create you connection pools and using them in your applications.
mr/Mrs Rasoul Hajikhani ,
Can u explain in detail
It depends what J2EE container you are using ?
1) First define a DataSource ( connection pool) for Oracle database
For example, if you are using OC4J, you have to create the DataSources as follows:
2) Then specify the JNDI location for the DataSource in your vendor deployment descriptor of your entity bean to use that datasource e.g.
<entity-deployment name="EmployeeBean" max-tx-retries="0" location="cmpapp/EmployeeBean" table="EMP" data-synchronization- data-source="jdbc/OracleDS" >
Hope this helps ..