Page 1 of 1

About Question enthuware.ocpjp.v11.2.3366 :

Posted: Tue Nov 17, 2020 3:29 pm
by olsongrant
jdbc:derby:1106:sample is the last answer choice. The question is about which answer choices are valid JDBC URLs. The criteria seems to be the following:
1) must start with jdbc
2) must have at least three parts, separated by colons
3) format is jdbc:<subprotocol>:<subname>
4) While the subname portion typically has a hostname and a port in it, the subname is not required to carry those elements.
5) having more than two colons is acceptable -- many popular JDBC drivers have URLs with three or four colons in them.

Which of the rules am I not understanding? How is jdbc:derby:1106:sample not valid?

Grant

Re: About Question enthuware.ocpjp.v11.2.3366 :

Posted: Tue Nov 17, 2020 11:24 pm
by admin
Yes, technically, just from the JDBC url rules perspective it should be correct as well.
Although from derby perspective it should be: jdbc:derby:[subsubprotocol:][databaseName][;attribute=value]*
1106 would not be a valid subprotocl or database name.

Updated the option and explanation to make it clear.

thank you for your feedback!