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

Not quite sure what you are asking ...

If you want to know how to get >data< interaction between an Oracle database (or any other 'industrial' database) and your Java app running on a laptop, the primary & recommended way is to use a SQL API. The possibilities include JDBC and SQLJ. Both are industry standard APIs and are explained at http://technet.oracle.com/tech/java/sqlj_jdbc/

Other methods for interacting for interacting with the JVM inside the database include XML, JSP, CORBA, EJB, etc. but most fall back on JDBC and/or SQLJ for >actual interaction with database objects<. Recommended page to start looking at this is
http://technet.oracle.com/tech/content.html

Oracle does provide a few things to help you out including (but not limited to): JDeveloper is their Java IDE and it has a number of enhancements & wizards to try to make life a lot simpler for various types of operations; and BC4J (Business Components for Java) provides a framework for creating and using 'business components' that require database interactions.

Oracle database built-in capabilities also minimize or eliminate special custom Java code; intermedia is included in the database and handles virtually all multimedia interactions as well as text indexing and text searches a lot easier than custom Java code; spatial option simplifies interaction with polygon and spatial coordinate manipulation, management and searching; iFS does a fair bit of standard document management while making the database look like a NFS disk (or network drive in Microsoft environment). However, most of these use some form of SQL API (again JDBC or SQLJ) as the Java interface.

And since the Oracle9i Application Server includes a report and ad-hoc query capabaility, that can eliminate or minimize Java for information distribution.

As for successes, yes there are quite a number, but you don't want to hear about them from me ...

HTH
/Hans

cg wrote:

> 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?
>
> 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)
>
> 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
  Received on Sat Jul 21 2001 - 23:16:15 CEST