/** * Trigger name for simulating auto-assign values on the given column. */ protected String getGeneratedKeyTriggerName(Column col) { // replace trailing _SEQ with _TRG String seqName = getGeneratedKeySequenceName(col); return seqName.substring(0, seqName.length() - 3) + "TRG"; }
/** * Trigger name for simulating auto-assign values on the given column. */ protected String getGeneratedKeyTriggerName(Column col) { // replace trailing _SEQ with _TRG String seqName = getGeneratedKeySequenceName(col); return seqName.substring(0, seqName.length() - 3) + "TRG"; }
/** * Trigger name for simulating auto-assign values on the given column. */ protected String getGeneratedKeyTriggerName(Column col) { // replace trailing _SEQ with _TRG String seqName = getGeneratedKeySequenceName(col); return seqName.substring(0, seqName.length() - 3) + "TRG"; }
/** * Trigger name for simulating auto-assign values on the given column. */ protected String getGeneratedKeyTriggerName(Column col) { // replace trailing _SEQ with _TRG String seqName = getGeneratedKeySequenceName(col); return seqName.substring(0, seqName.length() - 3) + "TRG"; }
/** * Trigger name for simulating auto-assign values on the given column. */ protected String getGeneratedKeyTriggerName(Column col) { // replace trailing _SEQ with _TRG String seqName = getGeneratedKeySequenceName(col); return seqName.substring(0, seqName.length() - 3) + "TRG"; }
@Override public Object getGeneratedKey(Column col, Connection conn) throws SQLException { if (!useTriggersForAutoAssign) return 0L; // if we simulate auto-assigned columns using triggers and // sequences, then return the current value of the sequence // from autoAssignSequenceName String seq = autoAssignSequenceName; if (seq == null && openjpa3GeneratedKeyNames) seq = getOpenJPA3GeneratedKeySequenceName(col); else if (seq == null) seq = getGeneratedKeySequenceName(col); PreparedStatement stmnt = conn.prepareStatement("SELECT " + seq + ".currval FROM DUAL"); ResultSet rs = null; try { setTimeouts(stmnt, conf, false); rs = stmnt.executeQuery(); rs.next(); return rs.getLong(1); } finally { if (rs != null) try { rs.close(); } catch (SQLException se) {} try { stmnt.close(); } catch (SQLException se) {} } }
@Override public Object getGeneratedKey(Column col, Connection conn) throws SQLException { if (!useTriggersForAutoAssign) return 0L; // if we simulate auto-assigned columns using triggers and // sequences, then return the current value of the sequence // from autoAssignSequenceName String seq = autoAssignSequenceName; if (seq == null && openjpa3GeneratedKeyNames) seq = getOpenJPA3GeneratedKeySequenceName(col); else if (seq == null) seq = getGeneratedKeySequenceName(col); PreparedStatement stmnt = conn.prepareStatement("SELECT " + seq + ".currval FROM DUAL"); ResultSet rs = null; try { setTimeouts(stmnt, conf, false); rs = stmnt.executeQuery(); rs.next(); return rs.getLong(1); } finally { if (rs != null) try { rs.close(); } catch (SQLException se) {} try { stmnt.close(); } catch (SQLException se) {} } }
@Override public Object getGeneratedKey(Column col, Connection conn) throws SQLException { if (!useTriggersForAutoAssign) return 0L; // if we simulate auto-assigned columns using triggers and // sequences, then return the current value of the sequence // from autoAssignSequenceName String seq = autoAssignSequenceName; if (seq == null && openjpa3GeneratedKeyNames) seq = getOpenJPA3GeneratedKeySequenceName(col); else if (seq == null) seq = getGeneratedKeySequenceName(col); PreparedStatement stmnt = conn.prepareStatement("SELECT " + seq + ".currval FROM DUAL"); ResultSet rs = null; try { setTimeouts(stmnt, conf, false); rs = stmnt.executeQuery(); rs.next(); return rs.getLong(1); } finally { if (rs != null) try { rs.close(); } catch (SQLException se) {} try { stmnt.close(); } catch (SQLException se) {} } }
@Override public Object getGeneratedKey(Column col, Connection conn) throws SQLException { if (!useTriggersForAutoAssign) return 0L; // if we simulate auto-assigned columns using triggers and // sequences, then return the current value of the sequence // from autoAssignSequenceName String seq = autoAssignSequenceName; if (seq == null && openjpa3GeneratedKeyNames) seq = getOpenJPA3GeneratedKeySequenceName(col); else if (seq == null) seq = getGeneratedKeySequenceName(col); PreparedStatement stmnt = conn.prepareStatement("SELECT " + seq + ".currval FROM DUAL"); ResultSet rs = null; try { setTimeouts(stmnt, conf, false); rs = stmnt.executeQuery(); rs.next(); return rs.getLong(1); } finally { if (rs != null) try { rs.close(); } catch (SQLException se) {} try { stmnt.close(); } catch (SQLException se) {} } }
public Object getGeneratedKey(Column col, Connection conn) throws SQLException { if (!useTriggersForAutoAssign) return Numbers.valueOf(0L); // if we simulate auto-assigned columns using triggers and // sequences, then return the current value of the sequence // from autoAssignSequenceName String seq = autoAssignSequenceName; if (seq == null && openjpa3GeneratedKeyNames) seq = getOpenJPA3GeneratedKeySequenceName(col); else if (seq == null) seq = getGeneratedKeySequenceName(col); PreparedStatement stmnt = conn.prepareStatement("SELECT " + seq + ".currval FROM DUAL"); ResultSet rs = null; try { rs = stmnt.executeQuery(); rs.next(); return Numbers.valueOf(rs.getLong(1)); } finally { if (rs != null) try { rs.close(); } catch (SQLException se) {} try { stmnt.close(); } catch (SQLException se) {} } }
seq = getOpenJPA3GeneratedKeySequenceName(cols[i]); else seq = getGeneratedKeySequenceName(cols[i]); seqs.add("CREATE SEQUENCE " + seq + " START WITH 1");
seq = getOpenJPA3GeneratedKeySequenceName(cols[i]); else seq = getGeneratedKeySequenceName(cols[i]); seqs.add("CREATE SEQUENCE " + seq + " START WITH 1");
seq = getOpenJPA3GeneratedKeySequenceName(cols[i]); else seq = getGeneratedKeySequenceName(cols[i]); seqs.add("CREATE SEQUENCE " + seq + " START WITH 1");
seq = getOpenJPA3GeneratedKeySequenceName(cols[i]); else seq = getGeneratedKeySequenceName(cols[i]); seqs.add("CREATE SEQUENCE " + seq + " START WITH 1");
seq = getOpenJPA3GeneratedKeySequenceName(cols[i]); else seq = getGeneratedKeySequenceName(cols[i]); seqs.add("CREATE SEQUENCE " + seq + " START WITH 1");