org.postgresql.core.QueryExecutor.createSimpleQuery java code examples

Common ways to obtain QueryExecutor

private void myMethod () {
 QueryExecutor q =BaseConnection baseConnection;baseConnection.getQueryExecutor()
ProtocolConnection protocolConnection;protocolConnection.getQueryExecutor()
Smart code suggestions by Codota
}

public void addBatch(String p_sql) throws SQLException
{
  checkClosed();
  if (preparedQuery != null)
    throw new PSQLException(GT.tr("Can''t use query methods that take a query string on a PreparedStatement."),
                PSQLState.WRONG_OBJECT_TYPE);
  if (batchStatements == null)
  {
    batchStatements = new ArrayList();
    batchParameters = new ArrayList();
  }
  p_sql = replaceProcessing(p_sql);
  batchStatements.add(connection.getQueryExecutor().createSimpleQuery(p_sql));
  batchParameters.add(null);
}

public static byte[][] run(QueryExecutor executor, String queryString,
  boolean wantResults) throws SQLException {
 Query query = executor.createSimpleQuery(queryString);
 SimpleResultHandler handler = new SimpleResultHandler();
 int flags = QueryExecutor.QUERY_ONESHOT | QueryExecutor.QUERY_SUPPRESS_BEGIN
   | QueryExecutor.QUERY_EXECUTE_AS_SIMPLE;
 if (!wantResults) {
  flags |= QueryExecutor.QUERY_NO_RESULTS | QueryExecutor.QUERY_NO_METADATA;
 }
 try {
  executor.execute(query, null, handler, 0, 0, flags);
 } finally {
  query.close();
 }
 if (!wantResults) {
  return null;
 }
 List<byte[][]> tuples = handler.getResults();
 if (tuples == null || tuples.size() != 1) {
  throw new PSQLException(GT.tr("An unexpected result was returned by a query."),
    PSQLState.CONNECTION_UNABLE_TO_CONNECT);
 }
 return tuples.get(0);
}

public boolean executeWithFlags(String p_sql, int flags) throws SQLException
{
  checkClosed();
  p_sql = replaceProcessing(p_sql);
  Query simpleQuery = connection.getQueryExecutor().createSimpleQuery(p_sql);
  execute(simpleQuery, null, QueryExecutor.QUERY_ONESHOT | flags);
  this.lastSimpleQuery = simpleQuery;
  return (result != null && result.getResultSet() != null);
}

public static byte[][] run(ProtocolConnection protoConnection, String queryString, boolean wantResults) throws SQLException {
  QueryExecutor executor = protoConnection.getQueryExecutor();
  Query query = executor.createSimpleQuery(queryString);
  SimpleResultHandler handler = new SimpleResultHandler(protoConnection);
  int flags = QueryExecutor.QUERY_ONESHOT | QueryExecutor.QUERY_SUPPRESS_BEGIN;
  if (!wantResults)
    flags |= QueryExecutor.QUERY_NO_RESULTS | QueryExecutor.QUERY_NO_METADATA;
  try
  {
    executor.execute(query, null, handler, 0, 0, flags);
  }
  finally
  {
    query.close();
  }
  if (!wantResults)
    return null;
  Vector tuples = handler.getResults();
  if (tuples == null || tuples.size() != 1)
    throw new PSQLException(GT.tr("An unexpected result was returned by a query."), PSQLState.CONNECTION_UNABLE_TO_CONNECT);
  return (byte[][]) tuples.elementAt(0);
}

commitQuery = getQueryExecutor().createSimpleQuery("COMMIT");
rollbackQuery = getQueryExecutor().createSimpleQuery("ROLLBACK");

public void addBatch(String p_sql) throws SQLException
{
  checkClosed();
  if (preparedQuery != null)
    throw new PSQLException(GT.tr("Can''t use query methods that take a query string on a PreparedStatement."),
                PSQLState.WRONG_OBJECT_TYPE);
  if (batchStatements == null)
  {
    batchStatements = new ArrayList();
    batchParameters = new ArrayList();
  }
  p_sql = replaceProcessing(p_sql);
  batchStatements.add(connection.getQueryExecutor().createSimpleQuery(p_sql));
  batchParameters.add(null);
}

public void addBatch(String p_sql) throws SQLException
{
  checkClosed();
  if (preparedQuery != null)
    throw new PSQLException(GT.tr("Can''t use query methods that take a query string on a PreparedStatement."),
                PSQLState.WRONG_OBJECT_TYPE);
  if (batchStatements == null)
  {
    batchStatements = new ArrayList();
    batchParameters = new ArrayList();
  }
  p_sql = replaceProcessing(p_sql);
  batchStatements.add(connection.getQueryExecutor().createSimpleQuery(p_sql));
  batchParameters.add(null);
}

public boolean executeWithFlags(String p_sql, int flags) throws SQLException
{
  checkClosed();
  p_sql = replaceProcessing(p_sql);
  Query simpleQuery = connection.getQueryExecutor().createSimpleQuery(p_sql);
  execute(simpleQuery, null, QueryExecutor.QUERY_ONESHOT | flags);
  this.lastSimpleQuery = simpleQuery;
  return (result != null && result.getResultSet() != null);
}

public boolean executeWithFlags(String p_sql, int flags) throws SQLException
{
  checkClosed();
  p_sql = replaceProcessing(p_sql);
  Query simpleQuery = connection.getQueryExecutor().createSimpleQuery(p_sql);
  execute(simpleQuery, null, QueryExecutor.QUERY_ONESHOT | flags);
  this.lastSimpleQuery = simpleQuery;
  return (result != null && result.getResultSet() != null);
}

public static byte[][] run(ProtocolConnection protoConnection, String queryString, boolean wantResults) throws SQLException {
  QueryExecutor executor = protoConnection.getQueryExecutor();
  Query query = executor.createSimpleQuery(queryString);
  SimpleResultHandler handler = new SimpleResultHandler(protoConnection);
  int flags = QueryExecutor.QUERY_ONESHOT | QueryExecutor.QUERY_SUPPRESS_BEGIN;
  if (!wantResults)
    flags |= QueryExecutor.QUERY_NO_RESULTS | QueryExecutor.QUERY_NO_METADATA;
  try
  {
    executor.execute(query, null, handler, 0, 0, flags);
  }
  finally
  {
    query.close();
  }
  if (!wantResults)
    return null;
  Vector tuples = handler.getResults();
  if (tuples == null || tuples.size() != 1)
    throw new PSQLException(GT.tr("An unexpected result was returned by a query."), PSQLState.CONNECTION_UNABLE_TO_CONNECT);
  return (byte[][]) tuples.elementAt(0);
}

private byte[][] runSetupQuery(ProtocolConnectionImpl protoConnection, String queryString, boolean wantResults) throws SQLException {
  QueryExecutor executor = protoConnection.getQueryExecutor();
  Query query = executor.createSimpleQuery(queryString);
  SimpleResultHandler handler = new SimpleResultHandler(protoConnection);
  int flags = QueryExecutor.QUERY_ONESHOT | QueryExecutor.QUERY_SUPPRESS_BEGIN;
  if (!wantResults)
    flags |= QueryExecutor.QUERY_NO_RESULTS | QueryExecutor.QUERY_NO_METADATA;
  try
  {
    executor.execute(query, null, handler, 0, 0, flags);
  }
  finally
  {
    query.close();
  }
  if (!wantResults)
    return null;
  Vector tuples = handler.getResults();
  if (tuples == null || tuples.size() != 1)
    throw new PSQLException(GT.tr("An unexpected result was returned by a query."), PSQLState.CONNECTION_UNABLE_TO_CONNECT);
  return (byte[][]) tuples.elementAt(0);
}

commitQuery = getQueryExecutor().createSimpleQuery("COMMIT");
rollbackQuery = getQueryExecutor().createSimpleQuery("ROLLBACK");

commitQuery = getQueryExecutor().createSimpleQuery("COMMIT");
rollbackQuery = getQueryExecutor().createSimpleQuery("ROLLBACK");

Javadoc

Create an unparameterized Query object suitable for execution by this QueryExecutor. The provided query string is not parsed for parameter placeholders ('?' characters), and the Query#createParameterList of the returned object will always return an empty ParameterList.

Popular methods of QueryExecutor

createFastpathParameters
Create a new ParameterList implementation suitable for invoking a fastpath function via #fastpathCal
execute
Execute several Query, passing results to a provided ResultHandler.
fastpathCall
Invoke a backend function via the fastpath interface.
fetch
Fetch additional rows from a cursor.
processNotifies
Prior to attempting to retrieve notifications, we need to pull any recently received notifications o
startCopy
Issues a COPY FROM STDIN / COPY TO STDOUT statement and returns handler for associated operation. Un
createParameterizedQuery
Create a parameterized Query object suitable for execution by this QueryExecutor. The provided query
abort
Abort at network level without sending the Terminate message to the backend.
borrowCallableQuery
borrowQuery
borrowQueryByKey
borrowReturningQuery

Popular in Java

Parsing JSON documents to java classes using gson
getResourceAsStream (ClassLoader)
runOnUiThread (Activity)
scheduleAtFixedRate (ScheduledExecutorService)
Creates and executes a periodic action that becomes enabled first after the given initial delay, and
Font (java.awt)
The Font class represents fonts, which are used to render text in a visible way. A font provides the
Kernel (java.awt.image)
Proxy (java.net)
This class represents proxy server settings. A created instance of Proxy stores a type and an addres
ServerSocket (java.net)
This class represents a server-side socket that waits for incoming client connections. A ServerSocke
Annotation (javassist.bytecode.annotation)
The annotation structure.An instance of this class is returned bygetAnnotations() in AnnotationsAttr
JCheckBox (javax.swing)

How to use createSimpleQuerymethodin org.postgresql.core.QueryExecutor

Best Java code snippets using org.postgresql.core.QueryExecutor.createSimpleQuery (Showing top 13 results out of 315)

How to use
createSimpleQuery
method
in
org.postgresql.core.QueryExecutor