• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Java to Oracle Database Connection using Pure Driver

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, pls help me out
how do u connect to Oracle8 database using oracle pure driver
ive been connecting using JDBC-ODBC drivers for my project work
now they wanna use pure drivers pls help me as soon as possible
I use the code like this
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection
("jdbc dbc:iview","scott","tiger");
hoe should i change the code
 
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You must create ODBC DSN iview
Control Panel->ODBC
 
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
First get the proper Oracle drivers and stick it in your classpath. I'm sure there are instructions on how to connect.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi Ran,
As a first step have some pure-oracle driver at your place. I use oracle_thin_driver. For that, the code something goes like that:
class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc racle:thin:@192.26.32.51:1521","user-name","password");
url is "jdbc racle:thin:@<where driver is located> ortNO".
I hope this will solve your problem. Good Luck!!!
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
you may or may not be surprised that Oracle has extensive online tutorials and the best JDBC documentation I've seen. You can find everything you need to start with Oracle/JDBC at the Oracle9i JDBC Developer's Guide and Reference site. ( you need to register for an Oracle site username and password )
Jamie
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
HI,
I am using WSAD5.0 and Oracle9i in Windows XP OS.
I am just trying to get the data from EMP Table from a servlet.I have included c:\oracljdbc\lib\classes12.jar in my project-->properties-->buildpath-->
Its giving the following error
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverno result
I think there is some problem with class path.
Could you please tell me what i need to do for fixing this error?
Thanks alot
Srini
 
srinivasa reddy
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
HI,
I am using WSAD5.0 and Oracle9i in Windows XP OS.
I am just trying to get the data from EMP Table from a servlet.I have included c:\oracljdbc\lib\classes12.jar in my project-->properties-->buildpath-->
Its giving the following error
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverno result
I think there is some problem with class path.
Could you please tell me what i need to do for fixing this error?
Thanks alot
Srini
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic