[jira] Commented: (DERBY-4381) Connection to Derby doesn't work if the path has round braket in it

["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.