Java MySQL Connection without Driver

Question

I need to establish a connection to a DB (f.i. MySQL, DB2) but I don't have the possibility to include JARs.

So I thought ODBC is able to connect to DBs without a DB specific driver. But every code example I found uses native drivers.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Throws an access denied exception by Java Security and if else I do get java.sql.SQLException: No suitable driver found for..

I just want to submit some simple SQL Queries - I do not get why I need native drivers.

Am I on the wrong page?

If you need to connect to a database via JDBC, then you're going to need a JDBC driver. There's no way around that. — Jesper
– Jesper, Commented Dec 6, 2012 at 10:08

user330315 · Accepted Answer · 2012-12-06 10:24:04Z

2

The JDBC/ODBC bridge also needs a driver - it needs an installed ODBC driver which is also a "native" driver.

Usually installing an ODBC driver is more hassle than just including a .jar file (JDBC driver) with your application.

With the ODBC driver you actually run in more problems. The ODBC driver must match the "bitness" of the JVM used. So if your application is running with a 32bit JVM you have to have 32bit ODBC drivers installed. If your appliction runs on a 64bit JVM you need the 64bit ODBC driver.

With a JDBC (type 4 - but all DBMS have a type 4 driver nowadays) you just include that single jar file, not installation, no worries about 32/64 bit.

On top of all that: the JDBC/ODBC bridge is buggy and probably slower than using a real JDBC driver.

answered Dec 6, 2012 at 10:24

user330315

Sign up to request clarification or add additional context in comments.

Comments

user219882 · Accepted Answer · 2012-12-06 10:08:17Z

1

You need those drivers. Even if you used Java's SQL API, you would still need an implementation for the particular database (Oracle, MySQL,...). So you have to add the driver to your project

answered Dec 6, 2012 at 10:08

user219882

15.9k25 gold badges97 silver badges142 bronze badges

Comments

Michael 'Maik' Ardan · Accepted Answer · 2012-12-06 10:11:07Z

0

1) Right click on your project. 2) @ Compile tab, add Library. 3) Look for Driver

answered Dec 6, 2012 at 10:11

Michael 'Maik' Ardan

4,40310 gold badges40 silver badges62 bronze badges

Comments

rupesh · Accepted Answer · 2012-12-06 10:18:17Z

0

you might want to read this . You MUST have those drivers.

answered Dec 6, 2012 at 10:18

rupesh

16

Collectives™ on Stack Overflow

Java MySQL Connection without Driver

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related