Examples of net.sourceforge.jivalo.cnfmgr.persistent.client.PersistentConnectorClient.executeSqlQuery()

net.sourceforge.jivalo.cnfmgr.persistent.client.PersistentConnectorClient.executeSqlQuery()
Executes the query and returns the query result. The PreparedStatementParameter array will be used for setting values in the prepared statement. @param sqlString a SQL SELECT statement. @param parameters parameters passed to the prepared statement. @param resourceName name of resource. @return the rows in a vector. @exception Exception if error occurs. @implemented 1

            parameters[1] = new PreparedStatementParameter(names[1],
                Types.VARCHAR);
            parameters[2] = new PreparedStatementParameter(
              ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
                Types.INTEGER);
            Vector v = client.executeSqlQuery(sql, parameters, resourceName);
            return new Boolean(v.size() > 0);
        }
        catch (Exception e) {
            throw new ConfigurationException(getClass().getName(),
                                             "Error in testing existence", e);

View Full Code Here

        boolean isRootNode = nodeName.equals("/");


        try {
            PersistentConnectorClient client = new PersistentConnectorClient();
            // to keep the foreign key happy
            Vector v = client.executeSqlQuery(selectNames,
                                              new PreparedStatementParameter[] {
                                              new
                                              PreparedStatementParameter(
                isRootNode ?
                EMPTY_STRING :

View Full Code Here

                EMPTY_STRING : nodeName, Types.VARCHAR);
            parameters[1] = new PreparedStatementParameter(
                ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
                Types.INTEGER);


            Vector v = client.executeSqlQuery(sql, parameters, resourceName);
            Set childrenNames = new HashSet(v.size());
            for (Iterator i = v.iterator(); i.hasNext(); ) {
                PreparedStatementResult result = (PreparedStatementResult) i.
                    next();
                String name = (String) result.get("CONFIG_PARAMETER_NAME");

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.