Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 35001 invoked from network); 18 May 2005 02:04:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 May 2005 02:04:23 -0000 Received: (qmail 48798 invoked by uid 500); 17 May 2005 20:21:16 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 48411 invoked by uid 500); 17 May 2005 20:21:12 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 47883 invoked by uid 500); 17 May 2005 20:20:59 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 47814 invoked by uid 99); 17 May 2005 20:20:58 -0000 X-ASF-Spam-Status: No, hits=-9.8 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Tue, 17 May 2005 13:20:54 -0700 Received: (qmail 10554 invoked by uid 65534); 17 May 2005 20:20:46 -0000 Message-ID: <20050517202046.10553.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: svn commit: r170651 - in /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNet/testSecMec.out master/DerbyNetClient/testSecMec.out tests/derbynet/testSecMec.java Date: Tue, 17 May 2005 20:20:45 -0000 To: derby-cvs@incubator.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.0.0-dev X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: kmarsden Date: Tue May 17 13:20:44 2005 New Revision: 170651 URL: http://svn.apache.org/viewcvs?rev=3D170651&view=3Drev Log: This patch fixes derbynet/testSecMec.java test failure on 131 vms. Problem - with 131 vms, if server and client are in the same jvm, on a seco= nd get connection with create=3Dtrue attribute in the url, there is a hang. Basically, -- the first getConnection works ok -- but on the second getConnection, a SQLWarning needs to be generated to = say that the database already exists and in this scenario, it seems like at= the point where it is creating a SQLWarning , there is a deadlock. The cal= l to SQLWarning constructor does not return. On doing a java core dump , th= e thread in question seems to be in a wait state (conditional wait). Guess= is it has to do with the driver manager lock I will file a jira entry to track this issue but for the test in question, = changes were made to not use create=3Dtrue except for the first connection. -- ran this test for both DerbyClient and JCC driver on both corresponding = versions 131,141 ,142 on both IBM and Sun jdks. Also tested it on sun jdk 1= .5.0. -- ran derbynetmats on jdk142 ok. -- ran derbynetclientmats on ibm131 ok.=20 contributed by Sunitha Kambhampati Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/testSecMec.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/testSecMec.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/derbynet/testSecMec.java Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNet/testSecMec.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out?rev=3D= 170651&r1=3D170650&r2=3D170651&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/testSecMec.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/testSecMec.out Tue May 17 13:20:44 2005 @@ -1,9 +1,9 @@ Checking security mechanism authentication with DriverManager -T1: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue - EXCEPTION null= userid not supported -T2: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue:user=3Dmax; - EX= CEPTION null password not supported -T3: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue:user=3Dneelima;p= assword=3Dlee; T4: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue:user=3Dneelima;p= assword=3Dlee;securityMechanism=3D3; -T6: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue:user=3Dneelima;s= ecurityMechanism=3D4; -T8: jdbc:derby:net://localhost:20000/wombat;create=3Dtrue:user=3Dneelima;p= assword=3Dlee;securityMechanism=3D4; +T1: jdbc:derby:net://localhost:20000/wombat - EXCEPTION null userid not su= pported +T2: jdbc:derby:net://localhost:20000/wombat:user=3Dmax; - EXCEPTION null p= assword not supported +T3: jdbc:derby:net://localhost:20000/wombat:user=3Dneelima;password=3Dlee; +T6: jdbc:derby:net://localhost:20000/wombat:user=3Dneelima;securityMechani= sm=3D4; +T8: jdbc:derby:net://localhost:20000/wombat:user=3Dneelima;password=3Dlee;= securityMechanism=3D4; SECMEC_USRIDPWD: OK Completed testSecMec Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNetClient/testSecMec.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out?= rev=3D170651&r1=3D170650&r2=3D170651&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/testSecMec.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/testSecMec.out Tue May 17 13:20:44 2005 @@ -1,9 +1,9 @@ Checking security mechanism authentication with DriverManager -T1: jdbc:derby://localhost:20000/wombat;create=3Dtrue -T2: jdbc:derby://localhost:20000/wombat;create=3Dtrue;user=3Dmax -T3: jdbc:derby://localhost:20000/wombat;create=3Dtrue;user=3Dneelima;passw= ord=3Dlee T4: jdbc:derby://localhost:20000/wombat;create=3Dtrue;user=3Dneelima;passw= ord=3Dlee;securityMechanism=3D3 -T6: jdbc:derby://localhost:20000/wombat;create=3Dtrue;user=3Dneelima;secur= ityMechanism=3D4 -T8: jdbc:derby://localhost:20000/wombat;create=3Dtrue;user=3Dneelima;passw= ord=3Dlee;securityMechanism=3D4 +T1: jdbc:derby://localhost:20000/wombat +T2: jdbc:derby://localhost:20000/wombat;user=3Dmax +T3: jdbc:derby://localhost:20000/wombat;user=3Dneelima;password=3Dlee +T6: jdbc:derby://localhost:20000/wombat;user=3Dneelima;securityMechanism= =3D4 +T8: jdbc:derby://localhost:20000/wombat;user=3Dneelima;password=3Dlee;secu= rityMechanism=3D4 SECMEC_USRIDPWD: OK Completed testSecMec Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/tests/derbynet/testSecMec.java URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java?rev=3D= 170651&r1=3D170650&r2=3D170651&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/derbynet/testSecMec.java (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/derbynet/testSecMec.java Tue May 17 13:20:44 2005 @@ -145,18 +145,18 @@ // different security mechanisms. // Network server supports SECMEC_USRIDPWD, SECMEC_USRIDONL,SECMEC_EUSRI= DPWD System.out.println("Checking security mechanism authentication with Driv= erManager"); - getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue",null),= "T1:"); - getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","user= =3Dmax"),"T2:"); - getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","user= =3Dneelima;password=3Dlee"),"T3:"); getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","user= =3Dneelima;password=3Dlee;securityMechanism=3D"+SECMEC_USRIDPWD),"T4:"); + getConnectionUsingDriverManager(getJDBCUrl("wombat",null),"T1:"); + getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dmax"),"T2:"); + getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dneelima;pass= word=3Dlee"),"T3:"); // Disable because ibm142 doesnt support DiffieHelman prim= e of 32 bytes // Also Sun JCE doesnt support it. - //getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","use= r=3Dneelima;password=3Dlee;securityMechanism=3D"+SECMEC_EUSRIDPWD),"T5:"); - getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","user= =3Dneelima;securityMechanism=3D"+SECMEC_USRIDONL),"T6:"); + //getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dneelima;pa= ssword=3Dlee;securityMechanism=3D"+SECMEC_EUSRIDPWD),"T5:"); + getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dneelima;secu= rityMechanism=3D"+SECMEC_USRIDONL),"T6:"); =20 // disable as ibm142 and sun jce doesnt support DH prime o= f 32 bytes - //getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","use= r=3Dneelima;password=3Dlee;securityMechanism=3D"+SECMEC_USRENCPWD),"T7:"); - getConnectionUsingDriverManager(getJDBCUrl("wombat;create=3Dtrue","user= =3Dneelima;password=3Dlee;securityMechanism=3D"+SECMEC_USRIDONL),"T8:"); + //getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dneelima;pa= ssword=3Dlee;securityMechanism=3D"+SECMEC_USRENCPWD),"T7:"); + getConnectionUsingDriverManager(getJDBCUrl("wombat","user=3Dneelima;pass= word=3Dlee;securityMechanism=3D"+SECMEC_USRIDONL),"T8:"); =20 getConnectionUsingDataSource(); =20