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 "Shivaraju Gowda (JIRA)" <ji...@apache.org> on 2009/09/19 02:56:16 UTC
[jira] Created: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Connection to Derby doesn't work if the path has round braket in it
--------------------------------------------------------------------
Key: DERBY-4381
URL: https://issues.apache.org/jira/browse/DERBY-4381
Project: Derby
Issue Type: Bug
Affects Versions: 10.5.3.0
Environment: Windows Vista
Reporter: Shivaraju Gowda
In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
"C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
to any database stored in that folder(in jar format) through derby JDBC.
The effective connection string is :
jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
This fails because the closing brackets is not escaped.
I looked into the documentation and didn't find references to escaping the brackets in the path.
I think this problem should be reproducible on all platforms.
you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765804#action_12765804 ]
Bryan Pendleton commented on DERBY-4381:
----------------------------------------
Rather than trying to escape the parentheses, would it work to match up the left- and right-parentheses,
and then use the outermost set of parentheses as the ones which matter?
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-4381:
----------------------------------
Component/s: JDBC
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Shivaraju Gowda (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765745#action_12765745 ]
Shivaraju Gowda commented on DERBY-4381:
----------------------------------------
> Is it standard to escape special characters?Perhaps this should be changed to a documentation issue?
I don't know, even if it is I couldn't figure out what escape character to use from the documentation. I
tried the backslash, "\", as in the connection string below, and it didn't work.
jdbc:derby:jar:(C:/Program Files\(86\)/ClassicModels.jar)ClassicModels
> Since this involves a Windows standard folder I will add a TIP to the WIKI so the information is searchable.
The only workaround I can think of is to place the db jar file in a path which doesn't
have the round brackets. Do you have any other suggestion?
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Stan Bradbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765741#action_12765741 ]
Stan Bradbury commented on DERBY-4381:
--------------------------------------
Is it standard to escape special characters? Perhaps this should be changed to a documentation issue?
Since this involves a Windows standard folder I will add a TIP to the WIKI so the information is searchable.
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Venkateswaran Iyer (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799518#action_12799518 ]
Venkateswaran Iyer commented on DERBY-4381:
-------------------------------------------
The syntax for loading a database as read-only has parentheses in it. As with any other syntax rules an "override" mechanism for special characters or keywords should be provided which could be delimited quotes or back slashes. Perhaps if location was removed from the syntax and made an optional property in the connect call?
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765891#action_12765891 ]
Dag H. Wanvik commented on DERBY-4381:
--------------------------------------
Do we have any guarantees that the directory name's use of parentheses will be balanced?
I was assuming we could not rely on that. I guess we could start from the end of the URL and move backwards until we hit a ')' .
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if
the path has round braket in it
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765792#action_12765792 ]
Dag H. Wanvik commented on DERBY-4381:
--------------------------------------
We could introduce '\' (backslash) as an escape character in this syntax, but I guess that could make some
Windows users unhappy, since I think Derby (Java) accepts '\' as directory delimiter along with '/' (forward slash).
One would then have to write C:\\Program Files\\ ... Using forward slashes would avoid this, but changing this
syntax would likely break existing apps. One possible way out would be to interpret backslash as a meta-character only in front of punctuation and whitespace characters, otherwise it would be taken verbatim. E.g. \\ means a single backslash, \w means a backslash followed by a lower case w.
> Connection to Derby doesn't work if the path has round braket in it
> --------------------------------------------------------------------
>
> Key: DERBY-4381
> URL: https://issues.apache.org/jira/browse/DERBY-4381
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Environment: Windows Vista
> Reporter: Shivaraju Gowda
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> In 64 bit windows vista OS, if an executable is 32 bit than it is generally installed under
> "C:\Program Files (x86)" folder. The brackets in the path cause problems while connecting
> to any database stored in that folder(in jar format) through derby JDBC.
> The effective connection string is :
> jdbc:derby:jar:(C:/Program Files(86)/ClassicModels.jar)ClassicModels
> This fails because the closing brackets is not escaped.
> I looked into the documentation and didn't find references to escaping the brackets in the path.
> I think this problem should be reproducible on all platforms.
> you cannot connect to it,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.