Examples of com.datastax.driver.core.Session.execute()

com.datastax.driver.core.Session.execute()
Executes the provided query. This is a convenience method for {@code execute(new SimpleStatement(query))}. @param query the CQL query to execute. @return the result of the query. That result will never be null but canbe empty (and will be for any non SELECT query). @throws NoHostAvailableException if no host in the cluster can becontacted successfully to execute this query. @throws QueryExecutionException if the query triggered an executionexception, i.e. an exception thrown by Cassandra when it cannot execute the query with the requested consistency level successfully. @throws QueryValidationException if the query if invalid (syntax error,unauthorized or any other validation problem).


    @Test
    public void userTypeMeta() throws InterruptedException {
        Session session = cluster.connect();
        try {
            session.execute("CREATE TYPE udttest.phone ( cntry varchar, city varchar, num varchar )");
            session.execute("CREATE TYPE udttest.address ( street varchar, city varchar, country varchar, ph_num phone )");


            Thread.sleep(500L);


            KeyspaceMetadata ksm = cluster.getMetadata().getKeyspace("udttest");

View Full Code Here

    @Test
    public void userTypeMeta() throws InterruptedException {
        Session session = cluster.connect();
        try {
            session.execute("CREATE TYPE udttest.phone ( cntry varchar, city varchar, num varchar )");
            session.execute("CREATE TYPE udttest.address ( street varchar, city varchar, country varchar, ph_num phone )");


            Thread.sleep(500L);


            KeyspaceMetadata ksm = cluster.getMetadata().getKeyspace("udttest");
            Collection<UserType> uts = ksm.getUserTypes();

View Full Code Here

            try {
                session = cluster.connect();


                if (keyspaceExists(session, keyspaceName)) {
                    System.out.println("Dropping keyspace " + keyspaceName);
                    session.execute("DROP KEYSPACE " + keyspaceName).one();
                    for (int j = 0; j < 100; j++) {
                        if (!keyspaceExists(session, keyspaceName)) {
                            break;
                        }
                        try {

View Full Code Here

                        Assert.fail("could not drop keyspace " + keyspaceName);
                    }
                }


                System.out.println("Creating keyspace " + keyspaceName);
                session
                    .execute("CREATE KEYSPACE " + keyspaceName + " WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 2 }")
                    .one();
                for (int j = 0; j < 100; j++) {
                    if (keyspaceExists(session, keyspaceName)) {
                        break;

View Full Code Here


        if (LOGGER.isDebugEnabled()) {
            LOGGER.debug("Lazy load of {} attributes for {}", attrs.length, type);
        }


        ResultSet resultSet = session.execute(bStmt);
        Row row = resultSet.one();
        if (row != null) {
            Retriever retriever = new GettableRetriever(persistenceSession.persistenceManager.protocolVersion, row, loadColumns);
            for (MappedAttribute attr : attrs) {
                Object instance = resolveParentInstance(container, attr);

View Full Code Here


        if (LOGGER.isDebugEnabled()) {
            LOGGER.debug("Lazy load of {} attributes for {}", attrs.length, type);
        }


        ResultSet resultSet = session.execute(bStmt);
        Row row = resultSet.one();
        if (row != null) {
            Retriever retriever = new GettableRetriever(persistenceSession.persistenceManager.protocolVersion, row, loadColumns);
            for (MappedAttribute attr : attrs) {
                Object instance = resolveParentInstance(container, attr);

View Full Code Here

    KeyspaceMetadata kmd = system.getCluster().getMetadata().getKeyspace(keyspace);
    if (kmd != null) {
      return;
    }


    system.execute(toCql(createKeyspace().name(keyspace).withSimpleReplication()));
    system.close();
  }
}

View Full Code Here


        final String query = String.format("" + "CREATE keyspace %s "
            + "WITH replication = "
            + "{'class': 'SimpleStrategy', "
            + "'replication_factor' : 3}", keyspace);
        session.execute(query);
        _log.info("Finished creating keyspace {} .", keyspace);
      } catch (Exception e) {
        _log.error("Error creating keyspace {}", keyspace, e);
        error = e;
      }

View Full Code Here


    boolean tableExists = true;
    try {
      _log.info("Started checking whether table {} exists...", table);
      session = _rootCluster.connect(keyspace);
      session.execute(String.format("SELECT * FROM %s LIMIT 10", table));


      _log.info("Finished checking whether table {} exists...", table);
      _log.info("Table {} exists, nothing to do.", table);
    }
    // Keyspace does not exist, so we try to create it.

View Full Code Here

          try {
            _log.info("Started creating table {} ...", table);
            final String createQuery = QueryStringBuilder
                .createCreateTableQuery(context);
            _log.debug("Executing create query: {}", createQuery);
            session.execute(createQuery);
            _log.info("Finished creating table {} .", table);
          } catch (Exception e) {
            _log.error("Error creating table {} .", table);
            error = e;
          }

View Full Code Here

0 1 2 3 4

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.