public class SQLServerTransform extends java.lang.Object implements SQLSpecificTransform
Constructor and Description |
---|
SQLServerTransform(java.sql.Connection con) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getSequenceNextValue(java.lang.String seqName)
Get the next sequence value and update the maxsequence table.
|
java.lang.String |
nextval(java.lang.String seqName) |
java.lang.String |
transform(java.lang.String sql)
If given an insert with a *Seq.nextval value, this will figure out the
value and replace it with the next sequence value.
|
public SQLServerTransform(java.sql.Connection con) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String transform(java.lang.String sql) throws java.sql.SQLException
transform
in interface SQLSpecificTransform
MXException
java.sql.SQLException
psdi.dbmanage.connection.DatabaseConnection#doSql(java.lang.String)
public java.lang.String getSequenceNextValue(java.lang.String seqName) throws java.sql.SQLException
seqName
- the name of the sequence.java.lang.Exception
- If the sequence isn't found in MaxSequence, or a SQLException.java.sql.SQLException
public java.lang.String nextval(java.lang.String seqName) throws java.sql.SQLException
nextval
in interface SQLSpecificTransform
java.sql.SQLException