-----
Testing with derby.drda.securityMechanism=null
Checking security mechanism authentication with DriverManager
T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;create=true:user=neelima;password=lee;securityMechanism=3;
T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
DERBY-1080  EXCEPTION ()  java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
******testAllCombinationsOfUserPasswordsSecMecInput***
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;
TEST_DS(user=calvin;password=hobbes) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4;
TEST_DS (user=calvin;password=hobbes,securityMechanism=4) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3;
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism()  null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=null
Turning ON Derby BUILTIN authentication
USRSSBPWD (T0): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
USRSSBPWD + BUILTIN (T1): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS - USRSSBPWD + BUILTIN (T2): OK
USRSSBPWD + BUILTIN (T3): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=invalid;password=user;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS - USRSSBPWD + BUILTIN (T4): OK
Turning OFF Derby BUILTIN authentication
USRSSBPWD + BUILTIN (T5): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=USER_ONLY_SECURITY
Checking security mechanism authentication with DriverManager
T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=3; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
DERBY-1080  EXCEPTION ()  java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
******testAllCombinationsOfUserPasswordsSecMecInput***
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4;
TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism()  null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
-----
Testing with derby.drda.securityMechanism=CLEAR_TEXT_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=3;
T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
DERBY-1080  EXCEPTION ()  java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
******testAllCombinationsOfUserPasswordsSecMecInput***
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;
TEST_DS(user=calvin;password=hobbes) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=4) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3;
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism()  null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=3; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
DERBY-1080  EXCEPTION ()  java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
******testAllCombinationsOfUserPasswordsSecMecInput***
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  Connection authorization failure occurred.  Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred.  Reason: security mechanism not supported
TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism()  null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism()  null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism()  null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism()  null userid not supported
Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Turning ON Derby BUILTIN authentication
EXCEPTION getConnectionWithSecMec()  Connection authorization failure occurred.  Reason: security mechanism not supported
-----
Testing with derby.drda.securityMechanism=INVALID_VALUE
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, INVALID_VALUE, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, , for derby.drda.securityMechanism.
Completed testSecMec