This presentation teaches you how to install OpenLink's Multi-Tier ODBC client driver on Mac OSX. JDBC client driver installation (Windows and Mac OS) 8 Configuring client drivers 8 Where to go from here 9. 4 Installing FileMaker ODBC and JDBC Client Drivers. JDBC client driver installation (Windows and Mac OS) The installation program and the JDBC client driver work on both Windows and Mac OS. You must have. To install, follow the instructions below to download the driver, put it in the correct location, and set the appropriate permissions. Note: The Amazon Athena driver is a JDBC driver so it doesn't require an odbc.ini file.
- JDBC Tutorial
Driver Manager In Java
- JDBC Examples
- JDBC Useful Resources
- MySQL JDBC for macOS. This tutorial shows how to set up a data source and connect to a MySQL ® database using the Database Explorer app or the command line. This tutorial uses the MySQL Connector/J 5.1.46 driver to connect to a MySQL Version 5.5.16 database.
- The bundled version of the Mac OS X installation program provides the option to install Informix with either Client SDK or Informix Connect only. However, IBM Informix JDBC Driver and BladeManager are available on the bundled version of the installation media for Mac OS X, and they can be installed separately.
- Selected Reading
To start developing with JDBC, you should setup your JDBC environment by following the steps shown below. We assume that you are working on a Windows platform.
Install Java
Install J2SE Development Kit 5.0 (JDK 5.0) from Java Official Site.
Make sure following environment variables are set as described below −
-
JAVA_HOME: This environment variable should point to the directory where you installed the JDK, e.g. C:Program FilesJavajdk1.5.0.
-
CLASSPATH: This environment variable should have appropriate paths set, e.g. C:Program FilesJavajdk1.5.0_20jrelib.
-
PATH: This environment variable should point to appropriate JRE bin, e.g. C:Program FilesJavajre1.5.0_20bin.
It is possible you have these variable set already, but just to make sure here's how to check.
-
Go to the control panel and double-click on System. If you are a Windows XP user, it is possible you have to open Performance and Maintenance before you will see the System icon.
-
Go to the Advanced tab and click on the Environment Variables.
-
Now check if all the above mentioned variables are set properly.
You automatically get both JDBC packages java.sql and javax.sql, when you install J2SE Development Kit 5.0 (JDK 5.0).
Install Database
The most important thing you will need, of course is an actual running database with a table that you can query and modify.
Install a database that is most suitable for you. You can have plenty of choices and most common are −
-
MySQL DB: MySQL is an open source database. You can download it from MySQL Official Site. We recommend downloading the full Windows installation.In addition, download and install MySQL Administrator as well as MySQL Query Browser. These are GUI based tools that will make your development much easier.Finally, download and unzip MySQL Connector/J (the MySQL JDBC driver) in a convenient directory. For the purpose of this tutorial we will assume that you have installed the driver at C:Program FilesMySQLmysql-connector-java-5.1.8.Accordingly, set CLASSPATH variable to C:Program FilesMySQLmysql-connector-java-5.1.8mysql-connector-java-5.1.8-bin.jar. Your driver version may vary based on your installation.
-
PostgreSQL DB: PostgreSQL is an open source database. You can download it from PostgreSQL Official Site.The Postgres installation contains a GUI based administrative tool called pgAdmin III. JDBC drivers are also included as part of the installation.
-
Oracle DB: Oracle DB is a commercial database sold by Oracle . We assume that you have the necessary distribution media to install it.Oracle installation includes a GUI based administrative tool called Enterprise Manager. Mac ssh client for programming. JDBC drivers are also included as a part of the installation.
Install Database Drivers
The latest JDK includes a JDBC-ODBC Bridge driver that makes most Open Database Connectivity (ODBC) drivers available to programmers using the JDBC API.
Now a days, most of the Database vendors are supplying appropriate JDBC drivers along with Database installation. So, you should not worry about this part.
Set Database Credential
For this tutorial we are going to use MySQL database. When you install any of the above database, its administrator ID is set to root and gives provision to set a password of your choice.
Using root ID and password you can either create another user ID and password, or you can use root ID and password for your JDBC application.
There are various database operations like database creation and deletion, which would need administrator ID and password.
Install Jdbc Driver For Sql Server
For rest of the JDBC tutorial, we would use MySQL Database with username as ID and password as password.
If you do not have sufficient privilege to create new users, then you can ask your Database Administrator (DBA) to create a user ID and password for you.
Create Database
To create the EMP database, use the following steps −
Step 1
Open a Command Prompt and change to the installation directory as follows −
Note: The path to mysqld.exe may vary depending on the install location of MySQL on your system. You can also check documentation on how to start and stop your database server.
Step 2
Start the database server by executing the following command, if it is already not running.
Step 3
Mail client for mac support exchange. Create the EMP database by executing the following command −
Create Table
To create the Employees table in EMP database, use the following steps −
Step 1
Open a Command Prompt and change to the installation directory as follows −
Step 2
Login to the database as follows −
Step 3
Create the table Employee as follows −
Create Data Records
Finally you create few records in Employee table as follows −
For a complete understanding on MySQL database, study the MySQL Tutorial.
Now you are ready to start experimenting with JDBC. Next chapter gives you a sample example on JDBC Programming.
Active5 years, 1 month ago
Does anyone know how to connect to a Progress 9.1E database from a Mac (or even from Linux)?
I can connect successfully from Windows but the JDBC driver requires that the Progress install directory and it's bin directory are in the path.
It seems to be one product that is firmly under Google's radar. OpenLink has an OSX driver but it is a paid for product, which is fine, but as this is for development use only I'd rather find a free alternative.
Thanks.
68.1k21 gold badges132 silver badges182 bronze badges
Damo
Jdbc Driver Mysql
Damo
9,6955 gold badges50 silver badges71 bronze badges
3 Answers
You need Progress SQL92 Client Access, Mac is unsupported, RedHat, SuSe and several flavours of Unix are.
See Progress Version 9 product availability matrix, look for ODBC and JDBC.
As far as I know there are only two companies in the world that produce ODBC/JDBB connectivity drivers for Progress DB: OpenLink and DataDirect (now acquired by Progress).
Another way is to connect using Progress AppServer, then you'd be able to run Progress 4GL (or ABL - Advanced Business Language) queries/logic on AppServer and output resulting datasets to Java.
The third way is to migrate the data (if this is an option).
Other options include exposing DB via WebSpeed (web application server) or using sockets, files, getting OpenEdge and exposing the data through 4GL web services etc. This will really depend on your data access needs. However all of these methods are non-trivial and require Progress platform and 4GL expertise.
Vlad Gudim
Jdbc Driver Download
Vlad Gudim
17.2k15 gold badges63 silver badges91 bronze badges
If you upgrade your progress to Openedge (Progress v10) its jdbc driver doesn't require any progress related installation, because it's 100% pure java (type 4 driver), so you can access Openedge DB from any OS that supports java.
ksimonksimon
I did a development on MAC with ProgreSQL using OpenLink ODBC drivers about 4 years ago. Don't remember too many problems but it introduces commercial problems (costs!).. for deployment.
Wait a minute!! that was PostgreSQL which isn't the same thing is it. I can't delete this answer because there is useful info in the comments below.
AnthonyLambertAnthonyLambert
7,0463 gold badges29 silver badges64 bronze badges