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
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.
posted 19 years ago
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
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.
posted 19 years ago
Tom, Thanks. I'll try it. Clyde
There’s no place like 127.0.0.1. But I'll always remember this tiny ad: