List of executeSQLQuery() Examples

Examples of executeSQLQuery()

ch.epfl.lbd.database.providers.oracle.connection.OracleConnection.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
net.sourceforge.jivalo.cnfmgr.persistent.impl.PersistentConnectorImpl.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 PersistentStorageException if error occurs.

Examples of ch.epfl.lbd.database.providers.oracle.connection.OracleConnection.executeSQLQuery()

             " add "+
             "( "+
                streetColumnName+" varchar(64)"+
              " )";
          
          oracle.executeSQLQuery(addColumnQuery);
          logger.info("Column inserted");
        }
        catch(Exception e){
          logger.error("the column is already created");
        }

View Full Code Here

Examples of ch.epfl.lbd.database.providers.oracle.connection.OracleConnection.executeSQLQuery()

          
          String insertQuery = "UPDATE "+tblName+
                         " SET "+streetColumnName+" = '"+address+
                     "' WHERE "+id+" = "+idValue;
          
          oracle.executeSQLQuery(insertQuery);
          i++;
          
          //logger.info(i+"-th row updated");
          step(100000000/total);
          if(getStatus() > lastStatus + 0.01){

View Full Code Here

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

            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

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

        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

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

                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

Examples of net.sourceforge.jivalo.cnfmgr.persistent.impl.PersistentConnectorImpl.executeSqlQuery()

    public static Vector executeSqlQuery(String sqlString,
                                  PreparedStatementParameter[] parameters,
                                  String resourceName) throws Exception {
      
      PersistentConnectorImpl impl = new PersistentConnectorImpl();
      return impl.executeSqlQuery( sqlString, parameters, resourceName);


    }


    /**
     * Executes the query which updates the database.

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.