jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes JDBC Driver for Oracle 10g? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Driver for Oracle 10g?" Watch "JDBC Driver for Oracle 10g?" New topic
Author

JDBC Driver for Oracle 10g?

Jignesh Gohel
Ranch Hand

Joined: Dec 28, 2004
Posts: 276
Hi,

Currently we have our backend as Oracle 8i used with our web application.But now i want to switch to Oracle 10g.So for that do i have to change the current jdbc drivers & if yes where can i find it?? .Also tell me the conectionURL & driver name.Currently my configuration is :

DRIVER = oracle.jdbc.driver.OracleDriver
CONNECTIONURL = jdbcracle:thin:@oracle_server_ip:schema_name

On more thing : Does thing switching will have any impact in comparison to the current situation???


Regards,
Jignesh

The Art Of Life Is To Know When To Be Useless And When To Be Useful - CHUANG TZU
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Drivers and JavaDocs for Oracle JDBC extensions and implementations
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Sample code
http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/index.html

JDBC Developers Guide (10g release 2)
http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/toc.htm

FAQs
(older) http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html
(newer) http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm
How-Tos
http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/index.html




Does thing switching will have any impact in comparison to the current situation???

Maybe.
Jignesh Gohel
Ranch Hand

Joined: Dec 28, 2004
Posts: 276
Hi,

I have installed the 10g version on my machine & fired the scripts which were existing in the Oracle8i version.The driver which i have downloaded has the name ojdbc14.jar as i have jdk 1.4 version.Now Can u please tell me the Connection URL,DriverName for the same.I used:

Driver = oracle.jdbc.driver.OracleDriver
URL = jdbcracle:thin:@IP:port:dbName.

Now i fired the scripts but i dont know the database name so i ignored it in the URL..Please tell me how can i know the database name.I get all the results successfully for my queries on the tables.

But i am getting some exception like "The Network adapter ..." error which is thrown if i use the HTTP port 8080.Now if i use 1512(forgive if its wrong) port number that is the Database listener port it is also throwing some exception.

So can somebody please give me the code snippet for the same.

I have Tomcat 4.1 version,jdk 1.4.
Similarly i also need the code snippet for jdk1.3 in that case i think only the jar file will change that is classes12.jar and not the code right(correct me if am wrong)
 
jQuery in Action, 2nd edition
 
subject: JDBC Driver for Oracle 10g?