Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

jdbc and sql

  Asked By: Maddison    Date: Feb 04    Category: Java    Views: 758

I'm trying to get my java application to interact with my access
database using jdbc and sql. Now the problem is that I can't seem to
find the right sql Driver to do it. Can someone please supply me the
name of the driver?



15 Answers Found

Answer #1    Answered By: Dominic Murphy     Answered On: Feb 04

You can do this by JDBC-ODBC driver.
Create System DSN through ODBC driver  and get connect this DSN through your
java code then you can access your database easily
for more information www.developeriq.com/java/tutorials/chap7.php3

Answer #2    Answered By: Jeffrey Washington     Answered On: Feb 04

You can use JDBC-ODBC, if your are working on Windows.
Just go to Settings->Control panel->ODBC driver->add a
new DSN.

Then use the DSN to connect to your Access database.

Answer #3    Answered By: Alexander Bouchard     Answered On: Feb 04

i want to learn about jdbc.can anyone suggest me some online and offline
tutorial for that.

Answer #4    Answered By: Erika Evans     Answered On: Feb 04

Yeah theres a lot of documentation out there about it. I dont know of an exact
tutorial, but if you look in the jdbc  package theres a readme file and some
examples. All you need to know really is a bit of SQL.

Answer #5    Answered By: Jermaine Powell     Answered On: Feb 04

this link will provide you the information.

Answer #6    Answered By: Frank Butler     Answered On: Feb 04

My first intro to JDBC programming was via
http://pdf.coreservlets.com/, a free online PDF book. Not the
greatest JDBC coverage, but it was good enough to learn from. Now as
for installing it and getting it to work, that was another headache,
pouring over and over the Tomcat docs.

Answer #7    Answered By: Francis Riley     Answered On: Feb 04

www.java.sun.com is the storehouse.. learn from the masters!

Answer #8    Answered By: Alan Palmer     Answered On: Feb 04

Hey i want inforamtion abt java  databased
s/w packages.can u tell the databeased s/w used to
connected the jdbc. and can we connected open office
databased using jdbc  not odbc.

Answer #9    Answered By: Guadalupe Rogers     Answered On: Feb 04

Have you had a look at http://developers.sun.com/product/jdbc/drivers? This
will help you locate the drivers :)

Answer #10    Answered By: Gustavo Taylor     Answered On: Feb 04

what is the use of Class.forname();in jdbd

i need clear explination...

Answer #11    Answered By: Velma Adams     Answered On: Feb 04

with this line of code (Class.forName()) you are register a driver  by loading
its class.

Answer #12    Answered By: Wilbur Hall     Answered On: Feb 04
Answer #13    Answered By: Chione Massri     Answered On: Feb 04

can any tell about jdbc  ..??

how do we recognize the connection string is compatible with our driver  type..

if we arre using classes12.jar how can i know that which type of driver this
is and which type of connection string i may have to use ??

Answer #14    Answered By: Casey Montgomery     Answered On: Feb 04

To begin connecting to a data source, you first need to instantiate
an object of your jdbc  driver. This essentially requires only one
line of code, a command to the DriverManager, telling the Java
Virtual Machine to load the bytecode of your driver  into memory,
where its methods will be available to your program. The String
parameter below is the fully qualified class name of the driver you
are using for your platform combination:


Type of driver: JDBC-ODBC Bridge, Native-API, JDBC-Net, Native
jdbc-odbc bridge :two step process.In client side we must install
Native-API:This is accessed via the Java Native Interface (JNI).
JDBC-Net :Three tiers connection required
Native Protocol : Every databse required own database.This is costly

Answer #15    Answered By: Jonathan Brown     Answered On: Feb 04

But how do we know we have to use this type of driver.... If we are
connectingwith oracle
1)how do we become to know that we have to use type 2,or 3 or4 driver...??

2)And how do we able to get the connection string compatible to that driver  ??

3)In which situation we have to use which type of driver ..??

Didn't find what you were looking for? Find more on jdbc and sql Or get search suggestion and latest updates.