• 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

JDBC Driver Installed ???

 
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Y'all,
This may seem like a dumb question, but how do you know if you have a JDBC driver installed on your machine?
Clyde
 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The Java Database Connect API (JDBC) is supported by all major database vendors as well as many small databases. It all depends on what database platform you are trying to connect to.
For example: If you are trying to access Oracle database, Oracle provides you a thin driver(oracle.jdbc.driver.OracleDriver) in the form of a ZIP file. You have to download it and add that to your classpath and you can load the driver from that.
Hope that helps.
-Sarath
 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Go to your command prompt and type
echo %classpath%
you should some thing get as follows
c:\dirname\class*.zip if you are using oracle driver or some body elses driver should be in your classpath.
Or try to compile simple program which used Jdbc and if it compiles properly then you have jdbc driver installed.
 
clyde jones
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sarath,
Thanks. I am using a PointeBase database. Supposely, I have the database driver, but when I run a make database program, I get an error message saying I do not have a PointBase driver nor could I find anything indicating that I had installed it. I'll scratch around some more to try to figure it out. The classpath tip gave me a starting point. Thanks again.
Clyde
 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Clyde,
I installed the Pointbase mobile edition in the default directory c:\pointbase. Then in my autoexec.bat file, I added the following to my existing classpath.
rem classpath for pointbase
set CLASSPATH=%CLASSPATH%;c:\pointbase\classes\pointbasemobile228r.jar;c:\pointbase\classes\pointbasetools228r.jar
You can expand the pointbasemobile228r.jar file if you want to see the classes inside. The JDBC driver for pointbase is com.pointbase.jdbc.jdbcDriver. This means, in the expanded jar file, you will see a folder named com. Inside the com folder, you will see a folder named pointbase. In pointbase you will see the jdbc folder. In the jdbc folder you will see the jdbcDriver.class file. Note the class name starts with a lower case letter which is unusual. It is not necessary to expand the jar file. I'm just trying to show you how you can see exactly where the driver class file is.
Another thing that might help is this. After you set the classpath and reboot, you can run the following program:
java com.pointbase.tools.toolsConsole
This is a Swing application that will allow you to create your database, execute SQL queries, and so forth. Be sure to select the correct driver from the drop list. If you have any more questions, let me know or check the documentation that comes with pointbase.
 
clyde jones
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Tom,
Thanks. I'll try it.
Clyde
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic