EJB3 on Oracle

[kkangsar]

Hi All,

I am new in Java technology and Jboss. Currently, I am trying to working on EJB3, JPA on Oracle DB, But I have no clue how to configure to make it work?

Anyone can give me some helpful website or guide me how to save the data into Oracle database?

Thanks in advance.

[jaikiran]

Are you looking specifically for Oracle DB or are you looking for tutorials around JPA Entities in EJB3? For the latter, you can refer this http://www.jboss.org/jbossejb3/docs/. You can download the tutorial from that location. The download will include a guide as well. If you want to see the online guide for working with entities, then its here:

http://www.jboss.org/file-access/default/members/jbossejb3/freezone/docs/tutorial/1.0.0/html/EJB3_Entities.html

Making this work for Oracle DB is as simple as

1) changing one config file (persistence.xml)
2) Creating the oracle datasource http://www.jboss.org/community/docs/DOC-9328
3) Adding the oracle jdbc driver jar file to %JBOSS_HOME%/server/< serverName>/lib folder.

[kkangsar]

Thanks for your fast response.

I have configured the persistence.xml as below:


<persistence-unit name="examplePersistenceUnit">
<jta-data-source>java:/OracleDS</jta-data-source>
</persistence-unit>


and created Oracle database source (oracle-ds.xml) in deployed folder.

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml 23720 2004-09-15 14:37:40Z loubyansky $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->



<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:wm</connection-url>
<!--

Here are a couple of the possible OCI configurations.
For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

Clearly, its better to have TNS set up properly.
-->
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>wm</user-name>
wm
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>Oracle9i</type-mapping>

</local-tx-datasource>



Is it enough to link to oracle database?

[kkangsar]

Yes, I can connect to Oracle DB after defined the persistence.xml and data source file (oracle-ds.xml).

But how can i save the data to the db? can someone give me a sample to save to database?