hello guys,
i want to connect to an oracle 8i database through jdbc. i have jdk1.4 version and iam using the ojdbc14.jar driver for that.

firtly, i want to know if i ca do this (cosidering the oracle8i and jdk1.4 versions go together?)

secondly, if it is possible what url sould i use in the DriverManager.connection();

thanks and regds
venki

http://www.javamug.org/mainpages/J2EE.html

Gokulan Ethiraj

http://servlet.java.sun.com/products/jdbc/drivers

http://java.sun.com/developer/online...dbcrowsets.pdf

Gokulan Ethiraj

Well yes they SHOULD BE COMPATIBLE.
There are two ways by which you can do this.

1. Use the tnsnames file in the Oracle/network/admin folder to get all the access reqd information and use the following form:
Class.forName("sun.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:thin:@host: port:database name","username","password");
The data of host(or ip),port,database name and username will be in the tnsnames file.



2. Second Form: This is a general (default) way
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection Con=DriverManager.getConnection "jdbc:odbc:driver","username","password");


Hope it helps.


Sandz

i think u have to wrtie this for load drvier
Class.forName("oracle.jdbc.driver.OracleDriver");

And for getting connection object u have write this
conn = DriverManager.getConnection("jdbc:oracle:thin:@ipa ddress:port:dbname","username", "passwd.");

here
ipaddress may any ip like = 192.9.456.36
port = 1234

may this is helpful to u.

Hi
Even i have the same problem while connecting with Oracle database..Im developing a Knowledge Base as my final sem MCA project..I'm using Oracle 9i as database..the error message what i encounter is Dtabase driver not found..
Java.lang.ClassNotFoundException: Oracle.jdbc.driver.OracleDriver

Do i need to set and classpath, if yes! to which file should i set the path..
Pls help me on this..



B.Swaminathan
Mobile:+91 9886510453