Examples of ExecuteSQL()


Examples of com.cosmo.data.DataAgent.executeSql()

      try
      {
         items.clear();

         conn = DataFactory.getInstance(workspace, this.connection);
         rs = conn.executeSql(sql);
         while (rs.next())
         {
            item = new ListItem(rs.getString(this.valueFieldName),
                                rs.getString(this.titleFieldName));
            items.add(item);
View Full Code Here

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

                ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
                Types.INTEGER);
            parameters[3] = new PreparedStatementParameter(Boolean.TRUE,
                Types.BOOLEAN);

            client.executeSql(insertName, parameters, resourceName);
        }
        catch (Exception e) {
            throw new ConfigurationException(getClass().getName(),
                                             "Error in storing node", e);
        }
View Full Code Here

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

                nodeName, Types.VARCHAR);

            // inserts the new children names
            for (Iterator i = childrenNames.iterator(); i.hasNext(); ) {
                String childName = (String) i.next();
                client.executeSql(insertNames, new PreparedStatementParameter[] {
                                  new PreparedStatementParameter(isRootNode ?
                    EMPTY_STRING : nodeName, Types.VARCHAR),
                                  new PreparedStatementParameter(childName,
                    Types.VARCHAR),
                                  new PreparedStatementParameter(
View Full Code Here

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

            + "VALUES (?, ?, ?, ?)";

        try {
            PersistentConnectorClient client = new PersistentConnectorClient();

            client.executeSql(deleteValuesFromKey,
                              new PreparedStatementParameter[] {
                              new PreparedStatementParameter(nodeName,
                Types.VARCHAR),
                              new PreparedStatementParameter(
                ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
View Full Code Here

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

                              new PreparedStatementParameter(
                ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
                Types.INTEGER)
            }
                , resourceName);
            client.executeSql(deleteValuesFromValue,
                              new PreparedStatementParameter[] {
                              new PreparedStatementParameter(nodeName,
                Types.VARCHAR)
            }
                , resourceName);
View Full Code Here

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

                if (value.length() == 0) {
                    value = EMPTY_STRING;
                }

                try {
                  client.executeSql(insertValuesToKey, new PreparedStatementParameter[] {
                                    new PreparedStatementParameter(nodeName,
                      Types.VARCHAR),
                                    new PreparedStatementParameter(key,
                      Types.VARCHAR),
                                    new PreparedStatementParameter(new Integer(2),
View Full Code Here

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

                }
                catch (Exception ex) {
                  // dublicate key possible
                }
               
                client.executeSql(insertValuesToValue, new PreparedStatementParameter[] {
                    new PreparedStatementParameter(nodeName, Types.VARCHAR),
                    new PreparedStatementParameter(key, Types.VARCHAR),
                    new PreparedStatementParameter(value, Types.VARCHAR),
                    new PreparedStatementParameter(ts, Types.TIMESTAMP)
                }, resourceName);
View Full Code Here

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

            + "AND CONFIG_PARAMETER_TYPE = ?";

        String[] names = split(nodeName);
        try {
            PersistentConnectorClient client = new PersistentConnectorClient();
            client.executeSql(deleteValuesFromValue,
                              new PreparedStatementParameter[] {
                              new PreparedStatementParameter(nodeName,
                Types.VARCHAR)
            }
                , resourceName);
View Full Code Here

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

                              new PreparedStatementParameter[] {
                              new PreparedStatementParameter(nodeName,
                Types.VARCHAR)
            }
                , resourceName);
            client.executeSql(deleteValuesFromKey,
                              new PreparedStatementParameter[] {
                              new PreparedStatementParameter(nodeName,
                Types.VARCHAR),
                              new PreparedStatementParameter(
               ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
View Full Code Here

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

                              new PreparedStatementParameter(
               ( isUserNode.booleanValue()? USER_TYPE_NODE : SYSTEM_TYPE_NODE ),
                Types.INTEGER)
            }
                , resourceName);
            client.executeSql(deleteNode, new PreparedStatementParameter[] {
                              new PreparedStatementParameter(names[0],
                Types.VARCHAR),
                              new PreparedStatementParameter(names[1],
                Types.VARCHAR),
                              new PreparedStatementParameter(
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.