Examples of de.innovationgate.webgate.api.WGQueryException

de.innovationgate.webgate.api.WGQueryException
Thrown when a query results in an error, e.g. because of invalid query syntax

      
      ResultSet resultSet =  stmt.executeQuery();
      return new WGResultSetImpl(this, resultSet);
    }
    catch (Exception e) {
      throw new WGQueryException(query, "Exception executing query", e);
    }


  }

View Full Code Here

        }
        else if (type.equals("sql")) {
            return executeSQLQuery(query, params);
        }
        else {
            throw new WGQueryException(query, "Unknown query type: " + type);
        }


    }

View Full Code Here

            Map queryParams = (Map) params.get(WGDatabase.QUERYOPTION_QUERY_PARAMETERS);
            HibernateResultSet.injectQueryParams(hibQuery, queryParams);
            return new WGSQLResultSet(this, hibQuery, queryParams);
        }
        catch (SQLGrammarException e) {
            throw new WGQueryException(fullQuery, e.getMessage(), e); 
        }
        catch (HibernateException e) {
            throw new WGBackendException("Error executing SQL query", e);
        }
    }

View Full Code Here

            
            builtQuery = composeHQLQuery(fullQuery, furtherClauses, lazyFetch);
        }


        if (builtQuery == null) {
            throw new WGQueryException(query, "Unknown query type: " + type);
        }
        
        builtQuery = WGUtils.strReplace(builtQuery, "\"", "'", true);


        if (params != null) {
            params.put(WGDatabase.QUERYOPTION_RETURNQUERY, builtQuery);
        }


        List results = null;
        try {
            Query hibQuery = getSession().createQuery(builtQuery);
            int maxResults = 0;
            if (params.containsKey(WGDatabase.QUERYOPTION_MAXRESULTS)) {
                 maxResults = ((Number) params.get(WGDatabase.QUERYOPTION_MAXRESULTS)).intValue();
            }
            if (maxResults > 0) {
                hibQuery.setMaxResults(maxResults);
            }
            
            HibernateResultSet.injectQueryParams(hibQuery, queryParams);
            if (lazyFetch) {
                if (languagesPriorityList != null) {
                    return new WGLanguageChoosingHQLResultSet(this, hibQuery, queryParams, languagesPriorityList);
                }
                else {
                    return new WGLazyHQLResultSet(this, hibQuery, queryParams);
                }
            }
            else {
                return new WGStraightHQLResultSet(this, hibQuery, queryParams);
            }
        }
        catch (QueryException e) {
            throw new WGQueryException(builtQuery, e.getMessage(), e);
        }
        catch (HibernateException e) {
            throw new WGBackendException("Error executing HQL query", e);
        }

View Full Code Here

            }
                else if (type.equals("fullhql")) {
                    fullQuery = query;
                }
                else {
                    throw new WGQueryException(query, "Unknown query type '" + type + "'");
                }
            }
            else {
                fullQuery = "select profile.name from UserProfile profile order by profile.name asc";
            }
            
            Query hqlQuery = getSession().createQuery(fullQuery);
            if (params.containsKey(WGDatabase.QUERYOPTION_MAXRESULTS)) {
                Number maxResults = (Number) params.get(WGDatabase.QUERYOPTION_MAXRESULTS);
                hqlQuery.setMaxResults(maxResults.intValue());
            }
            
            return hqlQuery.list();
            
        }
        catch (QueryException e) {
           throw new WGQueryException(query, e.getMessage(), e); 
        }
        catch (HibernateException e) {
           throw new WGBackendException("Error executing profile query", e);
        }

View Full Code Here

            Query hqlQuery = getSession().createQuery(fullQuery);
            return hqlQuery.iterate();
            
        }
        catch (QueryException e) {
           throw new WGQueryException("Querying all user profile names", e.getMessage(), e); 
        }
        catch (HibernateException e) {
           throw new WGBackendException("Error executing profile query", e);
        }

View Full Code Here

      }
      else if (type.startsWith("table:")) {


        table = type.substring(6).trim();
        if (!_tables.keySet().contains(table.toLowerCase())) {
            throw new WGQueryException(query, "Table '" + table + "' does not exist or has no primary key");
        }
            
          if (query != null && !query.trim().equals("")) {
                    query = "SELECT * FROM " + table + " WHERE " + query;
                }
                else {
                    query = "SELECT * FROM " + table;
                }
        stmt = getConnection().prepareStatement(query, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
        
      }
      else {
        throw new WGQueryException(query, "Unknown query type: " + type);
      }
      
      // Apply parameters
            if (parameters.containsKey(WGDatabase.QUERYOPTION_MAXRESULTS)) {
                stmt.setMaxRows(((Number) parameters.get(WGDatabase.QUERYOPTION_MAXRESULTS)).intValue());
            }
            
            applyQueryParameters(parameters, stmt, query);


            // Execute and extract data
            stmt.execute();
            resultSet = stmt.getResultSet();
            Map results;
            if (resultSet != null) {
                results = extractRowResults(resultSet, table);
            }
            else {
                results = new HashMap();
            }
            
            return results;


    }
    catch (SQLException e) {
      throw new WGQueryException(query, e.getMessage(), e);
    }
    finally {
      closeResultSet(resultSet);
    }
  }

View Full Code Here

      channel = FeedParser.parse(new ChannelBuilder(), retrievePage(query));
            if (channel != null) {
                _channel.set(channel);
            }
            else {
                throw new WGQueryException("Unable to retrieve or parse feed", query);
            }
        }  
    catch (Exception e) {
            throw new WGQueryException("Exception retrieving or parsing feed", query, e);
    }
    
    
    List items = new ArrayList(channel.getItems());
    Map itemMap = new LinkedMap();

View Full Code Here


      // Return InputStream from given URL
      return inStream;
    }
    catch (MalformedURLException e) {
      throw new WGQueryException("Malformed feed URL", url, e);
    }
    catch (IOException e) {
      throw new WGQueryException("IO Exception retrieving feed", url, e);
    }
  }

View Full Code Here


  public WGResultSetCore query(String type, String query, Map parameters) throws WGQueryException {


    Document doc = this.retrievePage(query);
    if (doc == null) {
      throw new WGQueryException(query, "Could not retrieve or parse RSS");
    }
    return new WGResultSetImpl(this.db, doc);


  }

View Full Code Here

0 1

TOP

Related Classes of de.innovationgate.webgate.api.WGQueryException

de.innovationgate.webgate.api.jdbc.custom.JDBCSource

de.innovationgate.webgate.api.jdbc.WGDatabaseImpl

de.innovationgate.webgate.api.query.jdbc.WGDatabaseImpl

de.innovationgate.webgate.api.query.rss.WGDatabaseImpl

de.innovationgate.webgate.api.rss2.SimpleRSS

de.innovationgate.wgpublisher.lucene.LuceneManager

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.