Return-Path: Delivered-To: apmail-openjpa-commits-archive@www.apache.org Received: (qmail 27279 invoked from network); 6 Sep 2009 06:06:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Sep 2009 06:06:04 -0000 Received: (qmail 80210 invoked by uid 500); 6 Sep 2009 06:06:04 -0000 Delivered-To: apmail-openjpa-commits-archive@openjpa.apache.org Received: (qmail 80145 invoked by uid 500); 6 Sep 2009 06:06:04 -0000 Mailing-List: contact commits-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list commits@openjpa.apache.org Received: (qmail 80136 invoked by uid 99); 6 Sep 2009 06:06:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Sep 2009 06:06:04 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Sep 2009 06:06:00 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id B009F23888A4; Sun, 6 Sep 2009 06:05:39 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r811767 - in /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache: TestQueryTimestampEviction.java Usage.java Date: Sun, 06 Sep 2009 06:05:39 -0000 To: commits@openjpa.apache.org From: faywang@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090906060539.B009F23888A4@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: faywang Date: Sun Sep 6 06:05:39 2009 New Revision: 811767 URL: http://svn.apache.org/viewvc?rev=811767&view=rev Log: fix test case problem for MySQL Modified: openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/TestQueryTimestampEviction.java openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/Usage.java Modified: openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/TestQueryTimestampEviction.java URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/TestQueryTimestampEviction.java?rev=811767&r1=811766&r2=811767&view=diff ============================================================================== --- openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/TestQueryTimestampEviction.java (original) +++ openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/TestQueryTimestampEviction.java Sun Sep 6 06:05:39 2009 @@ -87,10 +87,10 @@ EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); - String insert1 = "insert into part(partno,parttype,name,cost,mass)" + + String insert1 = "insert into Part(partno,parttype,name,cost,mass)" + " values(13,'PartBase','breakes',1000.0,100.0)"; em.createNativeQuery(insert1).executeUpdate(); - String insert2 = "insert into supplier_part(suppliers_sid," + + String insert2 = "insert into Supplier_Part(suppliers_sid," + "supplies_partno) values(1,13)"; em.createNativeQuery(insert2).executeUpdate(); @@ -100,7 +100,7 @@ em = emf.createEntityManager(); em.getTransaction().begin(); - String sql = "select partno from part where cost > 120 "; + String sql = "select partno from Part where cost > 120 "; Query nativeq = em.createNativeQuery(sql); int nativelistSize = nativeq.getResultList().size(); @@ -203,7 +203,7 @@ EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); - em.createNativeQuery("delete from supplier_part").executeUpdate(); + em.createNativeQuery("delete from Supplier_Part").executeUpdate(); em.createQuery("delete from PartBase s").executeUpdate(); em.createQuery("delete from Supplier s").executeUpdate(); em.createQuery("delete from Usage u").executeUpdate(); Modified: openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/Usage.java URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/Usage.java?rev=811767&r1=811766&r2=811767&view=diff ============================================================================== --- openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/Usage.java (original) +++ openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/cache/Usage.java Sun Sep 6 06:05:39 2009 @@ -24,7 +24,7 @@ @Entity @DataCache(timeout=100000) - +@Table(name="Usage1") public class Usage { @Id @GeneratedValue(strategy=GenerationType.IDENTITY)