protocol.tests

derby database source code.good for you.

DISPLAY "Test invalid DSS - wrong length"
startDdm MGRLVLLS
endDdm
startDdm MGRLVLLS
endDdm
flush
checkerror SYNTAXRM 8 1 0
endTest
//
DISPLAY "Test invalid DSS - missing D0 "
writeScalar2Bytes MGRLVLLS 1
flush
checkerror SYNTAXRM 8 3 0
endTest
//
DISPLAY "Test invalid DSS - REPLY DSS"
createDssReply 
endDss
flush
checkerror SYNTAXRM 8 4 0
endTest
//
DISPLAY "First codepoint not EXCSAT"
createDssRequest
startDdm MGRLVLLS
endDdm
endDss
flush
checkerror PRCCNVRM 8 6
endTest
//
DISPLAY "Test EXTNAM too long"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "testttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt"
endDdm
endDss
flush
checkError SYNTAXRM 8 9 EXTNAM
endTest
//
DISPLAY "Test non null SPVNAM"
createDssRequest
startDdm EXCSAT
writeScalarString SPVNAM"testttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt"
endDdm
endDss
flush
checkError SYNTAXRM 8 11 SPVNAM
endTest
//
DISPLAY "Test too big SRVNAM"
createDssRequest
startDdm EXCSAT
writeScalarString SRVNAM"testttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt"
endDdm
endDss
flush
checkError SYNTAXRM 8 9 SRVNAM
endTest
//
DISPLAY "Test too big SRVRLSLV"
createDssRequest
startDdm EXCSAT
writeScalarString SRVRLSLV"testttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt"
endDdm
endDss
flush
checkError SYNTAXRM 8 9 SRVRLSLV
endTest
//
DISPLAY "Test too big SRVCLSNM"
createDssRequest
startDdm EXCSAT
writeScalarString SRVCLSNM"testttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt"
endDdm
endDss
flush
checkError SYNTAXRM 8 9 SRVCLSNM
endTest
//
DISPLAY "Repeated manager levels with different values"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
startDdm MGRLVLLS
writeCodePoint4Bytes AGENT 3
writeCodePoint4Bytes AGENT 7
endDdm
endDdm
endDss
flush
checkerror MGRLVLRM 8 AGENT 7
endTest
//
DISPLAY "Missing required SECMEC on ACCSEC"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkerror SYNTAXRM 8 14 SECMEC
endTest
//
DISPLAY "ACCSEC doesn't follow EXCSAT"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm MGRLVLLS
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkerror PRCCNVRM 8 17
endTest
//
DISPLAY "Test trying security mechanism we don't support"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 1 // DCE
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
readScalar2Bytes SECMEC 3// SECMEC
readScalar2Bytes SECMEC 9// SECMEC
readScalar2Bytes SECMEC 4// SECMEC
readScalar1Byte SECCHKCD 1// SECMEC
endTest
//
DISPLAY "Test trying too big on SECMEC"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
startDdm SECMEC
writeInt 2 
endDdm
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkError SYNTAXRM 8 9 SECMEC
endTest
//
DISPLAY "Test trying too small on SECMEC"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
startDdm SECMEC
writeByte 2 
endDdm
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkError SYNTAXRM 8 11 SECMEC
endTest
//
DISPLAY "Test non null SECMGRNM"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalarString SECMGRNM "Fred"
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkError SYNTAXRM 8 11 SECMGRNM
endTest
//
DISPLAY "Test missing RDBNAM on ACCSEC"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 9 // Encrypted userid password
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkerror SYNTAXRM 8 14 RDBNAM
endTest
//
DISPLAY "Test specifying encrypted security mechanism without a security token"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 9 // Encrypted userid password
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
readScalar2Bytes SECMEC 9 // SECMEC encrypted userid password
readScalar1Byte SECCHKCD MULTIVALSTART 10 SEP 14 MULTIVALEND // can not start decryption manager for all jdks except ibm14
endTest
//
DISPLAY "Test specifying unencrypted security mechanism with a security token"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 3 // Encrypted userid password
writeScalarPaddedBytes RDBNAM test 18
startDdm SECTKN
writeBytes "0x01010101"
endDdm
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
readScalar2Bytes SECMEC 3 // SECMEC encrypted userid password
readScalar1Byte SECCHKCD 14 // missing security token
endTest
//
DISPLAY "Test SECCHK not following after ACCSEC"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 9 // userid password
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
skipDss		// don't care about the ACCSECRD so just skip
createDssRequest
startDdm MGRLVLLS
endDdm
endDss
flush
checkerror PRCCNVRM 8 17
endTest
//
DISPLAY "Test doing two tries for security mechanism"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 1 // DCE
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
readScalar2Bytes SECMEC 3// SECMEC
readScalar2Bytes SECMEC 9// SECMEC
readScalar2Bytes SECMEC 4// SECMEC
readScalar1Byte SECCHKCD 1// SECMEC
// ok send one we support
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 3 // userid password
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
readScalar2Bytes SECMEC 3// SECMEC
endTest
//
DISPLAY "Test missing SECMEC on SECCHK"
include "excsat_accsecrd1.inc"
createDssRequest
startDdm  SECCHK
endDdm
endDss
flush
checkerror SYNTAXRM 8 14 SECMEC
endTest
//
DISPLAY "Test different SECMEC on SECCHK than on ACCSEC"
include "excsat_accsecrd1.inc"
createDssRequest
startDdm  SECCHK
writeScalar2Bytes SECMEC 4 // userid password
endDdm
endDss
flush
//not sure what the error should be here (using invalid value for now)
checkerror SYNTAXRM 8 20 SECMEC
endTest
//
DISPLAY "Test invalid length for RDBNAM"
createDssRequest
startDdm EXCSAT
writeScalarString EXTNAM "test"
endDdm
endDss
createDssRequest
startDdm ACCSEC
writeScalar2Bytes SECMEC 3 //  userid password
writeScalarPaddedBytes RDBNAM "thisNeedsToBeNoMoreThan255CharactersLong" 256
writeScalarString USRID test
writeScalarString PASSWORD test
endDdm
endDss
flush
skipDss		// don't care about the EXCSATRM so just skip
checkError SYNTAXRM 8 11 RDBNAM
endTest
//
DISPLAY "Test different RDBNAM on SECCHK than on ACCSEC"
include "excsat_accsecrd2.inc"
createDssRequest
startDdm  SECCHK
writeScalar2Bytes SECMEC 3 // userid password
writeScalarPaddedBytes RDBNAM notthesame 18
endDdm
endDss
flush
checkerror PRCCNVRM 8 18
endTest
//
DISPLAY "Test security token on SECCHK when not required"
include "excsat_accsecrd2.inc"
createDssRequest
startDdm  SECCHK
writeScalar2Bytes SECMEC 3 // userid password
writeScalarPaddedBytes RDBNAM test 18
startDdm SECTKN
writeBytes "0x010101"
endDdm
endDdm
endDss
flush
readReplyDss
readLengthAndCodePoint SECCHKRM
readScalar2Bytes SVRCOD 8
readScalar1Byte SECCHKCD 14
endTest
//
DISPLAY "Test missing USERID on SECCHK"
include "excsat_accsecrd2.inc"
createDssRequest
startDdm  SECCHK
writeScalar2Bytes SECMEC 3 // userid password
writeScalarPaddedBytes RDBNAM test 18
endDdm
endDss
flush
readReplyDss
readLengthAndCodePoint SECCHKRM
readScalar2Bytes SVRCOD 8
readScalar1Byte SECCHKCD 18
endTest
//
DISPLAY "Test missing PASSWORD on SECCHK"
include "excsat_accsecrd2.inc"
createDssRequest
startDdm  SECCHK
writeScalar2Bytes SECMEC 3 // userid password
writeScalarPaddedBytes RDBNAM test 18
writeScalarString USRID test
endDdm
endDss
flush
readReplyDss
readLengthAndCodePoint SECCHKRM
readScalar2Bytes SVRCOD 8
readScalar1Byte SECCHKCD 16
endTest
//
DISPLAY "Test ACCRDB not following SECCHK"
include "excsat_secchk.inc"
createDssRequest
startDdm MGRLVLLS
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 MGRLVLLS
endTest
//
DISPLAY "Test missing RDBACCCL from ACCRDB"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 RDBACCCL
endTest
//
DISPLAY "Test missing CRRTKN"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 CRRTKN
endTest
//
DISPLAY "Test too small value for RDBACCCL"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar1Byte RDBACCCL 1
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 11 RDBACCCL
endTest
//
DISPLAY "Test too large value for RDBACCCL"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
startDdm RDBACCCL
writeInt 1
writeInt 2
endDdm
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 9 RDBACCCL
endTest
//
DISPLAY "Test invalid value for RDBACCCL"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SECMEC
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 20 RDBACCCL
endTest
//
DISPLAY "Test missing PRDID"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
writeScalarBytes CRRTKN "0xd5c6f0f0f0f0f0f14bc7c3c2f600ec774aa60e"
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 PRDID
endTest
//
DISPLAY "Test missing TYPDEFNAM"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
writeScalarBytes CRRTKN "0xd5c6f0f0f0f0f0f14bc7c3c2f600ec774aa60e"
writeScalarString PRDID "TST01000"
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 TYPDEFNAM
endTest
//
DISPLAY "Test missing TYPDEFOVR"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
writeScalarBytes CRRTKN "0xd5c6f0f0f0f0f0f14bc7c3c2f600ec774aa60e"
writeScalarString PRDID "TST01000"
writeScalarString TYPDEFNAM  QTDSQLASC
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 14 TYPDEFOVR
endTest
//
DISPLAY "Test bad  TYPDEFNAM" 
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
writeScalarBytes CRRTKN "0xd5c6f0f0f0f0f0f14bc7c3c2f600ec774aa60e"
writeScalarString PRDID "TST01000"
writeScalarString TYPDEFNAM UNKNOWN
startDdm TYPDEFOVR
endDdm
endDdm
endDss
flush
skipDdm // don't care about SECCHKRM so just skip
checkError SYNTAXRM 8 20 TYPDEFNAM
endTest
//
DISPLAY "Test codepoint not allowed in TYPDEFOVR"
include "excsat_secchk.inc"
createDssRequest
startDdm ACCRDB
writeScalar2Bytes RDBACCCL SQLAM
writeScalarBytes CRRTKN "0xd5c6f0f0f0f0f0f14bc7c3c2f600ec774aa60e"
writeScalarString PRDID "TST01000"
writeScalarString TYPDEFNAM QTDSQLASC
startDdm TYPDEFOVR
writeScalar2Bytes MGRLVLLS 2