You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2006/08/09 15:51:33 UTC
svn commit: r430056 [3/4] - in /db/derby/code/trunk/java:
client/org/apache/derby/client/am/ client/org/apache/derby/client/net/
client/org/apache/derby/jdbc/ drda/org/apache/derby/impl/drda/
engine/org/apache/derby/iapi/reference/ engine/org/apache/de...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm14/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm14/testSecMec.out?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm14/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ibm14/testSecMec.out Wed Aug 9 06:51:30 2006
@@ -8,8 +8,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
SECMEC_USRIDPWD: OK
SECMEC_EUSRIDPWD: OK
+SECMEC_USRSSBPWD: OK
Test DERBY-1080
withConnectionPooling
query ok
@@ -23,6 +25,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin
TEST_DS(user=calvin) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4
@@ -31,6 +35,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes
TEST_DS(password=hobbes) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4
@@ -39,6 +45,8 @@
TEST_DS (password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9
TEST_DS (password=hobbes,securityMechanism=9) OK
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8
+TEST_DS (password=hobbes,securityMechanism=8) OK
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;
TEST_DS() OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4
@@ -47,6 +55,17 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=null
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+USRSSBPWD + BUILTIN (T1): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=invalid;password=user;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: userid or password invalid.
+TEST_DS - USRSSBPWD + BUILTIN (T4):EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: userid or password invalid.
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
-----
Testing with derby.drda.securityMechanism=USER_ONLY_SECURITY
Checking security mechanism authentication with DriverManager
@@ -57,8 +76,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -71,6 +92,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin
TEST_DS(user=calvin) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4
@@ -79,6 +102,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4
@@ -87,6 +112,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;
TEST_DS() OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4
@@ -95,6 +122,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=CLEAR_TEXT_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -105,8 +134,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD: OK
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -119,6 +150,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -127,6 +160,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -135,6 +170,8 @@
TEST_DS (password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -143,6 +180,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -153,8 +192,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_EUSRIDPWD: OK
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
query ok
@@ -168,6 +209,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -176,6 +219,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes
TEST_DS(password=hobbes) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -184,6 +229,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9
TEST_DS (password=hobbes,securityMechanism=9) OK
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -192,6 +239,75 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+-----
+Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Checking security mechanism authentication with DriverManager
+T4: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T1: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T2: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=max - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T3: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+SECMEC_USRSSBPWD: OK
+Test DERBY-1080
+withConnectionPooling
+DERBY-1080 EXCEPTION () Connection authentication failure occurred. Reason: security mechanism not supported.
+******testAllCombinationsOfUserPasswordsSecMecInput***
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=3 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8
+TEST_DS (password=hobbes,securityMechanism=8) OK
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=3 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+USRSSBPWD + BUILTIN (T1): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=invalid;password=user;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: userid or password invalid.
+TEST_DS - USRSSBPWD + BUILTIN (T4):EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: userid or password invalid.
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
-----
Testing with derby.drda.securityMechanism=INVALID_VALUE
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, INVALID_VALUE, for derby.drda.securityMechanism.
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out Wed Aug 9 06:51:30 2006
@@ -8,8 +8,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
SECMEC_USRIDPWD: OK
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+SECMEC_USRSSBPWD: OK
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
@@ -22,6 +24,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin
TEST_DS(user=calvin) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4
@@ -30,6 +34,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes
TEST_DS(password=hobbes) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4
@@ -38,6 +44,8 @@
TEST_DS (password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8
+TEST_DS (password=hobbes,securityMechanism=8) OK
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;
TEST_DS() OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4
@@ -46,6 +54,17 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=null
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+USRSSBPWD + BUILTIN (T1): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=invalid;password=user;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: userid or password invalid.
+TEST_DS - USRSSBPWD + BUILTIN (T4):EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: userid or password invalid.
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
-----
Testing with derby.drda.securityMechanism=USER_ONLY_SECURITY
Checking security mechanism authentication with DriverManager
@@ -56,8 +75,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
@@ -70,6 +91,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin
TEST_DS(user=calvin) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4
@@ -78,6 +101,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4
@@ -86,6 +111,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;
TEST_DS() OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4
@@ -94,6 +121,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=CLEAR_TEXT_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -104,8 +133,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD: OK
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
@@ -118,6 +149,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -126,6 +159,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes
TEST_DS(password=hobbes) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -134,6 +169,8 @@
TEST_DS (password=hobbes,securityMechanism=3) OK
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -142,6 +179,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -152,8 +191,10 @@
T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test DERBY-1080
withConnectionPooling
DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
@@ -166,6 +207,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -174,6 +217,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -182,6 +227,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
@@ -190,6 +237,75 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+-----
+Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Checking security mechanism authentication with DriverManager
+T4: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T1: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T2: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=max - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T3: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
+T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+SECMEC_USRSSBPWD: OK
+Test DERBY-1080
+withConnectionPooling
+DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
+******testAllCombinationsOfUserPasswordsSecMecInput***
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
+TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=3 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
+TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8
+TEST_DS (password=hobbes,securityMechanism=8) OK
+Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
+TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=3 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
+# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
+USRSSBPWD + BUILTIN (T1): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=invalid;password=user;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: userid or password invalid.
+TEST_DS - USRSSBPWD + BUILTIN (T4):EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: userid or password invalid.
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;shutdown=true;securityMechanism=8 - EXCEPTION DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'wombat' shutdown.
-----
Testing with derby.drda.securityMechanism=INVALID_VALUE
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, INVALID_VALUE, for derby.drda.securityMechanism.