db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-480) org.apache.derby.tools.ij documentation bug
Date Thu, 28 Jul 2005 19:29:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-480?page=comments#action_12317124 ] 

Satheesh Bandaram commented on DERBY-480:

Actually it is possible to use IJ without any changes. I have tried this on DB2 as follows:

>java org.apache.derby.tools.ij
ij version 10.2
ij> driver 'com.ibm.db2.jcc.DB2Driver';
ij> connect 'jdbc:db2://localhost:50000/tdb' user '<user>' password '<pwd>';
ij> select count(*) from sysibm.systables;

1 row selected

It is also possible to provide driver, database, protocol and user/password using ij properties

> java  -Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.protocol=jdbc:db2://localhost:50000/
 -Dij.user=<user> -Dij.password=<pwd> -Dij.exceptionTrace=true -Dij.database=tdb
-Dij.retrieveMessagesFromServerOnGetMessage=true org.apache.derby.tools.ij
ij version 10.2
CONNECTION0* -  jdbc:db2://localhost:50000/tdb
* = current connection

> org.apache.derby.tools.ij documentation bug
> -------------------------------------------
>          Key: DERBY-480
>          URL: http://issues.apache.org/jira/browse/DERBY-480
>      Project: Derby
>         Type: Bug
>   Components: Tools
>     Versions:
>     Reporter: Philip Wilder
>     Priority: Trivial

> The ij javadocs state:
> "ij is can also be used with any database server that supports a JDBC driver."
> While I was eventually able to get ij to work with db2, I had to modify the protocolDrivers
array in the org.apache.derby.tools.ij to include the ibm Driver name as part of the list.

> I would propose two options:
> 1) Remove this line from the javadocs
> 2) Start adding more protocols to this protocolDrivers array.
> While I think #1 is more correct, #2 has the potential to be more useful. This said I
suspect the number of people who would use ij for databases other then derby can be counted
on one hand that is missing fingers.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message