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 Novice to jdbc 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 "Novice to jdbc" Watch "Novice to jdbc" New topic

Novice to jdbc

Inder Kumar Rathore
Ranch Hand

Joined: Apr 14, 2010
Posts: 41
Hi, I want to connect oracle 10g using jdbc, I don't know how to do it. I have connected MS access. In that i have created dsn.
In case of oracle is there some thing to do with dsn.???


Living is easy with your eyes closed.....
dipayan chatterjee
Ranch Hand

Joined: Oct 03, 2007
Posts: 47
Hi Inder
Well i too have very little knowledge as far as jdbc is concerned but i am using 10g too for my backend purpose .Well you can set up a dns for oracle just like you did for access but i would recommend you to go for the Type 4 driver than an ODBC bridge as Type 4 are much faster. take a look here

hope it helps

Inder Kumar Rathore
Ranch Hand

Joined: Apr 14, 2010
Posts: 41
Thanks...It will surely help me...
After connecting I'll reply back...
I agree. Here's the link:
subject: Novice to jdbc
It's not a secret anymore!