[DERBY-4381] Connection to Derby database using jar subprotocol doesn't work if the path has round bracket in it

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.3.0
• Fix Version/s: 10.10.2.1, 10.11.1.1
• Component/s: JDBC
• Labels: derby_triage10_5_2
• Environment: Windows Vista
• Urgency: Normal
• Bug behavior facts: Seen in production
• Assignee: Myrna van Lunteren
• Reporter: Shivaraju Gowda
• Created: 19/Sep/09 00:54
• Updated: 09/Sep/16 09:51
• Resolved: 02/Oct/14 20:21

Description

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,

Issue Links

• relates to: DERBY-6759 Derby 10.10 backport issue (fall 2014)