The exact way to connect to DSN depends on the programming language/development tool that you use. Of course, it might be wise to put your username/password elsewhere. Each one specifies at least a name, between brackets, and a driver name.įor example, my odbcinst.ini contains: ĭriver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5w.soĪnd my odbc.inicontains two entries, one for the production database, one for the test įrom that point on, you can connect just using the DSN name (Prod or TestDB). If you need transaction support, use the MySQL script that comes with the JPetStore distribution (in the ddl/mysql directory). But in reality, each SQL command is a seperate 'transaction'. MySQL driver is a Type 4 JDBC driver, so you just need to add the JAR file in Eclipse. The MySQL driver is smart enough to act as if transactions occur so that transaction-aware software (like JPetStore) will still run fine. The second one is the collection of database source name. Fixing : i n Java and Eclipse You need to add MySQL JDBC driver in your Eclipse Java project's classpath.

In your case, there will be two of them, one for MySQL, the other one for Postgres. The first one contains the specification of the available drivers. If the driver name is incorrectly configured, then the exception will be thrown. verify the datasource.driver-class name in the configuration. The first one is the driver, the second is the managing driver (not very useful).Ĭreate two files in /etc: odbcinst.ini and odbc.ini The driver name could be configured wrongly in the database url. That will create the files libmyodbc5X (where the X depends on which driver has been installed) and libodbcmy.so in /usr/lib/x86_64-linux-gnu/odbc. Get and install the MySQL drivers from MySQL here. See this page for more info on that:, under the theme 'Drivers'.

I guess for Postgres, you will have to ask the drivers from Postgres. This answer only explains how to install MySQL ODBC drivers.

Mysql jdbc driver ubuntu