Examples of executeQuery()


Examples of org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeQuery()

   
    try {
      ResultSet rs;
      Date result;
     
      rs = dbCtx.executeQuery("SELECT now() AS SystemTime");
      result = readTimeField(rs);
     
      return result;
     
    } finally {
View Full Code Here

Examples of org.pentaho.commons.connection.IPentahoConnection.executeQuery()

      connection =
          PentahoConnectionFactory.getConnection( IPentahoConnection.SQL_DATASOURCE, jndiName, getSession(), this );
    }
    String query = ReportParameterUtility.setupParametersForActionSequence( reportSpec.getQuery() );
    query = setupQueryParameters( query );
    IPentahoResultSet res = connection.executeQuery( query );
    return res;
  }

  public String setupQueryParameters( String query ) {
    Set inputNames = getInputNames();
View Full Code Here

Examples of org.pentaho.metadata.model.IMetadataQueryExec.executeQuery()

      executor.setTimeout( this.timeout );
      if ( this.inputs != null ) {
        executor.setInputs( this.inputs );
      }

      resultSet = executor.executeQuery( queryObject );
      if ( resultSet != null && !live && executor.isLive() ) {
        // read the results and cache them
        MemoryResultSet cachedResultSet = new MemoryResultSet( resultSet.getMetaData() );
        Object[] rowObjects = resultSet.next();
        while ( rowObjects != null ) {
View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery()

      try {
        if ( !isForwardOnly() ) {
          if ( sqlParams != null ) {
            localResultSet = sqlConnection.prepareAndExecuteQuery( sql, sqlParams );
          } else {
            localResultSet = sqlConnection.executeQuery( sql );
          }
        } else {
          if ( sqlParams != null ) {
            localResultSet =
                sqlConnection.prepareAndExecuteQuery( sql, sqlParams, SQLConnection.RESULTSET_FORWARDONLY,
View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection.executeQuery()

  }

  public void testExecuteQuery() throws Exception {

    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );

    assertTrue( "result set is wrong type", data instanceof XQResultSet );

    assertFalse( "Should not be scrollable", data.isScrollable() );
View Full Code Here

Examples of org.teiid.jdbc.StatementImpl.executeQuery()

  }
 
  private void setEncoding() {
    try {
      StatementImpl t = connection.createStatement();
      ResultSet rs = t.executeQuery("show client_encoding"); //$NON-NLS-1$
      if (rs.next()) {
        String encoding = rs.getString(1);
        if (encoding != null) {
          //this may be unnecessary
          this.client.setEncoding(encoding);
View Full Code Here

Examples of org.wso2.carbon.registry.core.Registry.executeQuery()

//            registry.put(RegistryConstants.CONFIG_REGISTRY_BASE_PATH + RegistryConstants.QUERIES_COLLECTION_PATH + "/custom-queries", q1);
            Map parameters = new HashMap();
            parameters.put("query",sql1);
//            Resource result = registry.executeQuery(RegistryConstants.CONFIG_REGISTRY_BASE_PATH + RegistryConstants.QUERIES_COLLECTION_PATH + "/custom-queries", parameters);
            Resource result = registry.executeQuery(null, parameters);

            String[] paths = (String[]) result.getContent();

            for (String path : paths) {
View Full Code Here

Examples of org.wso2.carbon.registry.core.dataaccess.QueryProcessor.executeQuery()

                    ". No query processor is associated with the query type: " +
                    queryResource.getMediaType();
            throw new RegistryException(msg);
        }

        return queryProcessor.executeQuery(registry, queryResource, parameters);
    }
}
View Full Code Here

Examples of railo.runtime.orm.ORMSession.executeQuery()

    /* MUST
offset: Specifies the start index of the resultset from where it has to start the retrieval.
cacheable: Whether the result of this query is to be cached in the secondary cache. Default is false.
cachename: Name of the cache in secondary cache.
     */
    Object res = session.executeQuery(pageContext,sql.getSQLString(),params,unique,ormoptions);
    if(returnType==RETURN_TYPE_ARRAY_OF_ENTITY) return res;
    return session.toQuery(pageContext, res, null);
   
  }
 
View Full Code Here

Examples of realcix20.utils.DAO.executeQuery()

       
        PublicKey key = null;
       
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_PUB_AND_PRI_KEY_SQL);
        ResultSet rs = dao.executeQuery();
        try {
           
            if (rs.next())
                key = (PublicKey)rs.getObject("PUBKEY");
           
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.