java/sql-dk/src/info/globalcode/sql/dk/SQLCommandNamed.java
branchv_0
changeset 50 074b81e5fa7c
parent 49 b4c74461d0f9
child 51 6730214fab41
equal deleted inserted replaced
49:b4c74461d0f9 50:074b81e5fa7c
    97 			updatedQuery.append(originalQuery.substring(lastPosition, m.start()));
    97 			updatedQuery.append(originalQuery.substring(lastPosition, m.start()));
    98 
    98 
    99 			if (name.isEmpty()) {
    99 			if (name.isEmpty()) {
   100 				updatedQuery.append(PROBLEM_MARK);
   100 				updatedQuery.append(PROBLEM_MARK);
   101 				updatedQuery.append(originalQuery.substring(m.end(), originalQuery.length()));
   101 				updatedQuery.append(originalQuery.substring(m.end(), originalQuery.length()));
   102 				throw new SQLException("Named parameter (near " + PROBLEM_MARK + ") is not defined: " + updatedQuery);
   102 				throw new SQLException("Named parameter (near " + PROBLEM_MARK + ") is not defined: „" + updatedQuery + "“");
   103 			}
   103 			}
   104 
   104 
   105 			updatedQuery.append("?");
   105 			updatedQuery.append("?");
   106 
   106 
   107 			parametersUsed.add(findByName(parameters, name));
   107 			parametersUsed.add(findByName(parameters, name));
   110 		}
   110 		}
   111 		updatedQuery.append(originalQuery.substring(lastPosition, originalQuery.length()));
   111 		updatedQuery.append(originalQuery.substring(lastPosition, originalQuery.length()));
   112 
   112 
   113 		for (NamedParameter definedParameter : parameters) {
   113 		for (NamedParameter definedParameter : parameters) {
   114 			if (findByName(parametersUsed, definedParameter.getName()) == null) {
   114 			if (findByName(parametersUsed, definedParameter.getName()) == null) {
   115 				throw new SQLException("Parameter " + definedParameter.getName() + " is defined but not used in the query.");
   115 				throw new SQLException("Parameter „" + definedParameter.getName() + "“ is defined but not used in the query: „" + originalQuery + "“");
   116 			}
   116 			}
   117 		}
   117 		}
   118 	}
   118 	}
   119 
   119 
   120 	@Override
   120 	@Override