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
-----------
322

1 row selected

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

> 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
ij>


> 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: 10.2.0.0
>     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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message