File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC with oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC with oracle " Watch "JDBC with oracle " New topic
Author

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
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,
Ravissant
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,
Herman
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC with oracle
 
Similar Threads
Servlets&JDBC-CallableStatement
what is the output here..
Conversion
How to store a MessageDigest object in Oracle Database
DB connectivity with javascript?