[ http://issues.apache.org/jira/browse/DERBY-374?page=comments#action_12331521 ]
Deepa Remesh commented on DERBY-374: ------------------------------------ In my local codeline, I merged this patch to 10.1 and ran derbyall on WinXP with Sun jdk1.4.2. No failures. The merge command I used is: svn merge -r 292916:292917 https://svn.apache.org/repos/asf/db/derby/code/trunk Please merge this to 10.1 branch. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Results of the url test suggested by Kathey (copying to JIRA entry from the mailing list for reference): ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- I tried all the Client URLs added in the test jdbcapi/checkDriver.java. With 10.1 server and 10.2 client : behaviour same as before this patch. (protocol error) With 10.2 server and 10.1 client: Instead of protocol error, client throws a SQLException with null message. ij displays: ERROR : DERBY SQL error: SQLCODE: -1, SQLSTATE: , SQLERRMC: null ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > Invalid URL with Derby Client when connecting to Network Server causes > protocol exception. > ------------------------------------------------------------------------------------------ > > Key: DERBY-374 > URL: http://issues.apache.org/jira/browse/DERBY-374 > Project: Derby > Type: Bug > Components: Network Client > Versions: 10.2.0.0, 10.1.1.0 > Environment: Network Server running with Derby client on Windows 2000. > Reporter: A B > Assignee: Deepa Remesh > Fix For: 10.2.0.0 > Attachments: derby-374-patch.diff, derby-374-patch.status > > If using the Derby Client to connect to the Derby Network Server, there are > some cases where an invalid URL will cause a protocol exception instead of > throwing a proper error. The two cases I've found are as follow: > 1) Use of a colon to separate attributes: > When connecting to the server with JCC, a colon is required to demarcate the > Derby attributes from the JCC attributes. For the Derby Client, however, the > colon is not a valid part of the URL, so use of it should return an error. > However, the result is a protocol exception: > ij> connect > 'jdbc:derby://localhost:1528/sample:user=someUsr;password=somePwd'; > agentThread[DRDAConnThread_9,5,main] > ERROR (no SQLState): A communication error has been detected. Communication > protocol being used: Reply.fill(). Communication API being used: > InputStream.read(). Location where the error was detected: > insufficient data. Communication function detecting the error: *. Protocol > specific error codes(s) TCP/IP SOCKETS > 2) Use of double-quotes to specify a full path to a database. > The use of double-quotes around a database path is required when connecting > to the server with JCC, but should be optional when using the Derby Client. > However, attempts to use the double-quotes doesn't work--on the contrary, it > throws a protocol exception: > ij> connect 'jdbc:derby://localhost:1528/"C:/myDBs/sample"'; > agentThread[DRDAConnThread_11,5,main] > ERROR (no SQLState): A communication error has been detected. Communication > protocol being used: Reply.fill(). Communication API being used: > InputStream.read(). Location where the error was detected: > insufficient data. Communication function detecting the error: *. Protocol > specific error codes(s) TCP/IP SOCKETS > Without quotes, the above example will work as expected. > I'm not sure if the problem is with the Derby client or the Network Server > (more investigation required). -- 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
