This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC Driver Installed ??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Driver Installed ???" Watch "JDBC Driver Installed ???" New topic
Author

JDBC Driver Installed ???

clyde jones
Ranch Hand

Joined: Dec 02, 2000
Posts: 46
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
Sarath Madap
Greenhorn

Joined: Feb 07, 2001
Posts: 7
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
javahelp
Greenhorn

Joined: Feb 01, 2001
Posts: 6
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

Joined: Dec 02, 2000
Posts: 46
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
Tom McQueary
Greenhorn

Joined: Nov 24, 2000
Posts: 20
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

Joined: Dec 02, 2000
Posts: 46
Tom,
Thanks. I'll try it.
Clyde
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Driver Installed ???
 
Similar Threads
scrollable resultsets
Best JDBC drivers?
upgrading from MP2 to Mp3
How to know the version of JDBC
Driver Type