You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rajesh Kartha (JIRA)" <de...@db.apache.org> on 2006/08/01 02:31:13 UTC
[jira] Created: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
-------------------------------------------------------------------------------------------------------
Key: DERBY-1619
URL: http://issues.apache.org/jira/browse/DERBY-1619
Project: Derby
Issue Type: Bug
Components: Tools
Affects Versions: 10.2.0.0
Environment: Windows XP, jdk 1.5
Reporter: Rajesh Kartha
Fix For: 10.2.0.0
For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
[C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
[C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
[C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
[C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
------------------------------------------------------
This is a regression from 10.1 where the same sysinfo shows:
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
[C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
------------------------------------------------------
--
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
[jira] Resolved: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ]
Andrew McIntyre resolved DERBY-1619.
------------------------------------
Resolution: Fixed
Committed -v2 patch to trunk with revision 427866.
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff, derby-1619-v2.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Assigned: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ]
Andrew McIntyre reassigned DERBY-1619:
--------------------------------------
Assignee: Andrew McIntyre
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12424699 ]
Andrew McIntyre commented on DERBY-1619:
----------------------------------------
The encoded spaces in the file URLs that are obtained through getResource need to be converted to real spaces. The duplicates appear because they are not removed when comparing the classpath and getResource paths in impl.sysinfo.Main.mergeZips().
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "John H. Embretsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12425178 ]
John H. Embretsen commented on DERBY-1619:
------------------------------------------
An excellent and simple solution :)
A note for possible cleanup after we stop supporting J2SE 1.3:
Since URLDecoder.decode(String s) is deprecated, it might be a good idea to eventually start using URLDecoder.decode(String s, String enc) (added in 1.4) instead, with UTF-8 encoding as recommended by the W3C.
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff, derby-1619-v2.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "John H. Embretsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12424832 ]
John H. Embretsen commented on DERBY-1619:
------------------------------------------
I tried derby-1619-v1.diff, and it works as a remedy against the spaces in path issue. However:
The same thing happens if other special characters that are escaped in an URL are used in the jar path. For example, with the path
/export/home/tmp/Derby/jar-path-with%percentage-sign
on a Solaris machine, sysinfo ('java org.apache.derby.tools.sysinfo') reports
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[/export/home/tmp/Derby/jar-path-with%25percentage-sign/derby.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%25percentage-sign/derbytools.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%25percentage-sign/derbynet.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%25percentage-sign/derbyclient.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%percentage-sign/derby.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%percentage-sign/derbynet.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%percentage-sign/derbytools.jar] 10.2.0.5 alpha - (427500)
[/export/home/tmp/Derby/jar-path-with%percentage-sign/derbyclient.jar] 10.2.0.5 alpha - (427500)
This is not an issue when running sysinfo by doing 'java -jar derbyrun.jar sysinfo'.
Quoting from http://www.ietf.org/rfc/rfc2396.txt (section 2.4.2):
Because the percent "%" character always has the reserved purpose of
being the escape indicator, it must be escaped as "%25" in order to
be used as data within a URI. Implementers should be careful not to
escape or unescape the same string more than once, since unescaping
an already unescaped string might lead to misinterpreting a percent
data character as another escaped character, or vice versa in the
case of escaping an already escaped string.
(end quote)
I'm not sure how this is normally handled in the java world.
We could try to fix this, or document it as "normal" sysinfo behavior (if not run via 'java -jar') when using special characters in the code/jar path.
I don't know which characters Java usually escapes in URLs, but the most important ones are listed in RFC-2396. Other posibilities are listed here:
http://www.degraeve.com/reference/urlencoding.php
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Updated: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ]
Andrew McIntyre updated DERBY-1619:
-----------------------------------
Attachment: derby-1619-v2.diff
Thanks, John. There is a general solution for this problem: java.net.URLDecoder. :-)
Attaching patch -v2, which uses URLDecoder. This should take care of all similar encoding problems.
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff, derby-1619-v2.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Updated: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ]
Andrew McIntyre updated DERBY-1619:
-----------------------------------
Attachment: derby-1619-v1.diff
Attached is a simple patch to convert URL spaces ('%20') to real spaces when comparing filenames in sysinfo. This should prevent duplicate entries in the sysinfo output when there are spaces in the full path as discovered by getResource vs. as discovered via the classpath.
I would appreciate it if the reporter of this issue could try out this patch and let me know if this resolves the issue.
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12425304 ]
Andrew McIntyre commented on DERBY-1619:
----------------------------------------
[JDK13CLEANUP]
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff, derby-1619-v2.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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
[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple
entries if the derby jars reside in a directory with spaces in its name
Posted by "Rajesh Kartha (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12425076 ]
Rajesh Kartha commented on DERBY-1619:
--------------------------------------
I tried the v2 of the patch with some special characters and that seem to work fine. The Derby jars
are located in C:\temp\{}Test % '~@^\lib and the sysinfo now shows:
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\temp\{}Test % '~@^\lib\derby.jar] 10.2.0.5 alpha - (427819M)
[C:\temp\{}Test % '~@^\lib\derbytools.jar] 10.2.0.5 alpha - (427819M)
[C:\temp\{}Test % '~@^\lib\derbynet.jar] 10.2.0.5 alpha - (427819M)
[C:\temp\{}Test % '~@^\lib\derbyclient.jar] 10.2.0.5 alpha - (427819M)
------------------------------------------------------
i tried it using the java command:
C:\temp\{}Test % '~@^\lib>java -cp .\derby.jar;.\derbyclient.jar.\derbytools.jar;.\derbyrun.jar;.\derbynet.jar org.apache.derby.tools.sysinfo
I think setting the CLASSPATH variable (or any other environment variable on the WIndows command prompt for that matter) with these special characters in the directory path does not work, hence could not try sysinfo using the jars in the CLASSPATH.
> Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1619
> URL: http://issues.apache.org/jira/browse/DERBY-1619
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.0.0
> Environment: Windows XP, jdk 1.5
> Reporter: Rajesh Kartha
> Assigned To: Andrew McIntyre
> Fix For: 10.2.0.0
>
> Attachments: derby-1619-v1.diff, derby-1619-v2.diff
>
>
> For the Derby jars residing in C:\Documents and Settings\Administrator\TEMP DIR\lib, the sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.2.0.5 alpha - (426734)
> [C:\Documents%20and%20Settings\Administrator\TEMP%20DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> This is a regression from 10.1 where the same sysinfo shows:
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derby.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbynet.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbyclient.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\derbytools.jar] 10.1.3.2 - (426741)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc.jar] 2.6 - (90)
> [C:\Documents and Settings\Administrator\TEMP DIR\lib\db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
--
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