Re: Possible to specify multiple JDBC drivers in ij?

[Jonathan Eric Miller]

Thanks. I did notice that it loads the Derby driver by default. So, I can 
get it to work with Derby and one other database driver using ij.properties. 
But, I want to add a third database driver. I guess it's more of an issue 
with the ij.properties file rather than with ij itself. I tried putting 
multiple ij.driver lines in ij.properties, but, it just uses the last one 
specified. I also tried specifying multiple drivers on a single line space 
and : delimited, but, that didn't work.

Jon
----- Original Message ----- 
From: "Jack Klebanoff" <[EMAIL PROTECTED]>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Friday, February 18, 2005 7:26 PM
Subject: Re: Possible to specify multiple JDBC drivers in ij?


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