Re: I need a picture of Java to Oracle <Latest> (my brain's not getting it)

In article <850ffd69.0106250915.12eb5362_at_posting.google.com>, chip_at_byhand.net says...
>
>Hi all -
>
>I don't think my brain just isn't getting the whole picture...
>
>If I write a Java app that is going to be talking to Oracle, is the
>only method of getting the Oracle server to do anything via SQL calls?
>
>Assuming that my Java App is on a laptop, and talking (I guess TCP/IP)
>to the Oracle Server, what processing/data access options do I have?
>

Here are a couple of options:

o jdbc THIN drivers -- requires only that you have the jar file on the client -- sqlnet is written in java in that variation.

o jdbc THICK drivers (requires you to install the Oracle client on the laptop and configure SQLNet.

o you could talk to a bean in the database using RMI over IIOP

o you could use RMI to talk to a java stored procedure

o you could talk HTTP to the Oracle servlet engine (OSE) in the database http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.817/a83720/toc.htm

o you could talk to an application server and have it talk to Oracle.

the first and last options are probably two of the most popular.

>The Oracle site seems to talk about a Java API to Oracle, but, inside
>how would my laptop app be getting the data? Is this API just a wrapper
>around SQL calls? Is there an "Included into my Laptop App" something
>that will allow me to create objects based upon rows of data stored at
>the server, or do I have to get the data, and then construct the Java
>objects myself?
>
>I guess my simple question is, "Is SQL the only data access method to
>Oracle that I've got?" (That works out of the box today)
>

no

>If there are any successes I would like to hear them (not from Oracle
>though, I have a hard time buying people blowing their own horns)
>
>Thanks in advance
>cg

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp