StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>AFAIK, the only free drivers available are JDBC-ODBC bridges (type 1). </p> <p>The <a href="http://java.sun.com/javase/6/docs/technotes/guides/jdbc/bridge.html" rel="nofollow noreferrer">JDBC-ODBC Bridge Driver</a> distributed by Sun is <code>sun.jdbc.odbc.JdbcOdbcDriver</code> and this is what <a href="http://java.sun.com/javase/6/docs/technotes/guides/jdbc/" rel="nofollow noreferrer">they write</a> about it:</p> <blockquote> <p>Note that the bridge driver included in the Java Platform Standard Edition (Java SE) 6 is appropriate only for experimental use or when no other driver is available. </p> </blockquote> <p>And if this is not enough, here is what Ted Neward writes in Item 49 of <a href="http://www.theserverside.com/tt/articles/article.tss?l=EffectiveJava_Chapter" rel="nofollow noreferrer">Effective Enterprise Java</a>:</p> <blockquote> <p>(...) the JDBC-ODBC driver is an unsupported, bug-ridden 1.0 driver that is incredibly slow and is rumored to leak memory in some ODBC driver configurations (...)</p> </blockquote> <p>Things may be a bit better with the Microsoft one (which is <code>com.ms.jdbc.odbc.JdbcOdbcDriver</code>) but I wouldn't expect a miracle.</p> <p>So, if this is for a corporate application, maybe consider spending a few dollars for a commercial type 4 JDBC Driver. See <a href="https://stackoverflow.com/questions/1764046/using-microsoft-access-with-java-without-the-jdbcodbc-default-bridge/1764510#1764510">this previous answer</a> for some options.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload