protected String getSequenceTableName(org.eclipse.persistence.sessions.Session session) { String sequenceTableName = null; if (session.getProject().usesSequencing()) { org.eclipse.persistence.sequencing.Sequence sequence = session.getLogin().getDefaultSequence(); if (sequence instanceof org.eclipse.persistence.sequencing.TableSequence) { sequenceTableName = ((org.eclipse.persistence.sequencing.TableSequence)sequence).getTableName(); } } return sequenceTableName; } }
/** * This returns the Sequence Table's qualified name, without delimiting. * @param session * @return the qualified table name */ protected String getSequenceTableName(Session session) { String sequenceTableName = null; if (session.getProject().usesSequencing()) { Sequence sequence = session.getLogin().getDefaultSequence(); if (sequence instanceof TableSequence) { sequenceTableName = ((TableSequence)sequence).getQualifiedTableName(); } } return sequenceTableName; }
/** * This returns the Sequence Table's qualified name, without delimiting. * @param session * @return the qualified table name */ protected String getSequenceTableName(Session session) { String sequenceTableName = null; if (session.getProject().usesSequencing()) { Sequence sequence = session.getLogin().getDefaultSequence(); if (sequence instanceof TableSequence) { sequenceTableName = ((TableSequence)sequence).getQualifiedTableName(); } } return sequenceTableName; }
Sequence seq = login.getSequence(sequenceName); if(seq instanceof DefaultSequence) { seq = login.getDefaultSequence();
definition.addArgument("SEQ_NAME", String.class, 100); definition.addArgument("PREALLOC_SIZE", java.math.BigDecimal.class, 10); definition.addStatement("UPDATE " + ((TableSequence)login.getDefaultSequence()).getTableName() + " SET " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " = " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " + " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "PREALLOC_SIZE WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); definition.addStatement("SELECT " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " FROM " + ((TableSequence)login.getDefaultSequence()).getTableName() + " WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); sequenceProcedures.put("SELECT", definition);
definition.addArgument("SEQ_NAME", String.class, 100); definition.addArgument("PREALLOC_SIZE", java.math.BigDecimal.class, 10); definition.addStatement("UPDATE " + ((TableSequence)login.getDefaultSequence()).getTableName() + " SET " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " = " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " + " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "PREALLOC_SIZE WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); definition.addStatement("SELECT " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " FROM " + ((TableSequence)login.getDefaultSequence()).getTableName() + " WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); sequenceProcedures.put("SELECT", definition);
definition.addArgument("SEQ_NAME", String.class, 100); definition.addArgument("PREALLOC_SIZE", java.math.BigDecimal.class, 10); definition.addStatement("UPDATE " + ((TableSequence)login.getDefaultSequence()).getTableName() + " SET " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " = " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " + " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "PREALLOC_SIZE WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); definition.addStatement("SELECT " + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + " FROM " + ((TableSequence)login.getDefaultSequence()).getTableName() + " WHERE " + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + " = " + getSession().getPlatform().getStoredProcedureParameterPrefix() + "SEQ_NAME"); sequenceProcedures.put("SELECT", definition);
Sequence seq = login.getSequence(sequenceName); if(seq instanceof DefaultSequence) { seq = login.getDefaultSequence();
Sequence seq = login.getSequence(sequenceName); if(seq instanceof DefaultSequence) { seq = login.getDefaultSequence();
method.addLine("login.setUsesNativeSequencing(" + login.shouldUseNativeSequencing() + ");"); if (!login.shouldUseNativeSequencing()) { method.addLine("login.setSequenceTableName(\"" + ((TableSequence)login.getDefaultSequence()).getTableName() + "\");"); method.addLine("login.setSequenceNameFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + "\");"); method.addLine("login.setSequenceCounterFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + "\");");
method.addLine("login.setUsesNativeSequencing(" + login.shouldUseNativeSequencing() + ");"); if (!login.shouldUseNativeSequencing()) { method.addLine("login.setSequenceTableName(\"" + ((TableSequence)login.getDefaultSequence()).getTableName() + "\");"); method.addLine("login.setSequenceNameFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + "\");"); method.addLine("login.setSequenceCounterFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + "\");");
method.addLine("login.setUsesNativeSequencing(" + login.shouldUseNativeSequencing() + ");"); if (!login.shouldUseNativeSequencing()) { method.addLine("login.setSequenceTableName(\"" + ((TableSequence)login.getDefaultSequence()).getTableName() + "\");"); method.addLine("login.setSequenceNameFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getNameFieldName() + "\");"); method.addLine("login.setSequenceCounterFieldName(\"" + ((TableSequence)login.getDefaultSequence()).getCounterFieldName() + "\");");