db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Klebanoff <klebanoff-de...@sbcglobal.net>
Subject Re: Possible to specify multiple JDBC drivers in ij?
Date Sat, 19 Feb 2005 01:26:05 GMT
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.


View raw message