Sujatha Ranganathan

Have a look at the LOB Datatype Sample on OTN for ideas.
Hope this helps.

Hi,
You cannot use Blobs directly as fields in CMP EJB, since Blob is really an open cursor to the database, and it is not serializable.
Here's a How-to on using Blobs
http://otn.oracle.com/tech/java/oc4j/904/content_preview.html
You can see the code for this at the end of the page
http://otn.oracle.com/tech/java/oc4j/904/how_to/how-to-ejb-cmpblob.zip
Hope this helps,
Sujatha.
http://otn.oracle.com/sample_code/content.html

Hi,
Have a look at the JDBC Page on OTN.
This has links to documentation, sample code and JDBC driver downloads.
Hope this helps.
Sujatha.

For details on connecting to Oracle Database through JDBC refer to this documentation
You will find JDBC Samples here
Hopt this helps.

You will find lot of sample code that demonstrate invoking stored procedures from JDBC here

Refer to this sample to know more about the Scrollable ResultSet functionality - http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/jdbc20/jdbc20.htm

Hi,
Oracle9i JDeveloper IDE provides full lifecycle support for framework-based development using Struts and BC4J. There are a couple of sample applications developed using Oracle JDeveloper.
Documentation : http://otn.oracle.com/products/jdev/htdocs/jdevcategory.html#J2EE
Samples (refer to BC4J Section): http://otn.oracle.com/sample_code/products/jdev/content.html
Hope this helps.
Sujatha.
http://otn.oracle.com/sample_code/content.html

Hi,
The idea of using CMR is that the EJB container manages the relationship for you and you dont have to explicitly manage the consistency between the two entities.
For more information on CMR refer to this tutorial.
Hope this helps.
Sujatha.
OTN Sample Code

You may want to have a look at the LOB Datatype Sample on OTN
Sujatha.
Oracle Technology NetworkOracle Technology Network

Hi,
Here is a complete and basic tutorial on ejb ql -
http://otn.oracle.com/sample_code/tutorials/fbs/eql/toc.htm
Sujatha.

Hi Srikanth,
You will find documentation on Oracle Ref Cursor hereOracle JDBC Developer's Guide
Sujatha.
http://otn.oracle.com/sample_code

Hi,
You may want to have a look at the JDBC & SQLJ documentation on OTN
JDBC - http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
SQLJ - http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96655/toc.htm
JDBC & SQLJ Sample code available at http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/content.html
Sujatha.