2 Replies Latest reply: Apr 24, 2007 3:53 AM by 807606 RSS

    How to connect to oracle database?

    807606
      I am writing a java application. I installed oracle database 10g express edition. I want to connect my java application to it.

      I read some information from oracle but still can't get it.It said:

      # Thin Driver, a 100% Java driver for client-side use without an Oracle installation, particularly with applets. The Thin driver type is thin. To connect user scott with password tiger to a database with SID (system identifier) orcl through port 1521 of host myhost, using the Thin driver, you would write :

      Connection conn = DriverManager.getConnection
      ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");

      I don't even know my SID , port & host.
      How to get them?
      I spent more than 8 hours to figure it out but now still nothing comes out. Plz help.