wood burning stoves
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: http://aspose.com/file-tools
subject: JDBC with oracle
It's not a secret anymore!