Examples of executeQuery()

Examples of java.sql.PreparedStatement.executeQuery()

        try {
          ps = stmt.getConnection().prepareStatement("select attrelid, attnum, typoid from matpg_relatt where attname = ? and relname = ? and nspname = ?");
          ps.setString(1, name);
          ps.setString(2, table);
          ps.setString(3, schema);
          ResultSet rs = ps.executeQuery();
          if (rs.next()) {
            info.reloid = rs.getInt(1);
            info.attnum = rs.getShort(2);
            int specificType = rs.getInt(3);
            if (!rs.wasNull()) {
View Full Code Here

Examples of java.sql.Statement.executeQuery()

  public String[] list(String prefix) throws IOException {
    try {
      // Creating a statement lets us issue commands against the connection.
      Statement s = conn.createStatement();
      ResultSet rs = s.executeQuery("SELECT name FROM JoramDB WHERE name LIKE '" + prefix + "%'");

      Vector v = new Vector();
      while (rs.next()) {
View Full Code Here

Examples of javax.xml.xquery.XQPreparedExpression.executeQuery()

        final QName var = new QName(col);
        expression.bindObject(var, parameters.get(col), null)// null = do not override the default object mapping
      // execute query
      final XQResultSequence sequence = expression.executeQuery();
      while (sequence.next())
        final XQItem item = sequence.getItem();
View Full Code Here

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT MAX(endban) AS endban FROM bans WHERE obj_Id=? AND endban IS NOT NULL");
      statement.setInt(1, ObjectId);
      rset = statement.executeQuery();
        Long endban = rset.getLong("endban") * 1000L;
        res = endban > System.currentTimeMillis();
View Full Code Here

Examples of l2p.database.FiltredStatement.executeQuery()

    ResultSet rset = null;
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      rset = statement.executeQuery("SELECT bonus_name,bonus_value from bonus where obj_id='" + _owner.getObjectId() + "' and (bonus_expire_time='-1' or bonus_expire_time > " + System.currentTimeMillis() / 1000 + ")");
        String bonus_name = rset.getString("bonus_name");
        float bonus_value = rset.getFloat("bonus_value");
        Class<?> cls = getClass();
View Full Code Here

Examples of main.pattern.DBController.executeQuery()

    public static void main(String[] args) throws IOException {
        DBControllerCreator creator = new MySQLControllerCreator();
        DBController connection = creator.create();
        connection.executeQuery("Some query.");
        DBControllerCreator creator2 = new OracleControllerCreator();
        DBController connection2 = creator2.create();
        connection2.executeQuery("Some query.");
View Full Code Here

Examples of mondrian.test.TestContext.executeQuery()

        final TestContext context = getTestContext().withFreshConnection();
        try {
            // This MDX gets the [Product].[Product Family] cardinality
            // from the DB.

            // This MDX should be able to reuse the cardinality for
            // [Product].[Product Family]; and should not issue a SQL to fetch
            // that from DB again.
            assertQuerySqlOrNot(context, query2, patterns, true, false, false);
View Full Code Here

Examples of net.sf.saxon.javax.xml.xquery.XQPreparedExpression.executeQuery()

                bindParameters(transformer, message);

                bindDocument(message.getPayload(), transformer);

                XQResultSequence result = transformer.executeQuery();
                //No support for return Arrays yet
                List results = new ArrayList();
                while (result.next())
                    XQItem item = result.getItem();
View Full Code Here

Examples of oracle.jdbc.OracleStatement.executeQuery()

                // Register each table for database events, this is done by executing a select from the table.
                for (DatabaseTable table : this.descriptorsByTable.keySet()) {
                    OracleStatement statement = (OracleStatement)connection.createStatement();
                    try {
                        statement.executeQuery("SELECT ROWID FROM " + table.getQualifiedName()).close();
                        databaseSession.log(SessionLog.FINEST, SessionLog.CONNECTION, "dcn_register_table", table.getQualifiedName());
                    } catch (Exception failed) {
                        // This will fail if the table does not exist,
                        // just log the error to allow table creation to work.
                        databaseSession.logThrowable(SessionLog.WARNING, SessionLog.SQL, failed);
View Full Code Here

Examples of oracle.toplink.essentials.sessions.UnitOfWork.executeQuery()

            Object refreshedEntity = null;
            refreshedEntity = uow.executeQuery(query);
            if(refreshedEntity == null) {
                //bug3323, should also invalidate the shared cached object if object not exists in DB.
                throw new EntityNotFoundException(ExceptionLocalization.buildMessage("entity_no_longer_exists_in_db", new Object[]{entity}));
View Full Code Here
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.