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.

[Quoted] 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