• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Names of JDBC drivers

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
- What are the names (and description) of the 4 JDBC drivers?
- What are the types of statements (ex. PreparedStatement)?
thanks in advance..
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The glib answer is type 1, 2 3 and 4. You'll find more useful info here.

The JavaDocs define what kinds of Statements there are - its always quickest if you look there first: Statement, CallableStatement and PreparedStatement.
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to JDBC forum...
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by vgs lemu:
What are the names (and description) of the 4 JDBC drivers?



Paul has already answered

Originally posted by vgs lemu:
What are the types of statements (ex. PreparedStatement)?



There are three types of statements
  • Statement

  • The use of a Statement in JDBC should be 100% localized to being used for DDL (ALTER, CREATE, GRANT, etc) as these are the only statement types that cannot accept BIND VARIABLES.
  • PreparedStatement

  • PreparedStatements should be used for EVERY OTHER type of statement (DML, Queries). As these are the statement types that accept bind variables.

    This is a fact, a rule, a law -- use prepared statements EVERYWHERE. Use
    STATEMENTS almost no where.
  • CallableStatements

  • This is used to call Stored Procedure ,functions etc.


    Shailesh
     
    Ranch Hand
    Posts: 817
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    what are bind variables ???

    and you mean to say that we use "statement"
    for only DDL
    and not for DML ?

    why...


    and give me the link to learn which teach in simple words how to use Preparied statements...

    guys tommorow is my technical interview test...so please answer quickly...

    i would be gr8full to you all...
    its a secnond round...
    so pls answer ...

    regards,
     
    Ranch Hand
    Posts: 15304
    6
    Mac OS X IntelliJ IDE Chrome
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    You have a tech interview over this stuff tomorrow and you don't know it yet? I hope your interviewer doesn't frequent Javaranch. No, wait, I take that back. I hope he/she does. :roll:
     
    amit taneja
    Ranch Hand
    Posts: 817
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    pls answer ..i m delibrately waiting for response..
     
    author & internet detective
    Posts: 41860
    908
    Eclipse IDE VI Editor Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Amit,
    Sun's JDBC tutorial is an excellent place to start. You can learn the basics of JDBC that way. The details, of course, can only be learned by doing. As Greg implied, the interviewer may pick up on this.
     
    There’s no place like 127.0.0.1. But I'll always remember this tiny ad:
    a bit of art, as a gift, the permaculture playing cards
    https://gardener-gift.com
    reply
      Bookmark Topic Watch Topic
    • New Topic