Re: Possible to specify multiple JDBC drivers in ij?

[Jack Klebanoff]

Jonathan Eric Miller wrote:
Does anyone know if there is a way to specify multiple JDBC drivers in 
ij? For example, I want to use one JDBC driver for one connection 
(Derby) and another for another connection (MySQL).

Jon

Yes. Ij automatically loads the Derby driver. You use the ij "driver" 
command to load other drivers. E.g.

driver 'com.mysql.jdbc.Driver';
connect 'jdbc:mysql://myhost/...' as mysql;
Jdbc uses the sub-protocol name, for instance "mysql" in 
"jdbc:mysql:..." or "derby" in "jdbc:derby:...", to decide which driver 
to use for the connection.

Jack