/**
* Extracts connection options.
*
* @param arg argument with options
* @param root expected root element
* @param ctx query context
* @return options
* @throws QueryException query exception
*/
private TokenObjMap<Object> options(final int arg, final QNm root, final QueryContext ctx)
throws QueryException {
// initialize token map
final TokenObjMap<Object> tm = new TokenObjMap<Object>();
// argument does not exist...
if (arg >= expr.length) return tm;
// empty sequence...
final Item it = expr[arg].item(ctx, input);
if (it == null) return tm;
// XQuery map: convert to internal map
if (it instanceof Map) return ((Map) it).tokenJavaMap(input);
// no element: convert XQuery map to internal map
if (!it.type().eq(SeqType.ELM)) throw NODFUNTYPE.thrw(input, this, it.type);
// parse nodes
ANode node = (ANode) it;
if (!node.qname().eq(root)) PARWHICH.thrw(input, node.qname());
// interpret query parameters
final AxisIter ai = node.children();
while ((node = ai.next()) != null) {
final QNm qn = node.qname();
if (!qn.uri().eq(Uri.uri(SQLURI))) PARWHICH.thrw(input, qn);
tm.add(qn.ln(), node.children().next());
}
return tm;
}
/**
* Executes a prepared statement.
*
* @param stmt prepared statement
* @param ctx query context
* @return result
* @throws QueryException query exception
*/
private NodeCache executePrepStmt(final PreparedStatement stmt, final QueryContext ctx)
throws QueryException {
// Get parameters for prepared statement
final ANode params = (ANode) checkType(expr[1].item(ctx, input), NodeType.ELM);
if (!params.qname().eq(E_PARAMS)) PARWHICH.thrw(input, params.qname());
try {
final int placeCount = stmt.getParameterMetaData().getParameterCount();
// Check if number of parameters equals number of place holders
if (placeCount != countParams(params)) PARAMS.thrw(input);
else setParameters(params.children(), stmt);
final boolean result = stmt.execute();
return result ? buildResult(stmt.getResultSet()) : new NodeCache();
} catch (final SQLException ex) {
throw SQLEXC.thrw(input, ex.getMessage());
}
}
/**
* Sets the parameters of a prepared statement.
*
* @param params parameters
* @param stmt prepared statement
* @throws QueryException query exception
*/
private void setParameters(final AxisMoreIter params, final PreparedStatement stmt)
throws QueryException {
int i = 0;
for (ANode next; (next = params.next()) != null; ) {
// Check name
if (!next.qname().eq(E_PARAM)) PARWHICH.thrw(input, next.qname());
final AxisIter attrs = next.attributes();
byte[] paramType = null;
boolean isNull = false;
for (ANode attr; (attr = attrs.next()) != null; ) {
// Attribute "type"
if (eq(attr.nname(), TYPE)) paramType = attr.atom();
// Attribute "null"
else if (eq(attr.nname(), NULL))
isNull = attr.atom() != null && Bln.parse(attr.atom(), input);
// Not expected attribute
else throw NOTEXPATTR.thrw(input, string(attr.nname()));
}
if (paramType == null) NOPARAMTYPE.thrw(input);
final byte[] v = next.atom();
isNull |= v.length == 0;
setParam(++i, stmt, paramType, isNull ? null : string(v), isNull);
}
}