OmniSciDB  1dac507f6e
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Pages
com.omnisci.jdbc.OmniSciStatement Class Reference
+ Inheritance diagram for com.omnisci.jdbc.OmniSciStatement:
+ Collaboration diagram for com.omnisci.jdbc.OmniSciStatement:

Public Member Functions

ResultSet executeQuery (String sql) throws SQLException
 
int executeUpdate (String sql) throws SQLException
 
void close () throws SQLException
 
int getMaxFieldSize () throws SQLException
 
void setMaxFieldSize (int max) throws SQLException
 
int getMaxRows () throws SQLException
 
void setMaxRows (int max) throws SQLException
 
void setEscapeProcessing (boolean enable) throws SQLException
 
int getQueryTimeout () throws SQLException
 
int getQueryInternalExecuteTime () throws SQLException
 
void setQueryTimeout (int seconds) throws SQLException
 
void cancel () throws SQLException
 
SQLWarning getWarnings () throws SQLException
 
void clearWarnings () throws SQLException
 
void setCursorName (String name) throws SQLException
 
boolean execute (String sql) throws SQLException
 
ResultSet getResultSet () throws SQLException
 
int getUpdateCount () throws SQLException
 
boolean getMoreResults () throws SQLException
 
void setFetchDirection (int direction) throws SQLException
 
int getFetchDirection () throws SQLException
 
void setFetchSize (int rows) throws SQLException
 
int getFetchSize () throws SQLException
 
int getResultSetConcurrency () throws SQLException
 
int getResultSetType () throws SQLException
 
void addBatch (String sql) throws SQLException
 
void clearBatch () throws SQLException
 
int[] executeBatch () throws SQLException
 
Connection getConnection () throws SQLException
 
boolean getMoreResults (int current) throws SQLException
 
ResultSet getGeneratedKeys () throws SQLException
 
int executeUpdate (String sql, int autoGeneratedKeys) throws SQLException
 
int executeUpdate (String sql, int[] columnIndexes) throws SQLException
 
int executeUpdate (String sql, String[] columnNames) throws SQLException
 
boolean execute (String sql, int autoGeneratedKeys) throws SQLException
 
boolean execute (String sql, int[] columnIndexes) throws SQLException
 
boolean execute (String sql, String[] columnNames) throws SQLException
 
int getResultSetHoldability () throws SQLException
 
boolean isClosed () throws SQLException
 
void setPoolable (boolean poolable) throws SQLException
 
boolean isPoolable () throws SQLException
 
void closeOnCompletion () throws SQLException
 
boolean isCloseOnCompletion () throws SQLException
 
boolean isWrapperFor (Class<?> iface) throws SQLException
 

Static Public Member Functions

static String fnReplace (String sql)
 

Public Attributes

SQLWarning rootWarning = null
 

Package Functions

 OmniSciStatement (String tsession, MapD.Client tclient)
 
public< T > T unwrap (Class< T > iface) throws SQLException
 

Static Package Attributes

static final org.slf4j.Logger logger = LoggerFactory.getLogger(OmniSciStatement.class)
 

Private Attributes

String session
 
MapD.Client client
 
ResultSet currentRS = null
 
TQueryResult sqlResult = null
 
int maxRows = 100000
 
boolean escapeProcessing = false
 

Static Private Attributes

static final Pattern QUARTER
 
static final Pattern DAYOFYEAR
 
static final Pattern DAYOFWEEK
 
static final Pattern WEEK
 
static final Pattern QUARTER_TRUNC
 
static final Pattern MONTH_TRUNC
 
static final Pattern YEAR_TRUNC
 
static final Pattern MINUTE_TRUNC
 
static final Pattern SECOND_TRUNC
 
static final Pattern YEAR1_TRUNC
 
static final Pattern QUARTER1_TRUNC
 
static final Pattern WEEK_TRUNC
 

Detailed Description

Author
michael

Definition at line 35 of file OmniSciStatement.java.

Constructor & Destructor Documentation

com.omnisci.jdbc.OmniSciStatement.OmniSciStatement ( String  tsession,
MapD.Client  tclient 
)
inlinepackage

Member Function Documentation

void com.omnisci.jdbc.OmniSciStatement.addBatch ( String  sql) throws SQLException
inline

Definition at line 266 of file OmniSciStatement.java.

266  { // logger.debug("Entered");
267  throw new UnsupportedOperationException("Not supported yet,"
268  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
269  + " class:" + new Throwable().getStackTrace()[0].getClassName()
270  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
271  }
void com.omnisci.jdbc.OmniSciStatement.cancel ( ) throws SQLException
inline

Definition at line 161 of file OmniSciStatement.java.

161  { // logger.debug("Entered");
162  throw new UnsupportedOperationException("Not supported yet,"
163  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
164  + " class:" + new Throwable().getStackTrace()[0].getClassName()
165  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
166  }
void com.omnisci.jdbc.OmniSciStatement.clearBatch ( ) throws SQLException
inline

Definition at line 274 of file OmniSciStatement.java.

274  { // logger.debug("Entered");
275  throw new UnsupportedOperationException("Not supported yet,"
276  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
277  + " class:" + new Throwable().getStackTrace()[0].getClassName()
278  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
279  }
void com.omnisci.jdbc.OmniSciStatement.clearWarnings ( ) throws SQLException
inline

Definition at line 174 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.rootWarning.

174  { // logger.debug("Entered");
175  rootWarning = null;
176  }
void com.omnisci.jdbc.OmniSciStatement.close ( ) throws SQLException
inline

Definition at line 100 of file OmniSciStatement.java.

100  { // logger.debug("Entered");
101 
102  // clean up after -- nothing to do
103  }
void com.omnisci.jdbc.OmniSciStatement.closeOnCompletion ( ) throws SQLException
inline

Definition at line 402 of file OmniSciStatement.java.

402  { // logger.debug("Entered");
403  throw new UnsupportedOperationException("Not supported yet,"
404  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
405  + " class:" + new Throwable().getStackTrace()[0].getClassName()
406  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
407  }
boolean com.omnisci.jdbc.OmniSciStatement.execute ( String  sql) throws SQLException
inline

Definition at line 187 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.executeQuery().

187  { // logger.debug("Entered");
188  ResultSet rs = executeQuery(sql);
189  if (rs != null) {
190  return true;
191  } else {
192  return false;
193  }
194  }

+ Here is the call graph for this function:

boolean com.omnisci.jdbc.OmniSciStatement.execute ( String  sql,
int  autoGeneratedKeys 
) throws SQLException
inline

Definition at line 342 of file OmniSciStatement.java.

343  { // logger.debug("Entered");
344  throw new UnsupportedOperationException("Not supported yet,"
345  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
346  + " class:" + new Throwable().getStackTrace()[0].getClassName()
347  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
348  }
boolean com.omnisci.jdbc.OmniSciStatement.execute ( String  sql,
int[]  columnIndexes 
) throws SQLException
inline

Definition at line 351 of file OmniSciStatement.java.

352  { // logger.debug("Entered");
353  throw new UnsupportedOperationException("Not supported yet,"
354  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
355  + " class:" + new Throwable().getStackTrace()[0].getClassName()
356  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
357  }
boolean com.omnisci.jdbc.OmniSciStatement.execute ( String  sql,
String[]  columnNames 
) throws SQLException
inline

Definition at line 360 of file OmniSciStatement.java.

361  { // logger.debug("Entered");
362  throw new UnsupportedOperationException("Not supported yet,"
363  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
364  + " class:" + new Throwable().getStackTrace()[0].getClassName()
365  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
366  }
int [] com.omnisci.jdbc.OmniSciStatement.executeBatch ( ) throws SQLException
inline

Definition at line 282 of file OmniSciStatement.java.

282  { // logger.debug("Entered");
283  throw new UnsupportedOperationException("Not supported yet,"
284  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
285  + " class:" + new Throwable().getStackTrace()[0].getClassName()
286  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
287  }
ResultSet com.omnisci.jdbc.OmniSciStatement.executeQuery ( String  sql) throws SQLException
inline

Definition at line 52 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.currentRS, com.omnisci.jdbc.OmniSciStatement.fnReplace(), com.omnisci.jdbc.OmniSciStatement.maxRows, com.omnisci.jdbc.OmniSciStatement.session, split(), com.omnisci.jdbc.OmniSciStatement.sqlResult, and Experimental.String.

Referenced by com.omnisci.jdbc.OmniSciStatement.execute().

53  { // logger.debug("Entered");
54  if (maxRows > 0) {
55  // add limit to sql call if it doesn't already have one and is a select
56  String[] tokens = sql.toLowerCase().split(" ", 3);
57  if (tokens[0].equals("select")) {
58  if (sql.toLowerCase().contains("limit")) {
59  // do nothing
60  } else {
61  sql = sql + " LIMIT " + maxRows;
62  logger.debug("Added LIMIT of " + maxRows);
63  }
64  }
65  }
66  logger.debug("sql is :'" + sql + "'");
67  String afterFnSQL = fnReplace(sql);
68  logger.debug("afterFnSQL is :'" + afterFnSQL + "'");
69  try {
70  sqlResult = client.sql_execute(session, afterFnSQL + ";", true, null, -1, -1);
71  } catch (TMapDException ex) {
72  throw new SQLException("Query failed : " + ex.getError_msg());
73  } catch (TException ex) {
74  throw new SQLException("Query failed : " + ex.toString());
75  }
76 
77  currentRS = new OmniSciResultSet(sqlResult, sql);
78  return currentRS;
79  }
static String fnReplace(String sql)
std::vector< std::string > split(const std::string &str, const std::string &delim)
split apart a string into a vector of substrings

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

int com.omnisci.jdbc.OmniSciStatement.executeUpdate ( String  sql) throws SQLException
inline

Definition at line 82 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.session, and com.omnisci.jdbc.OmniSciStatement.sqlResult.

82  { // logger.debug("Entered");
83  try {
84  // remove " characters if it is a CREATE statement
85  if (sql.trim().substring(0, 6).compareToIgnoreCase("CREATE") == 0) {
86  sql = sql.replace('"', ' ');
87  }
88  sqlResult = client.sql_execute(session, sql + ";", true, null, -1, -1);
89  } catch (TMapDException ex) {
90  throw new SQLException(
91  "Query failed : " + ex.getError_msg() + " sql was '" + sql + "'");
92  } catch (TException ex) {
93  throw new SQLException("Query failed : " + ex.toString());
94  }
95 
96  return sqlResult.row_set.columns.size();
97  }
int com.omnisci.jdbc.OmniSciStatement.executeUpdate ( String  sql,
int  autoGeneratedKeys 
) throws SQLException
inline

Definition at line 315 of file OmniSciStatement.java.

316  { // logger.debug("Entered");
317  throw new UnsupportedOperationException("Not supported yet,"
318  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
319  + " class:" + new Throwable().getStackTrace()[0].getClassName()
320  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
321  }
int com.omnisci.jdbc.OmniSciStatement.executeUpdate ( String  sql,
int[]  columnIndexes 
) throws SQLException
inline

Definition at line 324 of file OmniSciStatement.java.

325  { // logger.debug("Entered");
326  throw new UnsupportedOperationException("Not supported yet,"
327  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
328  + " class:" + new Throwable().getStackTrace()[0].getClassName()
329  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
330  }
int com.omnisci.jdbc.OmniSciStatement.executeUpdate ( String  sql,
String[]  columnNames 
) throws SQLException
inline

Definition at line 333 of file OmniSciStatement.java.

334  { // logger.debug("Entered");
335  throw new UnsupportedOperationException("Not supported yet,"
336  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
337  + " class:" + new Throwable().getStackTrace()[0].getClassName()
338  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
339  }
static String com.omnisci.jdbc.OmniSciStatement.fnReplace ( String  sql)
inlinestatic

Definition at line 471 of file OmniSciStatement.java.

References Experimental.String.

Referenced by com.omnisci.jdbc.OmniSciStatement.executeQuery().

471  {
472  // need to iterate as each reduction of string opens up a anew match
473  String start;
474  do {
475  start = sql;
476  sql = QUARTER.matcher(sql).replaceAll(" EXTRACT(QUARTER FROM $1");
477  } while (!sql.equals(start));
478 
479  do {
480  start = sql;
481  sql = DAYOFYEAR.matcher(sql).replaceAll(" EXTRACT(DOY FROM $1");
482  } while (!sql.equals(start));
483 
484  do {
485  start = sql;
486  sql = DAYOFWEEK.matcher(sql).replaceAll(" EXTRACT(ISODOW FROM $1");
487  } while (!sql.equals(start));
488 
489  do {
490  start = sql;
491  sql = WEEK.matcher(sql).replaceAll(" EXTRACT(WEEK FROM $1");
492  } while (!sql.equals(start));
493 
494  // Order is important here, do not shuffle without checking
495  sql = QUARTER_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(QUARTER, $1)");
496  sql = YEAR_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(YEAR, $1)");
497  sql = SECOND_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(SECOND, $1)");
498  sql = QUARTER1_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(QUARTER, $1)");
499  sql = MONTH_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(MONTH, $1)");
500  sql = MINUTE_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(MINUTE, $1)");
501  sql = YEAR1_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(YEAR, $1)");
502  sql = WEEK_TRUNC.matcher(sql).replaceAll(" DATE_TRUNC(WEEK, $1)");
503 
504  do {
505  start = sql;
506  sql = QUARTER.matcher(sql).replaceAll(" EXTRACT(QUARTER FROM $1");
507  } while (!sql.equals(start));
508 
509  do {
510  start = sql;
511  sql = DAYOFYEAR.matcher(sql).replaceAll(" EXTRACT(DOY FROM $1");
512  } while (!sql.equals(start));
513 
514  do {
515  start = sql;
516  sql = DAYOFWEEK.matcher(sql).replaceAll(" EXTRACT(ISODOW FROM $1");
517  } while (!sql.equals(start));
518 
519  do {
520  start = sql;
521  sql = WEEK.matcher(sql).replaceAll(" EXTRACT(WEEK FROM $1");
522  } while (!sql.equals(start));
523 
524  return sql;
525  }

+ Here is the caller graph for this function:

Connection com.omnisci.jdbc.OmniSciStatement.getConnection ( ) throws SQLException
inline

Definition at line 290 of file OmniSciStatement.java.

290  { // logger.debug("Entered");
291  throw new UnsupportedOperationException("Not supported yet,"
292  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
293  + " class:" + new Throwable().getStackTrace()[0].getClassName()
294  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
295  }
int com.omnisci.jdbc.OmniSciStatement.getFetchDirection ( ) throws SQLException
inline

Definition at line 223 of file OmniSciStatement.java.

223  { // logger.debug("Entered");
224  throw new UnsupportedOperationException("Not supported yet,"
225  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
226  + " class:" + new Throwable().getStackTrace()[0].getClassName()
227  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
228  }
int com.omnisci.jdbc.OmniSciStatement.getFetchSize ( ) throws SQLException
inline

Definition at line 242 of file OmniSciStatement.java.

242  { // logger.debug("Entered");
243  throw new UnsupportedOperationException("Not supported yet,"
244  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
245  + " class:" + new Throwable().getStackTrace()[0].getClassName()
246  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
247  }
ResultSet com.omnisci.jdbc.OmniSciStatement.getGeneratedKeys ( ) throws SQLException
inline

Definition at line 307 of file OmniSciStatement.java.

307  { // logger.debug("Entered");
308  throw new UnsupportedOperationException("Not supported yet,"
309  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
310  + " class:" + new Throwable().getStackTrace()[0].getClassName()
311  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
312  }
int com.omnisci.jdbc.OmniSciStatement.getMaxFieldSize ( ) throws SQLException
inline

Definition at line 106 of file OmniSciStatement.java.

106  { // logger.debug("Entered");
107  throw new UnsupportedOperationException("Not supported yet,"
108  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
109  + " class:" + new Throwable().getStackTrace()[0].getClassName()
110  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
111  }
int com.omnisci.jdbc.OmniSciStatement.getMaxRows ( ) throws SQLException
inline

Definition at line 122 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.maxRows.

122  { // logger.debug("Entered");
123  return maxRows;
124  }
boolean com.omnisci.jdbc.OmniSciStatement.getMoreResults ( ) throws SQLException
inline

Definition at line 208 of file OmniSciStatement.java.

208  { // logger.debug("Entered");
209  // TODO MAT this needs to be fixed for complex queries
210  return false;
211  }
boolean com.omnisci.jdbc.OmniSciStatement.getMoreResults ( int  current) throws SQLException
inline

Definition at line 298 of file OmniSciStatement.java.

299  { // logger.debug("Entered");
300  throw new UnsupportedOperationException("Not supported yet,"
301  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
302  + " class:" + new Throwable().getStackTrace()[0].getClassName()
303  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
304  }
int com.omnisci.jdbc.OmniSciStatement.getQueryInternalExecuteTime ( ) throws SQLException
inline

Definition at line 143 of file OmniSciStatement.java.

144  { // logger.debug("Entered");
145  return (int) sqlResult.execution_time_ms;
146  }
int com.omnisci.jdbc.OmniSciStatement.getQueryTimeout ( ) throws SQLException
inline

Definition at line 138 of file OmniSciStatement.java.

138  { // logger.debug("Entered");
139  return 0;
140  }
ResultSet com.omnisci.jdbc.OmniSciStatement.getResultSet ( ) throws SQLException
inline

Definition at line 197 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.currentRS.

197  { // logger.debug("Entered");
198  return currentRS;
199  }
int com.omnisci.jdbc.OmniSciStatement.getResultSetConcurrency ( ) throws SQLException
inline

Definition at line 250 of file OmniSciStatement.java.

250  { // logger.debug("Entered");
251  throw new UnsupportedOperationException("Not supported yet,"
252  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
253  + " class:" + new Throwable().getStackTrace()[0].getClassName()
254  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
255  }
int com.omnisci.jdbc.OmniSciStatement.getResultSetHoldability ( ) throws SQLException
inline

Definition at line 369 of file OmniSciStatement.java.

369  { // logger.debug("Entered");
370  throw new UnsupportedOperationException("Not supported yet,"
371  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
372  + " class:" + new Throwable().getStackTrace()[0].getClassName()
373  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
374  }
int com.omnisci.jdbc.OmniSciStatement.getResultSetType ( ) throws SQLException
inline

Definition at line 258 of file OmniSciStatement.java.

258  { // logger.debug("Entered");
259  throw new UnsupportedOperationException("Not supported yet,"
260  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
261  + " class:" + new Throwable().getStackTrace()[0].getClassName()
262  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
263  }
int com.omnisci.jdbc.OmniSciStatement.getUpdateCount ( ) throws SQLException
inline

Definition at line 202 of file OmniSciStatement.java.

202  { // logger.debug("Entered");
203  // TODO MAT fix update count
204  return 0;
205  }
SQLWarning com.omnisci.jdbc.OmniSciStatement.getWarnings ( ) throws SQLException
inline

Definition at line 169 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.rootWarning.

169  { // logger.debug("Entered");
170  return (rootWarning);
171  }
boolean com.omnisci.jdbc.OmniSciStatement.isClosed ( ) throws SQLException
inline

Definition at line 377 of file OmniSciStatement.java.

377  { // logger.debug("Entered");
378  throw new UnsupportedOperationException("Not supported yet,"
379  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
380  + " class:" + new Throwable().getStackTrace()[0].getClassName()
381  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
382  }
boolean com.omnisci.jdbc.OmniSciStatement.isCloseOnCompletion ( ) throws SQLException
inline

Definition at line 410 of file OmniSciStatement.java.

410  { // logger.debug("Entered");
411  throw new UnsupportedOperationException("Not supported yet,"
412  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
413  + " class:" + new Throwable().getStackTrace()[0].getClassName()
414  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
415  }
boolean com.omnisci.jdbc.OmniSciStatement.isPoolable ( ) throws SQLException
inline

Definition at line 394 of file OmniSciStatement.java.

394  { // logger.debug("Entered");
395  throw new UnsupportedOperationException("Not supported yet,"
396  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
397  + " class:" + new Throwable().getStackTrace()[0].getClassName()
398  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
399  }
boolean com.omnisci.jdbc.OmniSciStatement.isWrapperFor ( Class<?>  iface) throws SQLException
inline

Definition at line 426 of file OmniSciStatement.java.

427  { // logger.debug("Entered");
428  throw new UnsupportedOperationException("Not supported yet,"
429  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
430  + " class:" + new Throwable().getStackTrace()[0].getClassName()
431  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
432  }
void com.omnisci.jdbc.OmniSciStatement.setCursorName ( String  name) throws SQLException
inline

Definition at line 179 of file OmniSciStatement.java.

179  { // logger.debug("Entered");
180  throw new UnsupportedOperationException("Not supported yet,"
181  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
182  + " class:" + new Throwable().getStackTrace()[0].getClassName()
183  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
184  }
void com.omnisci.jdbc.OmniSciStatement.setEscapeProcessing ( boolean  enable) throws SQLException
inline

Definition at line 132 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.escapeProcessing.

133  { // logger.debug("Entered");
134  escapeProcessing = enable;
135  }
void com.omnisci.jdbc.OmniSciStatement.setFetchDirection ( int  direction) throws SQLException
inline

Definition at line 214 of file OmniSciStatement.java.

215  { // logger.debug("Entered");
216  throw new UnsupportedOperationException("Not supported yet,"
217  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
218  + " class:" + new Throwable().getStackTrace()[0].getClassName()
219  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
220  }
void com.omnisci.jdbc.OmniSciStatement.setFetchSize ( int  rows) throws SQLException
inline

Definition at line 231 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.rootWarning.

231  { // logger.debug("Entered");
232  SQLWarning warning = new SQLWarning(
233  "Query FetchSize are not supported. Substituting a value of zero.");
234  if (rootWarning == null) {
235  rootWarning = warning;
236  } else {
237  rootWarning.setNextWarning(warning);
238  }
239  }
void com.omnisci.jdbc.OmniSciStatement.setMaxFieldSize ( int  max) throws SQLException
inline

Definition at line 114 of file OmniSciStatement.java.

114  { // logger.debug("Entered");
115  throw new UnsupportedOperationException("Not supported yet,"
116  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
117  + " class:" + new Throwable().getStackTrace()[0].getClassName()
118  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
119  }
void com.omnisci.jdbc.OmniSciStatement.setMaxRows ( int  max) throws SQLException
inline

Definition at line 127 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.maxRows.

127  { // logger.debug("Entered");
128  maxRows = max;
129  }
void com.omnisci.jdbc.OmniSciStatement.setPoolable ( boolean  poolable) throws SQLException
inline

Definition at line 385 of file OmniSciStatement.java.

386  { // logger.debug("Entered");
387  throw new UnsupportedOperationException("Not supported yet,"
388  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
389  + " class:" + new Throwable().getStackTrace()[0].getClassName()
390  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
391  }
void com.omnisci.jdbc.OmniSciStatement.setQueryTimeout ( int  seconds) throws SQLException
inline

Definition at line 149 of file OmniSciStatement.java.

References com.omnisci.jdbc.OmniSciStatement.rootWarning.

150  { // logger.debug("Entered");
151  SQLWarning warning = new SQLWarning(
152  "Query timeouts are not supported. Substituting a value of zero.");
153  if (rootWarning == null) {
154  rootWarning = warning;
155  } else {
156  rootWarning.setNextWarning(warning);
157  }
158  }
public<T> T com.omnisci.jdbc.OmniSciStatement.unwrap ( Class< T >  iface) throws SQLException
inlinepackage

Definition at line 418 of file OmniSciStatement.java.

418  { // logger.debug("Entered");
419  throw new UnsupportedOperationException("Not supported yet,"
420  + " line:" + new Throwable().getStackTrace()[0].getLineNumber()
421  + " class:" + new Throwable().getStackTrace()[0].getClassName()
422  + " method:" + new Throwable().getStackTrace()[0].getMethodName());
423  }

Member Data Documentation

MapD.Client com.omnisci.jdbc.OmniSciStatement.client
private
ResultSet com.omnisci.jdbc.OmniSciStatement.currentRS = null
private
final Pattern com.omnisci.jdbc.OmniSciStatement.DAYOFWEEK
staticprivate
Initial value:
= Pattern.compile(
"\\sDAYOFWEEK\\(([^\\{]*?)", Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 438 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.DAYOFYEAR
staticprivate
Initial value:
= Pattern.compile(
"\\sDAYOFYEAR\\(([^\\{]*?)", Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 436 of file OmniSciStatement.java.

boolean com.omnisci.jdbc.OmniSciStatement.escapeProcessing = false
private
final org.slf4j.Logger com.omnisci.jdbc.OmniSciStatement.logger = LoggerFactory.getLogger(OmniSciStatement.class)
staticpackage

Definition at line 36 of file OmniSciStatement.java.

int com.omnisci.jdbc.OmniSciStatement.maxRows = 100000
private
final Pattern com.omnisci.jdbc.OmniSciStatement.MINUTE_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ EXTRACT\\(HOUR FROM .*?\\) \\* INTERVAL '1' HOUR\\) \\+ EXTRACT\\(MINUTE FROM .*?\\) \\* INTERVAL '1' MINUTE\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 452 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.MONTH_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(DAY FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' DAY\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 445 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.QUARTER
staticprivate
Initial value:
= Pattern.compile(
"\\sQUARTER\\(([^\\{]*?)", Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 434 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.QUARTER1_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(DOY FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' DAY\\) \\+ FLOOR\\(\\(3 \\* \\( FLOOR\\( EXTRACT\\(QUARTER FROM .*?\\)\\) \\- 1\\)\\)\\) \\* INTERVAL '1' MONTH\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 463 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.QUARTER_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(\\(\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(DAY FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' DAY\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(MONTH FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' MONTH\\) \\+ FLOOR\\(\\(3 \\* \\( FLOOR\\( EXTRACT\\(QUARTER FROM .*?\\)\\) - 1\\)\\)\\) \\* INTERVAL '1' MONTH\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 442 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.SECOND_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(\\(\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ EXTRACT\\(HOUR FROM .*?\\) \\* INTERVAL '1' HOUR\\) \\+ EXTRACT\\(MINUTE FROM .*?\\) \\* INTERVAL '1' MINUTE\\) \\+ EXTRACT\\(SECOND FROM .*?\\) \\* INTERVAL '1' SECOND\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 455 of file OmniSciStatement.java.

TQueryResult com.omnisci.jdbc.OmniSciStatement.sqlResult = null
private
final Pattern com.omnisci.jdbc.OmniSciStatement.WEEK
staticprivate
Initial value:
= Pattern.compile(
"\\sWEEK\\(([^\\{]*?)", Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 440 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.WEEK_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ \\(\\-1 \\* \\( EXTRACT\\(ISODOW FROM .*?\\) \\- 1\\)\\) \\* INTERVAL '1' DAY\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 467 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.YEAR1_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(DOY FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' DAY\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 459 of file OmniSciStatement.java.

final Pattern com.omnisci.jdbc.OmniSciStatement.YEAR_TRUNC
staticprivate
Initial value:
= Pattern.compile(
"\\(\\(CAST\\(([^\\(]*?) AS DATE\\) \\+ FLOOR\\(\\(\\-1 \\* \\( EXTRACT\\(DAY FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' DAY\\) \\+ FLOOR\\(\\(\\-1\\ \\* \\( EXTRACT\\(MONTH FROM .*?\\) \\- 1\\)\\)\\) \\* INTERVAL '1' MONTH\\)",
Pattern.DOTALL | Pattern.CASE_INSENSITIVE)

Definition at line 448 of file OmniSciStatement.java.


The documentation for this class was generated from the following file: