File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC with oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC with oracle " Watch "JDBC with oracle " New topic

JDBC with oracle

Ravissant Markenday
Ranch Hand

Joined: Nov 12, 2006
Posts: 47
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 Markenday
Ranch Hand

Joined: Nov 12, 2006
Posts: 47
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 "jdbcracle: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,
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
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: jdbcdbc: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,
I agree. Here's the link:
subject: JDBC with oracle
It's not a secret anymore!