Wrox Home  
Search P2P Archive for: Go

  Return to Index  

j2ee thread: How to use Oracle8i driver?


Message #1 by Edward <zhangsc@n...> on Tue, 28 May 2002 09:45:35 +0800
  url="jdbc:oracle:thin:@192.168.4.33:port:sid";
>Hello everyone:
> 
> I have a question about Oracle8i Database,I want to use JDBC to connecte Oracle8i,but I don't know how to use Oracle driver
program,My os is windows2000 profession,my jdk is 1.3.1,and my j2ee is 1.3.1 (it includes Oracle8i driver? If not,where can I found
Oracle8i driver),my computer's IP is 192.168.3.38,and Oracles server is at IP 192.168.4.33 .In my computer I have installed Oracle8i
Client.My Oracle client configure is follows:
>
>username:test
>password:system
>host string:eino
>
>I want to know how to visit a table at oracle server from my computer using JDBC (two different computer)???
>I want to do my program like follows:
>
>
>import java.sql.Driver;
>import java.sql.DriverManager;
>import java.sql.Connection;
>import java.sql.DatabaseMetaData;
>import java.sql.SQLException;
>import java.sql.DriverPropertyInfo;
>import java.util.Enumeration;
>import java.util.Properties;
>public class IdentityDAO
>{
> public static void main(String args[])
> {
>  String driverClass="oracle.jdbc.driver.OracleDriver";
>  String url=??? //How to write ?
>  Connection connection;
>  try
>  {
>   Class.forName(driverClass);
>  }
>  catch(ClassNotFoundException e)
>  {
>   e.printStackTrace();
>  }
>  connection=DriverManager.getConnection(url+"Movies;create=true"); //How to write??
>  statement.excuteUpdate("CREATE TABLE CATALOG"+("TITLE VARCHAR(256) PRIMARY KEY NOT NULL,RELEASE_DATA DATA NOT NULL);  
>  System.out.println("ok");
> }
>}
>
>I compile my program like follows:
>F:\>javac IdentityDAO.java
>It raises errors:
>java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>        at java.net.URLClassLoader$1.run(Unknown Source)
>        at java.security.AccessController.doPrivileged(Native Method)
>        at java.net.URLClassLoader.findClass(Unknown Source)
>        at java.lang.ClassLoader.loadClass(Unknown Source)
>        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
>        at java.lang.ClassLoader.loadClass(Unknown Source)
>        at java.lang.ClassLoader.loadClassInternal(Unknown Source)
>        at java.lang.Class.forName0(Native Method)
>        at java.lang.Class.forName(Unknown Source)
>        at IdentityDAO.main(IdentityDAO.java:16)
>
>I don't know what the detailed steps are,I am a newbie of JAVA,please give me more detailed steps to connecte Oracle8i.
>Any idea will be appreciated!
>Thanks in advances!!!
>Edward
>



  Return to Index