• 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:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

driver

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I'm a new in java database.
does JDBC always related to ODBC, ie. we need to setup ODBC in control panel first?
what is if I want to use less connection DSN?
Microsoft also release JDBC beta 2 recently (if I'm not wrong). is it the best if we use SQL Server?
in term of portability, is it better we stick with "basic" Java JDBC-ODBC?? What about webLogic driver?
thanks all
anthony
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
JDBC is a common way to define Database operations in Java, allowing you to abstract the database operations from a specific vendor.
There for in theory you write the same code for any database you plug into your program, and you should be able to swap databases without too much trouble. (in theory)
ODBC is the MS way of providing a standard interface to databases. There is a specific driver called the 'Type-1 driver' or JDBC-ODBC bridge that provides a mapping between JDBC calls and the associated ODBC calls.
Consider this: you install a database, ithas ODBC drivers, and this is what you use to register as an ODBC source in MS-land. Now you can use the ODBC data to talk to your database. It is also possible at this stage to get the JDBC-ODBC bridge to talk to ODBC, then you can talk JDBC to the bridge.
Or you can find the specific JDBC driver for the database and make your calls to that...
At this point we should introduce the different types of JDBC drivers (more info here)
They range from:
Type 1 is the JDBC-ODC bridge as already discussed.
Type 4 is a driver written in Java that talks the specific language to the database.
Now to your actual question, what MS released was the beta version of a Type4 Driver for SQL server. If you go to the JDBC Driver listings page you will se that there are 34 JDBC drivers available fot SQL server. The one from BEA is just one of them.
You should note that the BEA driver conforms to JDBC 1 as opposed to JDBC 2, which includes a bunch of additional functionality.
I hope this covers most of your issues.
Dave
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"anthony",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic