[ 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
