db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: Possible to specify multiple JDBC drivers in ij?
Date Sat, 19 Feb 2005 17:01:39 GMT
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" <klebanoff-derby@sbcglobal.net>
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
> 


Mime
View raw message