Win a copy of Hello World this week in the Python forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

JDBC with oracle

 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Everyone! could anyone please tell me how i can do database connectivity using the oracle database.
Following is the code i wrote but the table "rosm" just does'nt get updated



thanks a lot in advance,
Ravissant
 
Ravissant Markenday
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi again, well i figured it out by myself,but then again i have some doubts.I found 2 approaches of which i could get only one working.
First, the approach i could'nt get, im including only the code snippents i did'nt understant:



could anyone please descriptively tell me what "jdbc:oracle:thin:@training:1521:Oracle" is?

Moving on to the second approach:



could anyone please tell me what the DSN exactly does?
Also I'd really appreciate it if someone could tell me the exact difference between the two approaches.

Thanks a lot,
Ravissant
 
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Ravissant,

first question: jdbcracle:thin:@training:1521:Oracle is the URL of your database.
jdbc = connection type
oracle = your database
thin = drivertype
training = machinename
1521 = portnumber
Oracle = databasename

second question: jdbc:odbc:Mydsn_oracle
Mydsn_oracle is the name of your ODBC-datasource
(should be somewhere in settings - control panel - administrative tools)

third question: difference between those two:
The first tries to connect to the database using the Oracle driver, the second one uses the JDBC-ODBC bridge as driver (not meant for production-code)

Hope this helps,
Herman
 
Wink, wink, nudge, nudge, say no more, it's a tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!