/** * INTERNAL: * Build the identity query for native sequencing. */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT @@IDENTITY"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT @@IDENTITY"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * PUBLIC: * TimesTen uses the Oracle syntax for getting the current timestamp. */ @Override public ValueReadQuery getTimestampQuery() { if (this.timestampQuery == null) { this.timestampQuery = new ValueReadQuery(); this.timestampQuery.setSQLString("SELECT SYSDATE FROM DUAL"); } return this.timestampQuery; }
/** * INTERNAL: Build the identity query for native sequencing. */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * PUBLIC: * The query to select the current system change number * from Oracle. * In order to execute this query a database administrator may need * to grant execute permission on pl/sql package DBMS_FLASHBACK. */ public ValueReadQuery getSystemChangeNumberQuery() { ValueReadQuery sCNQuery = new ValueReadQuery(); sCNQuery.setSQLString("SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL"); return sCNQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT @@IDENTITY"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT DISTINCT(DBINFO('sqlca.sqlerrd1')) FROM systables"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); selectQuery.setSQLString("values IDENTITY_VAL_LOCAL()"); return selectQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT @@IDENTITY"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
@Override public ValueReadQuery getTimestampQuery() { if (timestampQuery == null) { timestampQuery = new ValueReadQuery(); timestampQuery.setSQLString("SELECT CURRENT_TIMESTAMP()"); } return timestampQuery; }
/** * PUBLIC: * The query to select the current system change number * from Oracle. * In order to execute this query a database administrator may need * to grant execute permission on pl/sql package DBMS_FLASHBACK. */ public ValueReadQuery getSystemChangeNumberQuery() { ValueReadQuery sCNQuery = new ValueReadQuery(); sCNQuery.setSQLString("SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL"); return sCNQuery; }
/** * INTERNAL: * This method returns the query to select the timestamp from the server * for Derby. */ public ValueReadQuery getTimestampQuery() { if (timestampQuery == null) { timestampQuery = new ValueReadQuery(); timestampQuery.setSQLString("VALUES CURRENT_TIMESTAMP"); } return timestampQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. */ public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); StringWriter writer = new StringWriter(); writer.write("SELECT @@IDENTITY"); selectQuery.setSQLString(writer.toString()); return selectQuery; }
/** * INTERNAL: * Build the identity query for native sequencing. * * Taken verbatim from org.eclipse.persistence\foundation\org.eclipse.persistence.core\src\org\eclipse\persistence\platform\database\SQLServerPlatform.java * */ @Override public ValueReadQuery buildSelectQueryForIdentity() { ValueReadQuery selectQuery = new ValueReadQuery(); selectQuery.setSQLString("SELECT @@IDENTITY"); return selectQuery; }
protected ValueReadQuery buildSelectQuery(String seqName, Integer size) { ValueReadQuery selectQuery = new ValueReadQuery(); selectQuery.dontBindAllParameters(); StringWriter writer = new StringWriter(selectStringBufferSize + seqName.length()); writer.write(selectString1); writer.write(seqName); selectQuery.setSQLString(writer.toString()); return selectQuery; }
@Override public ValueReadQuery getTimestampQuery() { if (timestampQuery == null) { timestampQuery = new ValueReadQuery(); timestampQuery.setSQLString("SELECT CURRENT_TIMESTAMP()"); timestampQuery.setAllowNativeSQLQuery(true); } return timestampQuery; }
@Override public ValueReadQuery getTimestampQuery() { if (this.timestampQuery == null) { this.timestampQuery = new ValueReadQuery(); this.timestampQuery.setSQLString("CALL CURRENT_TIMESTAMP"); this.timestampQuery.setAllowNativeSQLQuery(true); } return this.timestampQuery; }
@Override public ValueReadQuery getTimestampQuery() { if (timestampQuery == null) { timestampQuery = new ValueReadQuery(); timestampQuery.setSQLString("SELECT CURRENT_TIMESTAMP()"); timestampQuery.setAllowNativeSQLQuery(true); } return timestampQuery; }
protected ValueReadQuery buildSelectQuery() { ValueReadQuery query = new ValueReadQuery(); query.addArgument(getNameFieldName()); StringWriter writer = new StringWriter(); writer.write("SELECT " + getCounterFieldName()); writer.write(" FROM " + getQualifiedTableName()); writer.write(" WHERE " + getNameFieldName()); writer.write(" = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; }
protected ValueReadQuery buildSelectQuery() { ValueReadQuery query = new ValueReadQuery(); query.addArgument(getNameFieldName()); StringWriter writer = new StringWriter(); writer.write("SELECT " + getCounterFieldName()); writer.write(" FROM " + getQualifiedTableName()); writer.write(" WHERE " + getNameFieldName()); writer.write(" = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; }