Re: Java-JDBC-Oracle

Hi,
there should be absolutly no problem with netscape or ie5 in this respect.

I also use the mac, if you have the codewarrior dev pack, then open a new project, select java 1.1 then select applet. this will build the code as an applet and also generate a html page you can use to call it from a browser.

the only problem i have seen, is that you have to ensure that you use exactly the right jdbc thin drivers for the right database version. steve

Marco <haandm_at_hotmail.com> wrote:

> Hai Davis,
>
> You really helped me with this one......I managed my applet to connect
> to my Oracle database using the Appletviewer.....NOT with
> IE5.5......can you help me with that one as well?
> Am I missing something here what makes my applet not work in IE?
>
> Hope you can help me on this one as well!?!
>
> Thanks anyway!
>
> Best regards,
>
> Marco
>
> On 20 Nov 2001 11:07:56 -0800, davis_swan_at_compuserve.com (Davis Swan)
> wrote:
>
> >"OP" <
> >> I'd like to connect to Oracle database from Java-applet.
> >> Can anybody help me?
> >>
> >> Thanks in advance,
> >> Oleh
> >
> >The following is an abstract from my Web page at
> >http://ourworld.compuseve.com/homepages/davis_swan/macjava.html
> >
> >Although some of the information on that page is Mac specific, the
> >examples have all been compiled under Windows '95 as well.
> >========================================================
> >Connecting to an Oracle Database with JDBC
> >
> >First, you will need to download the JDBC "thin" drivers from the
> >Oracle Technet site (the advantage fo the thin drivers is that they
> >are not platform specific). Registration at the site is free but
> >downloads are to be used for non-commercial, evaluation purposes only.
> >
> >Finding the driver is a bit tricky since Oracle does not refer to Mac
> >OS explicitly anywhere. However, the page
> >
> >http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
> >
> >refers to "Version 8.0.5.2 JDBC(Thin and OCI) for Solaris" which is
> >what you want. Clicking on this link and agreeing that you
> >meet the "ELIGIBILITY EXPORT RESTRICTIONS" will take you to a page
> >listing numerous versions of the Oracle JDBC drivers. I chose to
> >download the "JDBC-Thin, 100% Java ( 1.7MB)" driver.
> >
> >Note: I was not able to use Netscape to download this file. However,
> >by using IE 5, holding the mouse button down over the link, and
> >choosing "Save this Link to Disk" I was able to get the file
> >classes111.zip onto my desktop. You will want to copy this file into
> >the development area where you are storing your own class files.
> >
> >You will need to have a remote Oracle database up and running,
> >complete with a Listener process, before you can build your test
> >application. I installed Personal Oracle 8 on a Windows '95 machine.
> >Apart from having to configure the Listener and enabling two-phase
> >commits, the installation was very straightforward.
> >
> >The following example code will create a connection to a remote Oracle
> >database and display the results of a query;
> >
> >/ *
> > * This example Applet connects to an Oracle database via the Oracle
> >thin
> > * JDBC drivers and prints a value selected from the database.
> > * Assuming that the Oracle database is running on a remote sever,
> >this applet will only
> > * work if you use File -> Open -> Page in Navigator in Netscape, or
> >File -> Open File in
> > * Internet Explorer. This applet can NOT be served up as an HTTP
> >page because of security
> > * contraints on served applets.
> > */
> >import java.sql.*;
> >import java.text.*;
> >import java.applet.Applet;
> >import java.awt.*;
> >import java.awt.Graphics;
> >
> >public class JDBCTestApplet extends Applet {
> > TextArea msgArea = new TextArea(20,20);
> >//
> >// The methods init, start, stop, and destroy are all methods of the
> >applet class
> >//
> > public void init() {
> >//
> >// Add the text area to the default container
> >//
> > setLayout(new GridLayout(1,1));
> > add(msgArea);
> > }
> >
> > public void start() {
> > outputTextLine("Starting the Applet ...");
> >//
> >// Load the Oracle JDBC driver
> >//
> > try
> > { DriverManager.registerDriver(new
> >oracle.jdbc.driver.OracleDriver());
> >//
> >// Set connection information
> >// REPLACE THE USER, PASSWORD, IP ADDRESS, AND INSTANCE WITH
> >ONES
> >// APPROPRIATE FOR YOUR ORACLE ENVIRONMENT
> >//
> > String user = new String("Scott");
> > String password = new String("Tiger");
> > String database = new String ("192.168.111.222:1521:ORCL"
> >);
> > String msg = new String("Connecting to " + database + "\n"
> > + "The following line(s) will be the result
> >of the query ... please wait\n"
> > +
> >"------------------------------------------------------------------------");
> > outputTextLine(msg);
> > Connection conn = DriverManager.getConnection
> >("jdbc:oracle:thin:@"
> > + database, user, password);
> > Statement stmt = conn.createStatement ();
> >//
> >// Get a set of rows from the database
> >// REPLACE THIS QUERY WITH ONE APPROPRIATE FOR YOUR DATABASE
> >//
> > ResultSet rset = stmt.executeQuery ("select ENAME from EMP
> >");
> > while (rset.next ())
> > {
> > outputTextLine(rset.getString (1));
> > }
> > conn.close();
> > } catch (SQLException ex ) {
> > outputTextLine(ex.getMessage());
> > }
> > }
> > public void outputTextLine(String outputString) {
> > msgArea.appendText(outputString + "\n");
> > repaint();
> > }
> >}
> >
> >Compile this program using javac, remembering to add the file
> >classes111.zip to your CLASSPATH. You will probably get a warning
> >message which can be ignored. Open SimpleText and type in the
> >following;
> >
> ><title>JDBC Test Applet</title>
> >You should a report below
> ><hr>
> ><applet code="JDBCTestApplet.class" ARCHIVE="classes111.zip" width=375
> >height=50
> >alt="If you see this message, your Browser can't run the applet">
> ><param name=text value="I really love Java">
> >If you see this message, your Browser doesn't understand the APPLET
> >tag.
> ></applet>
> >
> >Save this file with the name JDBCTestApplet.html in the same folder as
> >the files JDBCTestApplet.class and classes111.zip. You should now be
> >able to use File -> Open from either Netscape or IE to run this applet
> >and see the results of your query.
> >
> >Congratulations ! You have now built and run a JDBC application
> >accessing a remote Oracle database.
Received on Tue Nov 27 2001 - 15:22:23 CST