revisit how JDBC drivers are loaded

[julianhyde]

Since JDK 1.5, Java automatically loads drivers whose jar contains a META-INF/services/java.sql.Driver. All drivers have this file these days. This task is to (a) check that this mechanism works for MySQL's driver, (b) recommend whether SqlLine.KNOWN_DRIVERS should be removed.

[jtaylor-sfdc]

Also, maybe publicize the -d option where you can specify your driver class - that came in handy for us.

[julianhyde]

Good point. I've added a simple example in the README. We'll also update the manual at some point.

Julian

[mauro-miatello]

i've tried
sqlline -d oracle.jdbc.OracleDriver
and
sqlline -d /usr/share/java/ojdbc.jar with no success
it's not clear how to load it
thanks

[snuyanzin]

@mmiat recently I faced with the similar issue and it looks like sqlline needs url info also otherwise it just silently does nothing.
so working example should be like

sqlline -u <url> -n <user> -d oracle.jdbc.OracleDriver

I added PR to show warning in case of absent url rather than silently do nothing #236

[julianhyde]

Partial fix in 95a1ffb, PR #236.

[julianhyde]

Fixed in b053ffe, PR #235.

[snuyanzin]

It looks like it could be closed as fixed
//cc @julianhyde

[julianhyde]

I agree, closed.