From users-return-10491-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Sun Dec 2 01:52:36 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7741DD284 for ; Sun, 2 Dec 2012 01:52:36 +0000 (UTC) Received: (qmail 94946 invoked by uid 500); 2 Dec 2012 01:52:35 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 94829 invoked by uid 500); 2 Dec 2012 01:52:35 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Delivered-To: moderator for users@openjpa.apache.org Received: (qmail 21898 invoked by uid 99); 2 Dec 2012 01:05:15 -0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_FONT_LOW_CONTRAST,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of regularjack@gmail.com designates 209.85.223.174 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=G92fmiqwyk+8sZqxQsZ9mbu4QO8DU7027pTgzCFdFfQ=; b=x/I+yuwdMOOGb8hbSV14dTBBGa+eUz3Z0RLEpO/HafbTUJ2oVUPPPYynxuKPbhpIAT aidr1PKsMLHEo9rU53WLB8dxF8/qEm3RXUTPEFXaAzaTUnduVwyUNB+YPaue1ZctACXW +YyaNPOBqN0XlvWqFYuTp0ohuwP0uo7tq9tVFFrRQV/M6bg1vOBXXEizAeSlMf4+2wmZ LG33n4jLHVl0cV20s30C+56p4iw+p23mc6vIPC+hZBo6VQaF1IdQZlSDoD01ao82kQvK SODLWAuolRnD2IRgnEWafcpHHXAE/+wn2n3BieviRmLHly1qYeao5jxVEM/m/vP+fWFp rnkA== MIME-Version: 1.0 From: Paulo Rodrigues Pinto Date: Sat, 1 Dec 2012 22:04:06 -0300 Message-ID: Subject: How to eagerly fetch two-level nested associations? To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=14dae93409a907c95104cfd4380e X-Virus-Checked: Checked by ClamAV on apache.org --14dae93409a907c95104cfd4380e Content-Type: text/plain; charset=UTF-8 I'm trying to efficiently fetch a two-level nested association using OpenJPA 2.2.0. Basically, I have one Athat has one B that has many C: @Entitypublic class A { ... @ManyToOne(fetch=FetchType.EAGER) private B b;} @Entitypublic class B { ... @OneToMany(mappedBy="b", fetch=FetchType.EAGER) private List cs;} @Entitypublic class C { ...} My JPQL query is as follows: SELECT a FROM A a WHERE a.id = some condition I set the EagerFetchMode to "PARALLEL" in order to have a second query that retrieves the Cs of all the Bs: The problem is that openjpa is generating n+1 queries instead of 2: one for the As and Bs and one for each C: SELECT *FROM aLEFT OUTER JOIN b ON a.b_id = b.id WHERE some condition and n times SELECT *FROM c WHERE c.b_id = x *How can I make openjpa issue two queries instead of n+1?* --14dae93409a907c95104cfd4380e-- From users-return-10492-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Mon Dec 3 20:53:58 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3A1E5D171 for ; Mon, 3 Dec 2012 20:53:58 +0000 (UTC) Received: (qmail 81468 invoked by uid 500); 3 Dec 2012 20:53:57 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 81390 invoked by uid 500); 3 Dec 2012 20:53:57 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 81377 invoked by uid 99); 3 Dec 2012 20:53:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Dec 2012 20:53:57 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Dec 2012 20:53:50 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so3013153lbb.33 for ; Mon, 03 Dec 2012 12:53:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=j42l70uAQAeZQYz3xL+lm5hTmOD/1FNQjP98FGBtbcA=; b=LXIus7qvKOjshiu44TdKR0ZdGHjkQ+LvOOLiSpsGQT8WI4zqDZSb7iBthAS1Dy0UJi 42XgXbdkaxR5doepJmUYxe0urwLVNm/vNw8R1UxA/tnTOKfZCfZdLBzS3gaiNG2lyDPm XAsvLbEDZ5+8fgrMdaBzG7QDgKwlwU1QBuz5sAlCPAhI0VetjTvchX19Yhe56mDtYHXs AGYEyCBvs0FKKtYBpVDs4IaIBULnhXfF3wq4+O3enIKbEQYfAQrgbzPikI8AayYHRoAw oUda4V7I6hapt6OdJ62Ix+jmFyC5IEpNgyMbSPNWgU65rVeeOSxyP415wU2fOF91xaTC 2sDA== Received: by 10.152.108.37 with SMTP id hh5mr10792147lab.52.1354568010298; Mon, 03 Dec 2012 12:53:30 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Mon, 3 Dec 2012 12:53:10 -0800 (PST) In-Reply-To: <1354309217756-7582024.post@n2.nabble.com> References: <1354309217756-7582024.post@n2.nabble.com> From: Kevin Sutter Date: Mon, 3 Dec 2012 14:53:10 -0600 Message-ID: Subject: Re: Data cache resource usage To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=bcaec54ee10a13f53d04cff8f1d1 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec54ee10a13f53d04cff8f1d1 Content-Type: text/plain; charset=ISO-8859-1 Hi Don, Yes, OpenJPA spins off a daemon thread that sleeps and wakes up based on your configuration. If you are interested in more detail on how this works, I'd suggest looking at the following code part: org.apache.openjpa.datacache.ClearableScheduler Thanks, Kevin On Fri, Nov 30, 2012 at 3:00 PM, kostellodon wrote: > I am using OpenJPA 1.2.3 and am enabling the data cache. I'm setting up > the > refresh so that it will clear the cache once per day using the cron-like > setting. How is OpenJPA going to do this? Is it going to create a > separate > thread that will sleep and wake up, is there some code running checking the > clock, or ??? > > Thanks for any help. > > Don > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Data-cache-resource-usage-tp7582024.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > --bcaec54ee10a13f53d04cff8f1d1-- From users-return-10493-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Tue Dec 4 12:43:38 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EFF6FE624 for ; Tue, 4 Dec 2012 12:43:37 +0000 (UTC) Received: (qmail 71032 invoked by uid 500); 4 Dec 2012 12:43:37 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 70738 invoked by uid 500); 4 Dec 2012 12:43:31 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 70701 invoked by uid 99); 4 Dec 2012 12:43:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Dec 2012 12:43:30 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [141.113.102.116] (HELO mail-out.emea.daimler.com) (141.113.102.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Dec 2012 12:43:24 +0000 X-AuditID: 351f1472-b7fe76d000000d7e-9e-50bdefd50aa5 To: users@openjpa.apache.org Subject: EntityNotFoundException on getResultList() call after externally row removal Message-id: From: it-media.kopp@daimler.com Date: Tue, 04 Dec 2012 13:42:58 +0100 Content-type: multipart/alternative; boundary="=_alternative 0045DAAEC1257ACA_=" MIME-version: 1.0 X-KeepSent: EB0DB384:045C8C7E-C1257ACA:00453B89; name=$KeepSent; type=4 X-Disclaimed: 62491 X-SenderTag: 3 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFjrJLMWRmVeSWpSXmKPExsViKq+iq3v1/d4Ag4ttqhbX1xxgdGD0mPDw NXsAYxSXTUpqTmZZapG+XQJXRtO/yoJnChUrj55gaWBcKt3FyMkhIWAi0XRkFwuELSZx4d56 ti5GLg4hgaOMEut+noRybjBKrJp4H8r5zyjR13QYrEVEQEbiwbX/jF2MHBzCAuESZ3dagIR5 BUIlVv+bxAwSZhOQl5jWqwkSZhFQldg37SkLSJhZIEDi31cjiGpBiR+T70Hd4C5x6cMGZghb WGL6pUWsEDafxNylmxgnMPLPQuiehaQbxGYW0JE4seoYM4StLbFs4Ws4e9GVn+zI4gsY2VYx yicW6xYn6hoYmeil5qYm6iWl6yXnFxUAg7coUS8vtWQTIziARYp2MB6YKnuIUYCDUYmHd+aV vQFCrIllxZW5hxglOJiVRHhD3wCFeFMSK6tSi/Lji0pzUosPMUpzsCiJ8xYe/+YvJJCeWJKa nZpakFoEk2Xi4JRqYORNb3/l7Xt7Ytm8Q/y+Vf6/J757XsLG57PY7+ZD97rTvtldfiH/l2eY 5W7Liu0NlFB+MMvdat6cValneHYZ/vTxMRHo9t7Ra7qdeV/Ek53m00okd14K47+VHWx/663o oyuyP5d7Gak+V+2duMFoR8xVs7BtJ5WC30rOk+Bubvh0y3dRoq1TnBJLcUaioRZzUXEiAOmE rBtcAgAA X-Virus-Checked: Checked by ClamAV on apache.org --=_alternative 0045DAAEC1257ACA_= Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hello, I'm facing an issue with OpenJPA 2.1 as shipped with IBM WebSphere 8. Our=20 system uses JPA solely for reading the data. Updating and Deleting of data = is done by a backend system. My problem is, that after a removal of a row=20 initiated by the backend system, a subsequent call to a typed query will=20 throw a EntityNotFoundException on a tuple query when calling=20 getResultList(). This is weird, as the method getResultList() does NOT=20 include this exception in the list of exceptions it may throw. The exception reads:=20 =20 org.apache.openjpa.persistence.EntityNotFoundException: Die Instanz=20 "2256570 [org.apache.openjpa.util.LongId]" ist nicht im Datenspeicher=20 vorhanden. FailedObject: 2256570 [java.lang.Long] What am I supposed to do here? A subsequent call to getResultList()=20 results in the same error. The entity manager is EJB based in Extended=20 Mode. I do not want to close it as I might loose the lazy binding=20 functionality used within the application. Is there a way to simply=20 retrieve the current database state and forget about all externally=20 modified entities? I'm not aware that this ever happend directly at=20 'getResultList()'. I'm normally refreshing all objects after retrieval and = I'm aware that refresh() may throw EntityNotFoundException. In that case I = simply remove the entity from the list. Thank you for your help, Heiko If you are not the intended addressee, please inform us immediately that yo= u have received this e-mail in error, and delete it. We thank you for your = cooperation. = = --=_alternative 0045DAAEC1257ACA_=-- From users-return-10494-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Thu Dec 6 15:37:48 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D3725DFF0 for ; Thu, 6 Dec 2012 15:37:48 +0000 (UTC) Received: (qmail 85946 invoked by uid 500); 6 Dec 2012 15:37:48 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 85594 invoked by uid 500); 6 Dec 2012 15:37:43 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 85548 invoked by uid 99); 6 Dec 2012 15:37:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Dec 2012 15:37:41 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of akumar202@bankofamerica.com does not designate 216.139.250.139 as permitted sender) Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Dec 2012 15:37:35 +0000 Received: from jim.nabble.com ([192.168.236.80]) by joe.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Tgcw5-000145-C5 for users@openjpa.apache.org; Thu, 06 Dec 2012 07:00:25 -0800 Date: Thu, 6 Dec 2012 07:00:25 -0800 (PST) From: anand213 To: users@openjpa.apache.org Message-ID: <1354806025357-7582055.post@n2.nabble.com> Subject: Unique constraint annotations not generated by Reverse Mapping tool MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi, I am trying to reverse map beans by directly connecting to H2 DB. Below is the DB schema to reverse. It has couple of unique keys and a non-unique key. These are read by the tool but no annotations generated for the same: CREATE SCHEMA TEST; CREATE TABLE TEST.EMPLOYEE_FOR_CACHE ( ID INT PRIMARY KEY, FNAME VARCHAR2(50), LNAME VARCHAR2(50), PROJECT VARCHAR2(10), DEPT VARCHAR2(50), LOCATION VARCHAR2(50) ); -- Indexes: CREATE INDEX ON TEST.EMPLOYEE_FOR_CACHE(LNAME); CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(FNAME, LNAME, LOCATION); CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(DEPT, PROJECT); Below is the generated bean: @Entity @Table( name="EMPLOYEE_FOR_CACHE") public class EmployeeForCache { @Basic @Column(length=50) private String dept; @Basic @Column(length=50) private String fname; @Id private int id; @Basic @Column(length=50) private String lname; @Basic @Column(length=50) private String location; @Basic @Column(length=10) private String project; public EmployeeForCache() { } public EmployeeForCache(int id) { this.id = id; } public String getDept() { return dept; } public void setDept(String dept) { this.dept = dept; } public String getFname() { return fname; } public void setFname(String fname) { this.fname = fname; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getLname() { return lname; } public void setLname(String lname) { this.lname = lname; } public String getLocation() { return location; } public void setLocation(String location) { this.location = location; } public String getProject() { return project; } public void setProject(String project) { this.project = project; } } Below are the logs: 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (FNAME)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LOCATION)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (DEPT)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (PROJECT)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "PRIMARY_KEY_1" on table "TEST.EMPLOYEE_FOR_CACHE (ID)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found existing index "INDEX_1" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Reading foreign keys for schema name "TEST", table name "TEST.EMPLOYEE_FOR_CACHE". 109 cut-jpa-bean-generator INFO [main] openjpa.Tool - ReverseMappingTool : generating classes. 107259 cut-jpa-bean-generator INFO [main] openjpa.Tool - Generating annotations. 110368 cut-jpa-bean-generator INFO [main] openjpa.Tool - Writing generated class source code. I am using below reverse properties: -pkg, com.bofa.cut.jpa.entity.bean, -directory, ./scr/test/java, -log, 'DefaultLevel=WARN, Tool=INFO, SQL=TRACE,Schema=TRACE', -metadata, none, -useGenericCollections, true, -annotations, true, -connectionURL, ..... OPen JPA version: 2.2.0 Thanks and Regards, AKumar -- View this message in context: http://openjpa.208410.n2.nabble.com/Unique-constraint-annotations-not-generated-by-Reverse-Mapping-tool-tp7582055.html Sent from the OpenJPA Users mailing list archive at Nabble.com. From users-return-10495-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 12:10:57 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 19F06E02E for ; Fri, 7 Dec 2012 12:10:57 +0000 (UTC) Received: (qmail 52598 invoked by uid 500); 7 Dec 2012 12:10:56 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 52415 invoked by uid 500); 7 Dec 2012 12:10:55 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 52387 invoked by uid 99); 7 Dec 2012 12:10:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 12:10:55 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of paulo.leal@gmail.com designates 209.85.219.46 as permitted sender) Received: from [209.85.219.46] (HELO mail-oa0-f46.google.com) (209.85.219.46) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 12:10:31 +0000 Received: by mail-oa0-f46.google.com with SMTP id h16so361916oag.33 for ; Fri, 07 Dec 2012 04:10:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=s6m3rPcLLxp/u0+mHgIVDsLP6SuFkNVbQnedOMNxxeQ=; b=KMQi31we2aV52xuLb3GBIrGrtrS7fs/pMjWuV+kbYih5vxANMnwg0/NdzLiVtrLaVs zr7v/gGsTrYpYUkdH+ZwZujmENqp5q6A6SeJ/U157RLMuXY9DoghiXoj2XruB0eBWrt1 4wOI34Ec/ZvMN075eW3CSD+M3lgjQ7ORDRKO01Lp1GUuH9Z9U1U7r002YY46/4y/7axv HE+LbHolvX0CyGngwAKMdORHJiUuB0e6zl2ihZ9O/fqY1Z1WpoT8hInXDDS97CVA3wma Tfk67p7jqCKDVVD3yrN36RGw/knRP+d+RJTc6IcPoXveEZf6lR8t6gKMJyrVml/9YV6Y SIHA== MIME-Version: 1.0 Received: by 10.60.21.233 with SMTP id y9mr3192538oee.78.1354882210437; Fri, 07 Dec 2012 04:10:10 -0800 (PST) Received: by 10.76.110.70 with HTTP; Fri, 7 Dec 2012 04:10:10 -0800 (PST) Date: Fri, 7 Dec 2012 10:10:10 -0200 Message-ID: Subject: ArrayIndexOutOfBoundsException on query From: Paulo Leal To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=e89a8fb1eef6dd99a704d04218fc X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb1eef6dd99a704d04218fc Content-Type: text/plain; charset=ISO-8859-1 Running a query I get a message: *openjpa.Runtime: Warn: Supplied user parameters "[1, 2, 3, 4, 5]" do not match expected parameters "[1, 1, 2, 3, 4, 5]" for the prepared query * * * *the query is like* *SELECT * * test * *FROM * * com.phleal.persistence.model.Test test * *WHERE * * EXISTS (* *SELECT attr* *FROM com.phleal.persistence.model.TestAttribute attr* *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 ) ) * * )* * AND ?5 MEMBER OF reg.testTypes* * AND reg.testCompleted = false* After this Warning I get an ArrayIndexOutOfBoundsException: *Failed to execute query SELECT * * test * *FROM * * com.phleal.persistence.model.Test test * *WHERE * * EXISTS (* *SELECT attr* *FROM com.phleal.persistence.model.TestAttribute attr* *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 ) ) * * )* * AND ?5 MEMBER OF reg.testTypes* * AND reg.testCompleted = false". Check the query syntax for correctness. See nested exception for details..* * org.apache.openjpa.persistence.ArgumentException: Failed to execute query "SELECT * * test * *FROM * * com.phleal.persistence.model.Test test * *WHERE * * EXISTS (* *SELECT attr* *FROM com.phleal.persistence.model.TestAttribute attr* *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 ) ) * * )* * AND ?5 MEMBER OF reg.testTypes* * AND reg.testCompleted = false". Check the query syntax for correctness. See nested exception for details.* * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:872)* * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)* * at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)* * at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)* * at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)* * at com.phleal.persistence.TestManager.getRelatedTest(TestManager.java:1794)* *.* *.* *.* * * * at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)* * at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) * * at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)* * at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)* *Caused by: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 5* * at org.apache.openjpa.jdbc.kernel.PreparedSQLStoreQuery$PreparedSQLExecutor.toParameterArray(PreparedSQLStoreQuery.java:161) * * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:857)* * ... 89 more* I am sure I only pass 5 attributes to the query, I don't know what could generate the "[1, 1, 2, 3, 4, 5]" from the message. I am running this query on multiple threads, and it is quite intermittent. --e89a8fb1eef6dd99a704d04218fc-- From users-return-10496-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 17:12:19 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5E9F5ECC5 for ; Fri, 7 Dec 2012 17:12:19 +0000 (UTC) Received: (qmail 83318 invoked by uid 500); 7 Dec 2012 17:12:19 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 81830 invoked by uid 500); 7 Dec 2012 17:12:16 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 81813 invoked by uid 99); 7 Dec 2012 17:12:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 17:12:16 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 17:12:10 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so649864lbb.33 for ; Fri, 07 Dec 2012 09:11:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=ZtfhqW5mN/OiUN/mQjHaIPdqwiiSiXlUAgXoyEFRacA=; b=P2HxLRnd8rEyfWPOAFjnPwiv6CMxyovdUKzWsWQpctz3ls0n5y3wSBizkI79Gl/RFE wykD6FSLNNz41U+aJOjXAnAMoLnsdYrycvpeI7Fpm36B26JXovQaHrfDYs0CFpz27U0m b86UovLhlzoLK0CUIgUYbr2vqwPxz1znkFkIKDvRAbiDIjM4qba1ags+MmV8uNUzw6Tj M+VCpOBhL3fdp62pVvAWkGM7BaMEGFZQMMRCmhO7ksjIqxfrl72w014WDTX6pwNRdE7L Ac6rrY7zfpKbwkyxET4yx9crIT2SLeszOprnm7kW0VDiLWIW5IFDLkoxd90g1KuQwpy6 UGMg== Received: by 10.152.104.240 with SMTP id gh16mr6115075lab.56.1354900309054; Fri, 07 Dec 2012 09:11:49 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Fri, 7 Dec 2012 09:11:27 -0800 (PST) In-Reply-To: References: From: Kevin Sutter Date: Fri, 7 Dec 2012 11:11:27 -0600 Message-ID: Subject: Re: ArrayIndexOutOfBoundsException on query To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=f46d04088e11a0945604d0464fab X-Virus-Checked: Checked by ClamAV on apache.org --f46d04088e11a0945604d0464fab Content-Type: text/plain; charset=ISO-8859-1 Hi Paulo, This scenario sounds so familiar, but I can't seem to find a corresponding JIRA for the problem... If I remember right, issues like this are usually related to the prepared sql cache and how the parameters are processed. As a quick test/workaround, you could try turning off this cache to see if you make more progress: Good luck, Kevin On Fri, Dec 7, 2012 at 6:10 AM, Paulo Leal wrote: > Running a query I get a message: *openjpa.Runtime: Warn: Supplied user > parameters "[1, 2, 3, 4, 5]" do not match expected parameters "[1, 1, 2, 3, > 4, 5]" for the prepared query * > * > * > *the query is like* > *SELECT * > * test * > *FROM * > * com.phleal.persistence.model.Test test * > *WHERE * > * EXISTS (* > *SELECT attr* > *FROM com.phleal.persistence.model.TestAttribute attr* > *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND > attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 > ) ) > * > * )* > * AND ?5 MEMBER OF reg.testTypes* > * AND reg.testCompleted = false* > > > > After this Warning I get an ArrayIndexOutOfBoundsException: > > > > > *Failed to execute query SELECT * > * test * > *FROM * > * com.phleal.persistence.model.Test test * > *WHERE * > * EXISTS (* > *SELECT attr* > *FROM com.phleal.persistence.model.TestAttribute attr* > *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND > attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 > ) ) > * > * )* > * AND ?5 MEMBER OF reg.testTypes* > * AND reg.testCompleted = false". Check the query syntax for > correctness. See nested exception for details..* > * nonfatal user error> org.apache.openjpa.persistence.ArgumentException: > Failed to execute query "SELECT * > * test * > *FROM * > * com.phleal.persistence.model.Test test * > *WHERE * > * EXISTS (* > *SELECT attr* > *FROM com.phleal.persistence.model.TestAttribute attr* > *WHERE attr.test = test AND attr.namespace.namespaceURI = ?1 AND > attr.name= ?2 AND ( ( attr.valueTypeId = ?3 AND attr.stringValue = ?4 > ) ) > * > * )* > * AND ?5 MEMBER OF reg.testTypes* > * AND reg.testCompleted = false". Check the query syntax for > correctness. See nested exception for details.* > * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:872)* > * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)* > * at > > org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)* > * at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)* > * at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)* > * at > com.phleal.persistence.TestManager.getRelatedTest(TestManager.java:1794)* > *.* > *.* > *.* > * > * > * at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)* > * at > > com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) > * > * at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)* > * at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)* > *Caused by: java.lang.ArrayIndexOutOfBoundsException: Array index out of > range: 5* > * at > > org.apache.openjpa.jdbc.kernel.PreparedSQLStoreQuery$PreparedSQLExecutor.toParameterArray(PreparedSQLStoreQuery.java:161) > * > * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:857)* > * ... 89 more* > > > I am sure I only pass 5 attributes to the query, I don't know what could > generate the "[1, 1, 2, 3, 4, 5]" from the message. > I am running this query on multiple threads, and it is quite intermittent. > --f46d04088e11a0945604d0464fab-- From users-return-10497-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 18:15:03 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7D356DFE0 for ; Fri, 7 Dec 2012 18:15:03 +0000 (UTC) Received: (qmail 67434 invoked by uid 500); 7 Dec 2012 18:15:03 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 67394 invoked by uid 500); 7 Dec 2012 18:15:03 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 67384 invoked by uid 99); 7 Dec 2012 18:15:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 18:15:03 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 18:14:56 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so703898lbb.33 for ; Fri, 07 Dec 2012 10:14:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=zDzHqYyAODurwQBzcO0YNCIg6QDIwIjCJz8bLZuXrYM=; b=h9/mEoTJ+DpktJXO6NQ2AY/Mde0Hb94HA1aJGyttJ1Zha/v/TGTgh+xYk2mAQ1s4NL zPcU5aVWw8PbzLdRlDAkfXCSb/JV97E7/SyoOp0NRhyrOMvxAgDFfmGvbkJyTSDAB/N0 w5LInzv0OnFQUgJxe+jU67HXF9mGdrbqaCzCQRzvhfow9QzcI4VaumGKHX6LGjLzk1MD nxPDl50ecoFnODYBkX1puEQFfAI5hwr5QIRrUhfJa58Z+yBG3IovbS+L/EkpecV9PcRo 02Qx4oYrwtcBWPeKJ6jS8W9WOjzA65oGNsvXJD337LyEsqMMX0q2axpaCYK/irk6/IHn l2fg== Received: by 10.112.27.97 with SMTP id s1mr2842055lbg.97.1354904076045; Fri, 07 Dec 2012 10:14:36 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Fri, 7 Dec 2012 10:14:15 -0800 (PST) In-Reply-To: <1354806025357-7582055.post@n2.nabble.com> References: <1354806025357-7582055.post@n2.nabble.com> From: Kevin Sutter Date: Fri, 7 Dec 2012 12:14:15 -0600 Message-ID: Subject: Re: Unique constraint annotations not generated by Reverse Mapping tool To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=bcaec554d948284fc204d0473059 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec554d948284fc204d0473059 Content-Type: text/plain; charset=ISO-8859-1 Hi akumar, What exactly were you expecting from the reverse mapping tool? Were you expecting that the @org.apache.openjpa.persistence.jdbc.Index annotations to be inserted into the generated java files? Or, were you expecting something else? You mentioned unique and non-unique keys... But, the primary key is detected correctly with the @Id annotation generation. I'm guessing you meant unique and non-unique indexes... If you were expecting the @Index annotation, per the documentation, this annotation was really meant for the other direction. That is, it's used as a hint for OpenJPA when generating the database schema [1]: "..OpenJPA uses index information during schema generation to index the proper columns." And, even the Reverse Mapping tool is not meant to be the end-all game [2]: "..Examine the generated class, metadata, and mapping information, and modify it as necessary. Remember that the reverse mapping tool only provides a starting point, and you are free to make whatever modifications you like to the code it generates." Not saying that this process couldn't be enhanced as a feature request, but I don't think there's a bug in the processing. Good luck, Kevin [1] http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_mapping_jpa_constraints [2] http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_pc_reverse On Thu, Dec 6, 2012 at 9:00 AM, anand213 wrote: > Hi, > I am trying to reverse map beans by directly connecting to H2 DB. Below is > the DB schema to reverse. It has couple of unique keys and a non-unique > key. > These are read by the tool but no annotations generated for the same: > > CREATE SCHEMA TEST; > > CREATE TABLE TEST.EMPLOYEE_FOR_CACHE ( > ID INT PRIMARY KEY, > FNAME VARCHAR2(50), > LNAME VARCHAR2(50), > PROJECT VARCHAR2(10), > DEPT VARCHAR2(50), > LOCATION VARCHAR2(50) > ); > > -- Indexes: > CREATE INDEX ON TEST.EMPLOYEE_FOR_CACHE(LNAME); > CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(FNAME, LNAME, LOCATION); > CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(DEPT, PROJECT); > > > Below is the generated bean: > @Entity > @Table( name="EMPLOYEE_FOR_CACHE") > public class EmployeeForCache { > @Basic > @Column(length=50) > private String dept; > > @Basic > @Column(length=50) > private String fname; > > @Id > private int id; > > @Basic > @Column(length=50) > private String lname; > > @Basic > @Column(length=50) > private String location; > > @Basic > @Column(length=10) > private String project; > > > public EmployeeForCache() { > } > > public EmployeeForCache(int id) { > this.id = id; > } > > public String getDept() { > return dept; > } > > public void setDept(String dept) { > this.dept = dept; > } > > public String getFname() { > return fname; > } > > public void setFname(String fname) { > this.fname = fname; > } > > public int getId() { > return id; > } > > public void setId(int id) { > this.id = id; > } > > public String getLname() { > return lname; > } > > public void setLname(String lname) { > this.lname = lname; > } > > public String getLocation() { > return location; > } > > public void setLocation(String location) { > this.location = location; > } > > public String getProject() { > return project; > } > > public void setProject(String project) { > this.project = project; > } > } > > > > Below are the logs: > > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (FNAME)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LOCATION)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (DEPT)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (PROJECT)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "PRIMARY_KEY_1" on table "TEST.EMPLOYEE_FOR_CACHE (ID)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Found > existing index "INDEX_1" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". > 94 cut-jpa-bean-generator TRACE [main] openjpa.jdbc.Schema - Reading > foreign keys for schema name "TEST", table name "TEST.EMPLOYEE_FOR_CACHE". > 109 cut-jpa-bean-generator INFO [main] openjpa.Tool - > ReverseMappingTool > : generating classes. > 107259 cut-jpa-bean-generator INFO [main] openjpa.Tool - Generating > annotations. > 110368 cut-jpa-bean-generator INFO [main] openjpa.Tool - Writing > generated class source code. > > > > I am using below reverse properties: > -pkg, com.bofa.cut.jpa.entity.bean, -directory, ./scr/test/java, -log, > 'DefaultLevel=WARN, Tool=INFO, SQL=TRACE,Schema=TRACE', -metadata, none, > -useGenericCollections, true, -annotations, true, -connectionURL, ..... > > OPen JPA version: 2.2.0 > > Thanks and Regards, > AKumar > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Unique-constraint-annotations-not-generated-by-Reverse-Mapping-tool-tp7582055.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > --bcaec554d948284fc204d0473059-- From users-return-10498-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 18:30:08 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 80EB1EBA4 for ; Fri, 7 Dec 2012 18:30:08 +0000 (UTC) Received: (qmail 33072 invoked by uid 500); 7 Dec 2012 18:30:08 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 33034 invoked by uid 500); 7 Dec 2012 18:30:08 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 33025 invoked by uid 99); 7 Dec 2012 18:30:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 18:30:08 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of akumar202@bankofamerica.com does not designate 216.139.250.139 as permitted sender) Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 18:30:02 +0000 Received: from jim.nabble.com ([192.168.236.80]) by joe.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Th2g5-0001ne-Rx for users@openjpa.apache.org; Fri, 07 Dec 2012 10:29:38 -0800 Date: Fri, 7 Dec 2012 10:29:37 -0800 (PST) From: anand213 To: users@openjpa.apache.org Message-ID: <1354904977816-7582061.post@n2.nabble.com> In-Reply-To: References: <1354806025357-7582055.post@n2.nabble.com> Subject: Re: Unique constraint annotations not generated by Reverse Mapping tool MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Thanks for the response Kevin. I was looking for @UniqueConstraint annotation in generated files and the tool is reading the unique indexes so i expected it to put annotation for the same. @Table(name = "EMPLOYEE_FOR_CACHE", uniqueConstraints = { @UniqueConstraint(columnNames = { "dept", "project" }), @UniqueConstraint(columnNames = { "fname", "lname", "location" }) }) -- View this message in context: http://openjpa.208410.n2.nabble.com/Unique-constraint-annotations-not-generated-by-Reverse-Mapping-tool-tp7582055p7582061.html Sent from the OpenJPA Users mailing list archive at Nabble.com. From users-return-10499-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 19:49:13 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1B36B9F28 for ; Fri, 7 Dec 2012 19:49:13 +0000 (UTC) Received: (qmail 95809 invoked by uid 500); 7 Dec 2012 19:49:13 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 95728 invoked by uid 500); 7 Dec 2012 19:49:12 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 95720 invoked by uid 99); 7 Dec 2012 19:49:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 19:49:12 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.136.217.55] (HELO nm21-vm8.bullet.mail.gq1.yahoo.com) (98.136.217.55) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 19:49:03 +0000 Received: from [98.137.12.60] by nm21.bullet.mail.gq1.yahoo.com with NNFMP; 07 Dec 2012 19:48:42 -0000 Received: from [98.137.12.207] by tm5.bullet.mail.gq1.yahoo.com with NNFMP; 07 Dec 2012 19:48:42 -0000 Received: from [127.0.0.1] by omp1015.mail.gq1.yahoo.com with NNFMP; 07 Dec 2012 19:48:42 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 543417.57526.bm@omp1015.mail.gq1.yahoo.com Received: (qmail 47002 invoked by uid 60001); 7 Dec 2012 19:48:42 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1354909722; bh=k+96hi3ff6MWPMryREK9rGkwnahx7T5oMF8W3M7gLaU=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=NR6TxxnBgTTINPHYfTkvJEZdlk2yweJTDVp3RyUzTuLkVqeoVKs6WjEPtMNNZ5mUjzSDatojEs/v6gmYWb65A9bqvyyfvR/E200v4OEWkffNzfDRA9tTqvWtFz0YvKzvK7m9oyBbZ/gzUPDldO1SrBnYnKF6uvBQA4K/+uT/7Hk= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=Z4/O2bnxR5V2iTVg8D72BXS7Wmm7wRSvl8iborLcWuY4hqK6dYYSs1AwJPVCMjmVhvKXVTM6qEAOA4pFVw5feapIJQzz4EIkIFdu4/UhzQaaiI7G9eeaqOqys2Lo54HxwTjlqgsQqUYoQFctFKJh+YpG+TjmaXSat8PN9CMN2Kw=; X-YMail-OSG: mWZNUA0VM1m_m2R8W76iIORZ2Sjx8xKYEljBQKeUJ.1WELJ 1wxstLNwdWVdEVDobSKmTEINn26w2DMO7FX6MW4Rc6_Xz7LAYnjQ0KOch2Al z2sLCVJjxtvukESx16y1dHBicRBJY0UYyaAFnWyQ_DbpcgYUfC2l_R046Z_b Dbvh6zEamYqM35iYsac4WFiK9CKvRd3BENl.3QGi3wtPEp_6p9RO1eHF0GhL 1Fv7aJeFkJyao_zbxenDe.PFb8CUsCSoiJucAlJ0M5Kw4cme7cDdlGiiwz6P nvuob.N24R0NvZrR6ULpDtBufSADytux1iUh27EB9Vx4QqN3Q6TcxkdZFZ8e .QiJ_TWZDaDHObAB40y9y2CN7_eNikQJkIMFtluc9NzoyODhjGiAkOkqcQNl KRwPibrxSivKKbKPAeKAALxU6nmV_9WZLjdw_9i5eONlJhK5K2E7REiasXG4 b4Dd.c_94MogPZaUfcFzv6fOJE6nMbsPbOFOIJP7pvXCwLPZA5NGe9TVugYq oUSJhF0FvFn3lgDh8Yk7dAFnGzhFsx5EF_jbH8ckLyKiFI5.HC6WFkmz_6e4 42y6JUw-- Received: from [78.158.101.13] by web113406.mail.gq1.yahoo.com via HTTP; Fri, 07 Dec 2012 11:48:42 PST X-Rocket-MIMEInfo: 001.001,SGksCgpJIGFtIGRldmVsb3BpbmcgY29kZSB0aGF0IG9uY2UgdXNlZCBIaWJlcm5hdGUgQEZpbHRlciBhbmQgQEZpbHRlckRlZiBmb3Igc2V0dGluZyBmaWx0ZXJzIG9uIFNRTCBxdWVyaWVzLAoKSXMgdGhlcmUgYW55IGVxdWl2YWxlbnQgZmVhdHVyZSBpbiBPcGVuSlBBPwoKSSBoYXZlIHNlZW4gZnJvbSB0aGlzIEpJUkEgbGluayB0aGF0IHBlcmhhcHMgaXRzIG5vdCBpbXBsZW1lbnRlZCB5ZXQ_Cmh0dHBzOi8vaXNzdWVzLmFwYWNoZS5vcmcvamlyYS9icm93c2UvT1BFTkpQQS02NTU_YXR0YWNobWVudE9yZGUBMAEBAQE- X-Mailer: YahooMailWebService/0.8.128.478 Message-ID: <1354909722.35018.YahooMailNeo@web113406.mail.gq1.yahoo.com> Date: Fri, 7 Dec 2012 11:48:42 -0800 (PST) From: Niall Loughnane Reply-To: Niall Loughnane Subject: OpenJPA and Filters To: "users@openjpa.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="2058850404-2006709189-1354909722=:35018" X-Virus-Checked: Checked by ClamAV on apache.org --2058850404-2006709189-1354909722=:35018 Content-Type: text/plain; charset=us-ascii Hi, I am developing code that once used Hibernate @Filter and @FilterDef for setting filters on SQL queries, Is there any equivalent feature in OpenJPA? I have seen from this JIRA link that perhaps its not implemented yet? https://issues.apache.org/jira/browse/OPENJPA-655?attachmentOrder=asc Thanks, Niall --2058850404-2006709189-1354909722=:35018-- From users-return-10500-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Fri Dec 7 20:02:50 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 917EA9FBD for ; Fri, 7 Dec 2012 20:02:50 +0000 (UTC) Received: (qmail 42511 invoked by uid 500); 7 Dec 2012 20:02:50 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 42478 invoked by uid 500); 7 Dec 2012 20:02:50 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 42470 invoked by uid 99); 7 Dec 2012 20:02:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 20:02:50 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 20:02:45 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so794086lbb.33 for ; Fri, 07 Dec 2012 12:02:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=1d1Kjj4Do9CNys+apFdJ1iaZvwWahiL1+qNbJf6LeC8=; b=dEcaqa2E4F8DPNOCDt3MQYfP3I6Q8vhTu6qNQegrNnX8NNxyhGPw25fZNDFQjvvfWE giKmTeVaHCTBuPTS6F93JyvxrxgnGqIdBeMGLCF9j9mKAORpB6+dujGl6hYkZUS/tnD1 oDy6XyBJgdnXRNu49QHPK5zuvSoaYrUR+11zc1Lk9Cb0e09DnUiWZdZjm4FNk7HXWoaj uzQt4fK7ywS1rvE5pR0hXtFcB/tDWF5HnjrDd6Azt6jL86uUDrHsTKxkfm6jWom9dVlh viuWtjs+gZVXCxVr6eref6xYIYKv/SKvr2BiY3ienbs3tBpIqpsc10mYtZ/z/Ra32XqJ 2jzw== Received: by 10.112.30.200 with SMTP id u8mr2960993lbh.104.1354910544012; Fri, 07 Dec 2012 12:02:24 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Fri, 7 Dec 2012 12:02:03 -0800 (PST) In-Reply-To: <1354904977816-7582061.post@n2.nabble.com> References: <1354806025357-7582055.post@n2.nabble.com> <1354904977816-7582061.post@n2.nabble.com> From: Kevin Sutter Date: Fri, 7 Dec 2012 14:02:03 -0600 Message-ID: Subject: Re: Unique constraint annotations not generated by Reverse Mapping tool To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=bcaec52e6009ada5d704d048b14d X-Virus-Checked: Checked by ClamAV on apache.org --bcaec52e6009ada5d704d048b14d Content-Type: text/plain; charset=ISO-8859-1 Ahh, thanks for the clarification. Although Unique Indexes and Unique Constraints are very similar in function, my guess is OpenJPA is only recognizing Unique Constraints in the schema. Then again, it may be that the Unique Constraints are not recognized at all during the Reverse Mapping process... Sorry, I just haven't had direct experience with this use of the Reverse Mapping. You could try using Unique Constraints in your schema instead of Unique Indexes to see if it makes a difference. Otherwise, you might have to resort to hand-modifying the Entity java code that is generated. Opening a JIRA for this capability would also be a good idea. Thanks, Kevin On Fri, Dec 7, 2012 at 12:29 PM, anand213 wrote: > Thanks for the response Kevin. > > I was looking for @UniqueConstraint annotation in generated files and the > tool is reading the unique indexes so i expected it to put annotation for > the same. > > @Table(name = "EMPLOYEE_FOR_CACHE", uniqueConstraints = { > @UniqueConstraint(columnNames = { "dept", "project" }), > @UniqueConstraint(columnNames = { "fname", "lname", > "location" }) }) > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Unique-constraint-annotations-not-generated-by-Reverse-Mapping-tool-tp7582055p7582061.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > --bcaec52e6009ada5d704d048b14d-- From users-return-10501-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Mon Dec 10 14:22:39 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BDF8BE20F for ; Mon, 10 Dec 2012 14:22:39 +0000 (UTC) Received: (qmail 32015 invoked by uid 500); 10 Dec 2012 14:15:59 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 31364 invoked by uid 500); 10 Dec 2012 14:15:51 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 31290 invoked by uid 99); 10 Dec 2012 14:15:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 14:15:49 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 14:15:39 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so2343273lbb.33 for ; Mon, 10 Dec 2012 06:15:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=uawRfGPtJW4ViD7A6CSFmj2CLmopZdfcfRm2ZR5B8+0=; b=ybILSH83wHessq/xCmxpntjcIJTlkvbTrDXXe5ZWBw0pv7HyWDJ1acbeVl85mTj6Fk HeC1sIUKXJRzhvg2IA2DORIdT2IXbR1slWg5bM+MxwqplooBZOlu1VZxPhKclrGLQHLF fiw7OaV7A8usWhWlXS7Ofa0485Z6rNyctdEMwXvZzuXt3Z1UYHA8oWtZacL8fOHdTRD7 rpINfa33+obCDC3ci5IgxabvdjadDEnSIlaooevcUX7ar9CdRuulYlHwOhQb1uG6XWyn L4GlO43XXB3LICDICrU0WMt6l5syxOGPVB7PAGserdjJ7uBIH9cWpmWb1S1yyfDBC7TS e7YQ== Received: by 10.152.104.240 with SMTP id gh16mr14179164lab.56.1355148919055; Mon, 10 Dec 2012 06:15:19 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Mon, 10 Dec 2012 06:14:57 -0800 (PST) In-Reply-To: <1355105868.11180.YahooMailNeo@web124703.mail.ne1.yahoo.com> References: <1355105868.11180.YahooMailNeo@web124703.mail.ne1.yahoo.com> From: Kevin Sutter Date: Mon, 10 Dec 2012 08:14:57 -0600 Message-ID: Subject: Fwd: The bitter end of rsync-backed site management is coming Jan 1. To: users@openjpa.apache.org, dev@openjpa.apache.org Content-Type: multipart/alternative; boundary=f46d04088e11f0256504d0803184 X-Virus-Checked: Checked by ClamAV on apache.org --f46d04088e11f0256504d0803184 Content-Type: text/plain; charset=ISO-8859-1 Good morning, Don't worry... Even though OpenJPA is on the "naughty list" below, Joe is actively moving our website artifacts from Confluence to CMS per this JIRA: https://issues.apache.org/jira/browse/INFRA-5582. So, the coal will be replaced with candy very soon... :-) Kevin ---------- Forwarded message ---------- From: Joe Schaefer Date: Sun, Dec 9, 2012 at 8:17 PM Subject: The bitter end of rsync-backed site management is coming Jan 1. To: Apache Infrastructure NOTE: If your project's site is using the CMS or svnpubsub right now you may disregard this note. If you project is listed below, you have yet to migrate your site to either the CMS or svnpubsub, which becomes mandatory starting January 1. This note will serve as your FINAL reminder to start the process of filing a JIRA ticket with INFRA to request a migration to one of those two options prior to January 1, or face a hasty unannounced withdrawal of support for your website during the month of January upon processing of all remaining timely outstanding requests filed before Jan 1. Thanks for your diligence in this matter, further questions may be addressed to infrastructure@apache.org. SANTA'S NAUGHTY LIST: activemq.apache.org apr.apache.org archive.apache.org buildr.apache.org click.apache.org commons.apache.org db.apache.org directory.apache.org favicon.ico felix.apache.org forrest.apache.org geronimo.apache.org hadoop.apache.org hbase.apache.org hc.apache.org hive.apache.org jackrabbit.apache.org jmeter.apache.org juddi.apache.org karaf.apache.org lenya.apache.org maven.apache.org ode.apache.org openjpa.apache.org openwebbeans.apache.org perl.apache.org pig.apache.org poi.apache.org portals.apache.org roller.apache.org santuario.apache.org shiro.apache.org sling.apache.org spamassassin.apache.org struts.apache.org synapse.apache.org tapestry.apache.org tcl.apache.org tiles.apache.org turbine.apache.org tuscany.apache.org uima.apache.org velocity.apache.org whirr.apache.org wiki.apache.org ws.apache.org xerces.apache.org xml.apache.org xmlbeans.apache.org --f46d04088e11f0256504d0803184-- From users-return-10502-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Mon Dec 10 15:40:44 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6771DD708 for ; Mon, 10 Dec 2012 15:40:44 +0000 (UTC) Received: (qmail 9680 invoked by uid 500); 10 Dec 2012 15:40:44 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 8887 invoked by uid 500); 10 Dec 2012 15:40:38 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 8837 invoked by uid 99); 10 Dec 2012 15:40:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 15:40:36 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 216.139.250.139 is neither permitted nor denied by domain of marc.walter@sbb.ch) Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 15:40:30 +0000 Received: from jim.nabble.com ([192.168.236.80]) by joe.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Ti5Sj-0003mB-G9 for users@openjpa.apache.org; Mon, 10 Dec 2012 07:40:09 -0800 Date: Mon, 10 Dec 2012 07:40:09 -0800 (PST) From: mwalter To: users@openjpa.apache.org Message-ID: <1355154009489-7582115.post@n2.nabble.com> Subject: Why is parent version incremented on update of child entity? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I found out that on update of a child entity the parent version field is incremented as well. Is this default behaviour? Is it possible to change the increment strategy somehow so that the parent version does not change? I'm using OpenJPA 1.2.3 (WebSphere V7), LockManager is set to "version". Thanks for any help and/or explanation! -- View this message in context: http://openjpa.208410.n2.nabble.com/Why-is-parent-version-incremented-on-update-of-child-entity-tp7582115.html Sent from the OpenJPA Users mailing list archive at Nabble.com. From users-return-10503-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Mon Dec 10 20:25:42 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EEFD9D80B for ; Mon, 10 Dec 2012 20:25:42 +0000 (UTC) Received: (qmail 81310 invoked by uid 500); 10 Dec 2012 20:25:42 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 81064 invoked by uid 500); 10 Dec 2012 20:25:42 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 81048 invoked by uid 99); 10 Dec 2012 20:25:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 20:25:42 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kwsutter@gmail.com designates 209.85.215.46 as permitted sender) Received: from [209.85.215.46] (HELO mail-la0-f46.google.com) (209.85.215.46) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 20:25:34 +0000 Received: by mail-la0-f46.google.com with SMTP id p5so2636473lag.33 for ; Mon, 10 Dec 2012 12:25:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=JcYzeSGz5gWtAgZMuhMS2wzidBtp4q1wiNekxS2FP2A=; b=XbnMIR2/RqplxUAWeA9Ro4GcO2YLoZgv7drs/M/6qMBdlkJSnGuOEJ1rePOloaabWo 9yrexYBiSwbSqbvEcHhyuTw3DwsyzYIZXuB/UOjMg2X1cekunvvBr3UOBt84YqCE4Giz OLcDFxF3UTqjZNkbQyR/nU8Ob++MYrC3sadgt0unM+8z3Xx+mLoOTLodn0hRRI7g5YRw Bhnykt2MpCoBr6K3WCkZVsalKzFV+9cKRrDiWG41kfbS+FG8Vg8a/57mCOdoIR3qKr+v MHlNacXa364BCnLQ0lXVhpE0b+BUy4ZHWPezAMu9r4IzCHVQh3DfREO44zzGvukubF0R PRVw== Received: by 10.112.28.9 with SMTP id x9mr6595356lbg.27.1355171113966; Mon, 10 Dec 2012 12:25:13 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Mon, 10 Dec 2012 12:24:53 -0800 (PST) From: Kevin Sutter Date: Mon, 10 Dec 2012 14:24:53 -0600 Message-ID: Subject: New CMS OpenJPA web site is now live! To: users@openjpa.apache.org, dev@openjpa.apache.org Content-Type: multipart/alternative; boundary=bcaec554dd00db9e8004d0855c90 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec554dd00db9e8004d0855c90 Content-Type: text/plain; charset=ISO-8859-1 The new CMS OpenJPA web site is now live: http://openjpa.apache.org/ You might have to reload/refresh the page to get the latest updates. For the most part, you shouldn't see any difference. There are some slight changes to formatting, images, etc. But, the content should be pretty much identical. Take a look around and let us know if there's something amiss. Thanks. If you need to make updates to the OpenJPA wiki, you'll need to follow the CMS update guidelines: http://www.apache.org/dev/cms.html#usage It's pretty straight forward. I just did a couple of minor updates as I was perusing the site. It's much easier to update the site than it was previous. Enjoy! Kevin --bcaec554dd00db9e8004d0855c90-- From users-return-10504-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Mon Dec 10 21:55:23 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 431D6D8D7 for ; Mon, 10 Dec 2012 21:55:23 +0000 (UTC) Received: (qmail 21579 invoked by uid 500); 10 Dec 2012 21:55:23 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 21532 invoked by uid 500); 10 Dec 2012 21:55:23 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 21524 invoked by uid 99); 10 Dec 2012 21:55:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 21:55:23 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [77.238.189.63] (HELO nm6.bullet.mail.ird.yahoo.com) (77.238.189.63) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Dec 2012 21:55:16 +0000 Received: from [77.238.189.54] by nm6.bullet.mail.ird.yahoo.com with NNFMP; 10 Dec 2012 21:54:53 -0000 Received: from [212.82.108.135] by tm7.bullet.mail.ird.yahoo.com with NNFMP; 10 Dec 2012 21:54:53 -0000 Received: from [127.0.0.1] by omp1040.mail.ird.yahoo.com with NNFMP; 10 Dec 2012 21:54:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 969043.85321.bm@omp1040.mail.ird.yahoo.com Received: (qmail 97479 invoked by uid 60001); 10 Dec 2012 21:54:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s1024; t=1355176493; bh=/NdWc4rr/kz1G5bNH/Aq8ycqwvO/Mh5IgDkPKW2gM8k=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=mtGKrDaKFq/ABFbFAC67FTcL4JIPcCl1pGYU3e0/BLBol6+HHdi00hbhS3l6TD23BhaacOunDP78SJy6u1E9z04CmSqZx+xoRsJzwTxQwPIVyZEfCR0Gp6G6tE0uSXuQomhTYQ8xQsrriEa7F3ooBJlQepCWlaQ6w/PQzaxgDQQ= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.de; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=Ve9PEksFQufycbsl+dccP5H40z5jhoiuIvrj9IbfmDqIxKW+9JULD7QmFirkDijjVo6zAoNXMRNVqjhs85BQgSQ3iF7LltMFZ9qSxsv67agVPYQch19gofWD2p1hiiimx4FGNg+hC1GbUjvylUusiHyAbSzGimQ7dt7WMT/8CUA=; X-YMail-OSG: Fa3DTvQVM1kcvkn4xZEzPTK388fU38Y1ZtZqYsOW2YQ45xw rIqZVQrscIeY9Pq3FFLaeaxw8MHpsAEAGj9vvtd1Z1F_OjM4c9z549WTLzBx YYKi0179KiBLwdU6zupBx_XAUZ8MeVpwDlXwYQV9EjwNm1wIFM14qGMcMRFY VfLss3HNNmTykxHc_KFlZnazqGsMYQJv.9Nv_b8uTzXr9jKjPbfCEJPWSZYN xAcBiQrSmgZSYRIqCYPzplRZeD4ujRlLwqLhxyoqoKz1uU99dgfdnkyWjmDK 4QRs2j7Qbx4QI.t6hnZtVju2FRH9ULmAlynseXsoMo4rebAAFC_bCPirDUF0 4pc3ZBg5BuTG5znU97HH673UubYwG5jYIgJeuIQIp9RZ2oa7NRA0hv2BJThj P3LEG_YWE6m7.9I.YVXkumx1Fgm4YmMx44S2Ea5PTCwxbsRfmqZfcvxM0mWm Ym8L4aaWQY5vc58b4yoAcbC0cPPhlHJfi8owrO0ZsFPwmk0mHJR6AYkyMXkX yVKcgB4Ur9BR5B.GeZzsJfs4GTl9VceyLUJtyzeooIBYX2DvYnX5SJ7GUWvq 7v9eTer3uaEHtihJrWxcf9Q6z5OSd5dRs41W8UdftYpGUNpzb85plP1bHwKt ozsdLUjURh881LYM2e.V_zcvnau1O3.6kobH1Pcq0cOFTyichE_2Sn0i4Ndx rKyjSbwYXS0_pTnZWOHQIMEABUj1WqiFZbpTkukK3ccAep_UEVMzLmid8.sa SbxylY8i4mbTWKzcF7tDc.Ro.Pky14g8v0JhrNRJfpE8l7doojQQ23RN7Tst CBQ-- Received: from [80.108.122.184] by web28905.mail.ir2.yahoo.com via HTTP; Mon, 10 Dec 2012 21:54:53 GMT X-Rocket-MIMEInfo: 001.001,VGhpcyBoYXBwZW5zIG1vc3QgdGltZXMgaWYgeW91IGhhdmUgQ2FzY2FkZS5QRVJTSVNUIGVuYWJsZWQuIFRoaXMgbWFrZXMgeW91ciAxOm4gbGlzdCBhICdwYXJ0JyBvZiB5b3VyICdtYWluIGVudGl0eScuIFRoZSBpZGVhIGlzIHRoYXQgb25jZSB5b3UgY2hhbmdlIGEgcGFydCBvZiB5b3VyIGxvZ2ljYWwgYXJlYSB5b3UgbmVlZCB0byBwcmV2ZW50IGNvbmN1cnJpbmcgY2hhbmdlcyBvbiB0aGUgd2hvbGUgYXJlYS4gT3RoZXJ3aXNlIGNvbnNpc3RlbmN5IGNhbm5vdCBnZXQgZ3VhcmFudGVlZC4gVGh1cyBhIHQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.128.478 References: <1355154009489-7582115.post@n2.nabble.com> Message-ID: <1355176493.90068.YahooMailNeo@web28905.mail.ir2.yahoo.com> Date: Mon, 10 Dec 2012 21:54:53 +0000 (GMT) From: Mark Struberg Reply-To: Mark Struberg Subject: Re: Why is parent version incremented on update of child entity? To: "users@openjpa.apache.org" In-Reply-To: <1355154009489-7582115.post@n2.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked by ClamAV on apache.org This happens most times if you have Cascade.PERSIST enabled. This makes your 1:n list a 'part' of your 'main entity'. The idea is that once you change a part of your logical area you need to prevent concurring changes on the whole area. Otherwise consistency cannot get guaranteed. Thus a touch on the 'main entity' gets performed to ensure an OptimisticLockingException in case someone else tries to change the 'logic area' at the same time. Think about a Customer with 1:n Address entries. Imagine what would happen if 2 independent users would add the same address? This would not result in a db constraint error but still the logical consistency of the Customer entry would be broken! By touching the parent entity this can be detected and would lead to optimistic locking. LieGrue, strub ----- Original Message ----- > From: mwalter > To: users@openjpa.apache.org > Cc: > Sent: Monday, December 10, 2012 4:40 PM > Subject: Why is parent version incremented on update of child entity? > > I found out that on update of a child entity the parent version field is > incremented as well. Is this default behaviour? Is it possible to change the > increment strategy somehow so that the parent version does not change? > > I'm using OpenJPA 1.2.3 (WebSphere V7), LockManager is set to > "version". > > Thanks for any help and/or explanation! > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Why-is-parent-version-incremented-on-update-of-child-entity-tp7582115.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > From users-return-10505-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Tue Dec 11 13:25:45 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 78D70D87B for ; Tue, 11 Dec 2012 13:25:45 +0000 (UTC) Received: (qmail 35240 invoked by uid 500); 11 Dec 2012 13:25:45 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 34927 invoked by uid 500); 11 Dec 2012 13:25:38 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 34895 invoked by uid 99); 11 Dec 2012 13:25:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 13:25:37 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of michael.szalay@basis06.ch designates 212.103.90.69 as permitted sender) Received: from [212.103.90.69] (HELO zimbra-mta.fenceit.ch) (212.103.90.69) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 13:25:29 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra-mta.fenceit.ch (Postfix) with ESMTP id 77C9B3406F for ; Tue, 11 Dec 2012 14:25:08 +0100 (CET) X-Virus-Scanned: amavisd-new at zimbra-mta.fenceit.ch Received: from zimbra-mta.fenceit.ch ([127.0.0.1]) by localhost (zimbra-mta.fenceit.ch [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VBzW1HStbBJY for ; Tue, 11 Dec 2012 14:25:07 +0100 (CET) Received: from b06-zimbra-s.hsz1.oe.ch (vrrp1-s.oe.ch [192.168.10.2]) by zimbra-mta.fenceit.ch (Postfix) with ESMTP id EDCAD3405F for ; Tue, 11 Dec 2012 14:25:07 +0100 (CET) Date: Tue, 11 Dec 2012 14:25:07 +0100 (CET) From: Michael Szalay To: users@openjpa.apache.org Message-ID: <274482658.288417.1355232307795.JavaMail.root@basis06.ch> In-Reply-To: <420307309.287312.1355232261487.JavaMail.root@basis06.ch> Subject: Cubrid DB Dictionary? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [192.168.10.36] X-Mailer: Zimbra 7.2.1_GA_2790 (ZimbraWebClient - GC23 (Linux)/7.2.1_GA_2790) X-Virus-Checked: Checked by ClamAV on apache.org Hi all has anyone managed to use OpenJPA with the Cubrid database? I tried it using the default Db Dictionary but I get the following error Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax: syntax error, unexpected $end, expecting OF {SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE} [code=-493, state=null] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:199) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:59) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:251) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:449) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:429) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:418) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.prepareStatement(TableJDBCSeq.java:807) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.getSequence(TableJDBCSeq.java:546) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.setSequence(TableJDBCSeq.java:588) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:893) at org.apache.openjpa.ee.AbstractManagedRuntime.doNonTransactionalWork(AbstractManagedRuntime.java:89) at org.apache.openjpa.ee.AutomaticManagedRuntime.doNonTransactionalWork(AutomaticManagedRuntime.java:315) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:445) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) ... 83 more NestedThrowables: cubrid.jdbc.driver.CUBRIDException: Syntax: syntax error, unexpected $end, expecting OF at cubrid.jdbc.driver.CUBRIDConnection.createCUBRIDException(CUBRIDConnection.java:829) at cubrid.jdbc.driver.CUBRIDConnection.prepare(CUBRIDConnection.java:583) at cubrid.jdbc.driver.CUBRIDConnection.prepare(CUBRIDConnection.java:714) at cubrid.jdbc.driver.CUBRIDConnection.prepareStatement(CUBRIDConnection.java:394) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:135) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:248) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:449) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:429) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:418) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.prepareStatement(TableJDBCSeq.java:807) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.getSequence(TableJDBCSeq.java:546) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.setSequence(TableJDBCSeq.java:588) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:893) at org.apache.openjpa.ee.AbstractManagedRuntime.doNonTransactionalWork(AbstractManagedRuntime.java:89) at org.apache.openjpa.ee.AutomaticManagedRuntime.doNonTransactionalWork(AutomaticManagedRuntime.java:315) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:445) at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778) at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493) at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762) at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135) at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600) at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3023) at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992) at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:520) at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:504) at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:407) at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:255) at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) Anyone has a hint? Regards Michael From users-return-10506-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Tue Dec 11 19:21:21 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F2B31D829 for ; Tue, 11 Dec 2012 19:21:20 +0000 (UTC) Received: (qmail 78640 invoked by uid 500); 11 Dec 2012 19:21:20 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 78567 invoked by uid 500); 11 Dec 2012 19:21:20 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 78558 invoked by uid 99); 11 Dec 2012 19:21:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 19:21:19 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 19:21:13 +0000 Received: from jim.nabble.com ([192.168.236.80]) by joe.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TiVNr-0002wP-VF for users@openjpa.apache.org; Tue, 11 Dec 2012 11:20:52 -0800 Date: Tue, 11 Dec 2012 11:20:51 -0800 (PST) From: Pinaki Poddar To: users@openjpa.apache.org Message-ID: <1355253651783-7582150.post@n2.nabble.com> In-Reply-To: References: Subject: Re: New CMS OpenJPA web site is now live! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org All the doc links are broken on this [1] page [1] http://openjpa.apache.org/documentation.html ----- Pinaki Poddar Chair, Apache OpenJPA Project -- View this message in context: http://openjpa.208410.n2.nabble.com/New-CMS-OpenJPA-web-site-is-now-live-tp7582124p7582150.html Sent from the OpenJPA Users mailing list archive at Nabble.com. From users-return-10507-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Tue Dec 11 19:39:13 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9CB7CDABB for ; Tue, 11 Dec 2012 19:39:13 +0000 (UTC) Received: (qmail 45426 invoked by uid 500); 11 Dec 2012 19:39:13 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 45394 invoked by uid 500); 11 Dec 2012 19:39:13 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 45385 invoked by uid 99); 11 Dec 2012 19:39:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 19:39:13 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 19:39:07 +0000 Received: by mail-lb0-f174.google.com with SMTP id gi11so3683526lbb.33 for ; Tue, 11 Dec 2012 11:38:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=nreOZ2Hwn0fGj29Y+T5JSuutM8YizeBYfXvCzidiri4=; b=T7u7ii/laTh99CkR8F7Gz0P/GBKdSqQaaeZaAvJzHiIthkcL7eRiythnHrJkc7WCn9 cjCQG9949CSUw+o45IKBK9vPoLweUXFOuyXAFZQYFn9sgJsyk2xFY0lMYVMZM0d2c+bo H8XHDdjOTrnc7Ty01DCE+zk2Rzhjr/V8HKA46kJtiQW0U0vrxJJSNvR6s1mfX84AcrKg jhf3Mgddmialo0AdCDfuSpyH/YGao046pP4xFOKinvO6xcb7fz0arnoqLug+DJM6ooEf 4+cyoRF6t7GSCryfTo14E7JAQCVmFm0aqriUprfmWdqUceI5bW+UaWAAjIQiHMwYCvK3 O0jg== Received: by 10.152.105.33 with SMTP id gj1mr18423859lab.49.1355254726040; Tue, 11 Dec 2012 11:38:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.111.132 with HTTP; Tue, 11 Dec 2012 11:38:25 -0800 (PST) In-Reply-To: <1355253651783-7582150.post@n2.nabble.com> References: <1355253651783-7582150.post@n2.nabble.com> From: Kevin Sutter Date: Tue, 11 Dec 2012 13:38:25 -0600 Message-ID: Subject: Re: New CMS OpenJPA web site is now live! To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=f46d040716e3869bfd04d098d41d X-Virus-Checked: Checked by ClamAV on apache.org --f46d040716e3869bfd04d098d41d Content-Type: text/plain; charset=ISO-8859-1 This is already being discussed and worked by yours truly... And, it's also one of the reasons I've been pinging you about about build systems (team city, jenkins, etc)... :-) http://openjpa.208410.n2.nabble.com/doc-broken-td7582140.html Kevin On Tue, Dec 11, 2012 at 1:20 PM, Pinaki Poddar wrote: > All the doc links are broken on this [1] page > > [1] http://openjpa.apache.org/documentation.html > > > > > ----- > Pinaki Poddar > Chair, Apache OpenJPA Project > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/New-CMS-OpenJPA-web-site-is-now-live-tp7582124p7582150.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > --f46d040716e3869bfd04d098d41d-- From users-return-10508-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Wed Dec 12 09:44:11 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AF4A1DC44 for ; Wed, 12 Dec 2012 09:44:11 +0000 (UTC) Received: (qmail 7605 invoked by uid 500); 12 Dec 2012 09:44:11 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 7363 invoked by uid 500); 12 Dec 2012 09:44:07 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 7309 invoked by uid 99); 12 Dec 2012 09:44:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Dec 2012 09:44:05 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [194.109.24.24] (HELO smtp-vbr4.xs4all.nl) (194.109.24.24) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Dec 2012 09:43:57 +0000 Received: from remote.huizemolenaar.nl (D57D0452.static.ziggozakelijk.nl [213.125.4.82]) (authenticated bits=0) by smtp-vbr4.xs4all.nl (8.13.8/8.13.8) with ESMTP id qBC9hbmx044857 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=FAIL) for ; Wed, 12 Dec 2012 10:43:37 +0100 (CET) (envelope-from henno@huizemolenaar.nl) Received: from HMS.hm.local ([fe80::6051:4a91:4c0d:d963]) by HMS.hm.local ([fe80::6051:4a91:4c0d:d963%11]) with mapi; Wed, 12 Dec 2012 10:43:39 +0100 From: Henno Vermeulen To: "'users@openjpa.apache.org'" Date: Wed, 12 Dec 2012 10:43:38 +0100 Subject: RE: How to eagerly fetch two-level nested associations? Thread-Topic: How to eagerly fetch two-level nested associations? Thread-Index: Ac3QL7mT+Faf4OVIRWmnWa2d523i2QIGdX7A Message-ID: <1C448C478A6B4743AF19DBC3C3DCE1320394D5610581@HMS.hm.local> References: In-Reply-To: Accept-Language: nl-NL Content-Language: nl-NL X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: nl-NL Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Virus-Scanned: by XS4ALL Virus Scanner X-Virus-Checked: Checked by ClamAV on apache.org SSBoYXZlIGJlZW4gc3RydWdnbGluZyBmb3IgcXVpdGUgc29tZSB0aW1lIHdpdGggdGhlIGV4YWN0 IHNhbWUgc2l0dWF0aW9uIHRvIHRoZSBwb2ludCBvZiB1c2luZyB0aGUgZGVidWdnZXIsIGRvd25s b2FkaW5nIHRoZSBjb2RlIGFuZCBjcmVhdGluZyBvZmZpY2lhbCBPcGVuSlBBIHVuaXQgdGVzdHMu IE15IGN1cnJlbnQgY29uY2x1c2lvbiBpcyB0aGF0IGl0J3MgaW1wb3NzaWJsZSB3aXRoIE9wZW5K UEEuIFNvIHBsZWFzZSBjb21tZW50L3ZvdGUvd2F0Y2ggdGhlIGlzc3VlIHRoYXQgSSBjcmVhdGVk IGh0dHBzOi8vaXNzdWVzLmFwYWNoZS5vcmcvamlyYS9icm93c2UvT1BFTkpQQS0yMjk2LiBVbmZv cnR1bmF0ZWx5IEkgaGF2ZSBoYWQgbm8gcmVzcG9uc2UgYXQgYWxsIGZyb20gYW4gT3BlbkpQQSBj b21taXR0ZXIgeWV0LiBJIGV2ZW4gc3VjY2VlZGVkIGluIGdldHRpbmcgdGhlIHNpdHVhdGlvbiBB ICouLjEgQiAxLi4qIEMgd29ya2luZyBieSAiZmxpcHBpbmcgYSBiaXQiIGhvd2V2ZXIgSSBoYXZl IG5vIGlkZWEgb24gdGhlIGZ1bGwgY29uc2VxdWVuY2VzIG9mIHN1Y2ggYSBjaGFuZ2UuDQoNCkkg Zm91bmQgdGhhdCBIaWJlcm5hdGUgaGFzIGFuIGFubm90YXRpb24gQEZldGNoKEZldGNoTW9kZS5T VUJTRUxFQ1QpIHdoaWNoIGRvZXMgZXhhY3RseSB3aGF0IHdlIHdhbnQuIEFsdGVybmF0aXZlbHkg SGliZXJuYXRlIGhhcyBhbiBAQmF0Y2hTaXplIGFubm90YXRpb24gdG8gZmV0Y2ggYSBnaXZlbiBu dW1iZXIgb2YgQyBhdCBvbmNlLiBCdXQgdW5mb3J0dW5hdGVseSBJIGhhdmUgbm90IGZvdW5kIHN1 Y2ggYW4gb3B0aW9uIHdpdGggT3BlbkpQQS4NCg0KV2hhdCBpcyBhY3R1YWxseSBoYXBwZW5pbmcg aXMgdGhhdCBmb3IgZWFjaCBCIGFuZCBlYWNoIGZpZWxkIGluIEIgdGhhdCBpcyBhIHJlbGF0aW9u IHN1Y2ggYXMgYSBjb2xsZWN0aW9uIG9mIEMsIG9uZSBxdWVyeSBpcyBleGVjdXRlZCB0byBmZXRj aCB0aGF0IHJlbGF0aW9uLiAoU28gSSBndWVzcyB5b3UgZGlkIG5vdCBtZWFuIGEgcXVlcnkgZm9y IGVhY2ggQywgYnV0IGEgcXVlcnkgb24gQyBmb3IgZWFjaCBCKS4gSSB0aGluayBhbiB1Z2x5IHdv cmthcm91bmQgbWF5IGJlIGRvbmUgYnkgdXNpbmcgY2FjaGVkIGVudGl0aWVzIGluIHRoZSBlbnRp dHkgbWFuYWdlciBjb250ZXh0LiBJZiB5b3UgZmlyc3Qgc2VsZWN0IGFsbCBCIHRoYXQgbWF0Y2gg eW91ciB3aGVyZSBvbiBBLCBPcGVuSlBBIHNob3VsZCBiZSBhYmxlIHRvIHJldXNlIHRoZXNlIGNh Y2hlZCBCJ3MgaW4geW91ciBxdWVyeSBmb3IgQS4NCg0KSGVubm8NCg0KDQotLS0tLU9vcnNwcm9u a2VsaWprIGJlcmljaHQtLS0tLQ0KVmFuOiBQYXVsbyBSb2RyaWd1ZXMgUGludG8gW21haWx0bzpy ZWd1bGFyamFja0BnbWFpbC5jb21dIA0KVmVyem9uZGVuOiB6b25kYWcgMiBkZWNlbWJlciAyMDEy IDI6MDQNCkFhbjogdXNlcnNAb3BlbmpwYS5hcGFjaGUub3JnDQpPbmRlcndlcnA6IEhvdyB0byBl YWdlcmx5IGZldGNoIHR3by1sZXZlbCBuZXN0ZWQgYXNzb2NpYXRpb25zPw0KDQpJJ20gdHJ5aW5n IHRvIGVmZmljaWVudGx5IGZldGNoIGEgdHdvLWxldmVsIG5lc3RlZCBhc3NvY2lhdGlvbiB1c2lu Zw0KT3BlbkpQQSAyLjIuMC4gQmFzaWNhbGx5LCBJIGhhdmUgb25lIEF0aGF0IGhhcyBvbmUgQiB0 aGF0IGhhcyBtYW55IEM6DQoNCkBFbnRpdHlwdWJsaWMgY2xhc3MgQSB7DQogICAgLi4uDQoNCiAg ICBATWFueVRvT25lKGZldGNoPUZldGNoVHlwZS5FQUdFUikNCiAgICBwcml2YXRlIEIgYjt9DQpA RW50aXR5cHVibGljIGNsYXNzIEIgew0KICAgIC4uLg0KDQogICAgQE9uZVRvTWFueShtYXBwZWRC eT0iYiIsIGZldGNoPUZldGNoVHlwZS5FQUdFUikNCiAgICBwcml2YXRlIExpc3Q8Qz4gY3M7fQ0K QEVudGl0eXB1YmxpYyBjbGFzcyBDIHsNCiAgICAuLi59DQoNCk15IEpQUUwgcXVlcnkgaXMgYXMg Zm9sbG93czoNCg0KU0VMRUNUIGENCkZST00gQSBhDQpXSEVSRSBhLmlkID0gc29tZSBjb25kaXRp b24NCg0KIEkgc2V0IHRoZSBFYWdlckZldGNoTW9kZTxodHRwOi8vb3BlbmpwYS5hcGFjaGUub3Jn L2J1aWxkcy8yLjIuMC9hcGFjaGUtb3BlbmpwYS9kb2NzL3JlZl9ndWlkZV9wZXJmcGFja19lYWdl ci5odG1sPg0KdG8NCiJQQVJBTExFTCIgaW4gb3JkZXIgdG8gaGF2ZSBhIHNlY29uZCBxdWVyeSB0 aGF0IHJldHJpZXZlcyB0aGUgQ3Mgb2YgYWxsIHRoZQ0KQnM6DQoNCjxwcm9wZXJ0eSBuYW1lPSJv cGVuanBhLmpkYmMuRWFnZXJGZXRjaE1vZGUiDQp2YWx1ZT0icGFyYWxsZWwiLz48cHJvcGVydHkN Cm5hbWU9Im9yZy5hcGFjaGUub3BlbmpwYS5wZXJzaXN0ZW5jZS5qZGJjLkVhZ2VyRmV0Y2hNb2Rl Ig0KdmFsdWU9IlBBUkFMTEVMIi8+DQoNCiBUaGUgcHJvYmxlbSBpcyB0aGF0IG9wZW5qcGEgaXMg Z2VuZXJhdGluZyBuKzEgcXVlcmllcyBpbnN0ZWFkIG9mIDI6IG9uZQ0KZm9yIHRoZSBBcyBhbmQg QnMgYW5kIG9uZSBmb3IgZWFjaCBDOg0KDQpTRUxFQ1QgKkZST00gYUxFRlQgT1VURVIgSk9JTiBi DQogICAgT04gYS5iX2lkID0gYi5pZCBXSEVSRSBzb21lIGNvbmRpdGlvbg0KDQogYW5kIG4gdGlt ZXMNCg0KU0VMRUNUICpGUk9NIGMgV0hFUkUgYy5iX2lkID0geA0KDQogKkhvdyBjYW4gSSBtYWtl IG9wZW5qcGEgaXNzdWUgdHdvIHF1ZXJpZXMgaW5zdGVhZCBvZiBuKzE/Kg0K From users-return-10509-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Wed Dec 12 23:36:04 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A54ECDC4B for ; Wed, 12 Dec 2012 23:36:04 +0000 (UTC) Received: (qmail 45361 invoked by uid 500); 12 Dec 2012 23:36:04 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 45254 invoked by uid 500); 12 Dec 2012 23:36:03 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 45244 invoked by uid 99); 12 Dec 2012 23:36:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Dec 2012 23:36:03 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of alcarola@gmail.com designates 209.85.219.46 as permitted sender) Received: from [209.85.219.46] (HELO mail-oa0-f46.google.com) (209.85.219.46) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Dec 2012 23:35:57 +0000 Received: by mail-oa0-f46.google.com with SMTP id h16so1501729oag.33 for ; Wed, 12 Dec 2012 15:35:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=Ac8d3gLX5Yubtu8M/EPEKoAgH/9F+0Rh5V0gLz0MT0U=; b=lIS4XdWMqkDN6qi5Vyq5sbtsApcdNGG4/EA5TmRokl4F7qFdybgpMCawNdjSYiQUmI 9wqhVL9EK2gqMQVzTO4yN90ZudhbJkiex6+PA4opOtBkA+rbuBlDudg1bWXSHrgobMxf iduXWh4nHTWd0mhiIgVVBi3aCkaEK+823dMaHsul9h2naubX6F3j/3YpnyPBVqQHDicw DnLfQvRu0xaZzRUgvPYI7Jc9gVZb3iXonVeQHEaEpFSwaofOwg8M4Jp/ilw69fiM04if ZxGPdwlsmi2kIvvAPw8lJu67N2g1HaFYz2POif3CarPKO4yG7KmL75ghi2KKwHnd90vP v5nQ== MIME-Version: 1.0 Received: by 10.60.170.242 with SMTP id ap18mr1486435oec.97.1355355336179; Wed, 12 Dec 2012 15:35:36 -0800 (PST) Received: by 10.182.106.35 with HTTP; Wed, 12 Dec 2012 15:35:36 -0800 (PST) Date: Thu, 13 Dec 2012 01:35:36 +0200 Message-ID: Subject: MySQL timeouts? From: Mikael Kurula To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=bcaec54d3f845b7f3c04d0b04112 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec54d3f845b7f3c04d0b04112 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear All, As an ordinary user of OpenMeetings, I'm using OpenJPA for persistence. I have an issue with MySQL timing out. I posted a bug report in the OpenMeetings JIRA, but I was directed to OpenJPA instead. I sometimes get messages of the following type in my OpenMeetings log, mainly in the morning when nobody has used the server overnight; notice the extremely long time since the last successful transmission: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 90,881,924 milliseconds ago. The last packet sent successfully to the server was 90,881,924 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=3Dtrue' to avoid this problem. >From what I understood, autoReconnect=3Dtrue is already in use. Has anyone here seen anything like this? My version of openmeetings is this: apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz ... and the version of the J connector is mysql-connector-java-5.1.22.tar.gz. I don't know how to check which version of OpenJPA I'm using, but my persistence.xml is attached below. Thanks a lot for any help, Mikael --- 8< --- org.apache.openjpa.persistence.PersistenceProviderImpl org.openmeetings.app.persistence.beans.adresses.Adresses org.openmeetings.app.persistence.beans.adresses.States org.openmeetings.app.persistence.beans.basic.Configuration org.openmeetings.app.persistence.beans.basic.ErrorType org.openmeetings.app.persistence.beans.basic.ErrorValues org.openmeetings.app.persistence.beans.basic.LdapConfig org.openmeetings.app.persistence.beans.basic.Naviglobal org.openmeetings.app.persistence.beans.basic.Navimain org.openmeetings.app.persistence.beans.basic.OmTimeZone org.openmeetings.app.persistence.beans.basic.Sessiondata org.openmeetings.app.persistence.beans.basic.SOAPLogin org.openmeetings.app.persistence.beans.calendar.Appointment org.openmeetings.app.persistence.beans.calendar.AppointmentCategory<= /class> org.openmeetings.app.persistence.beans.calendar.AppointmentReminderT= yps org.openmeetings.app.persistence.beans.calendar.MeetingMember org.openmeetings.app.persistence.beans.domain.Organisation org.openmeetings.app.persistence.beans.domain.Organisation_Users org.openmeetings.app.persistence.beans.flvrecord.FlvRecording org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingLog org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaDat= a org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaDel= ta org.openmeetings.app.persistence.beans.invitation.Invitations org.openmeetings.app.persistence.beans.lang.FieldLanguage org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues org.openmeetings.app.persistence.beans.lang.Fieldvalues org.openmeetings.app.persistence.beans.logs.ConferenceLog org.openmeetings.app.persistence.beans.logs.ConferenceLogType org.openmeetings.app.persistence.beans.poll.PollType org.openmeetings.app.persistence.beans.poll.RoomPoll org.openmeetings.app.persistence.beans.poll.RoomPollAnswers org.openmeetings.app.persistence.beans.rooms.RoomModerators org.openmeetings.app.persistence.beans.rooms.Rooms org.openmeetings.app.persistence.beans.rooms.RoomTypes org.openmeetings.app.persistence.beans.rooms.Rooms_Organisation org.openmeetings.app.persistence.beans.sip.OpenXGReturnObject org.openmeetings.app.persistence.beans.user.PrivateMessages org.openmeetings.app.persistence.beans.user.PrivateMessageFolder org.openmeetings.app.persistence.beans.user.Salutations org.openmeetings.app.persistence.beans.user.UserContacts org.openmeetings.app.persistence.beans.user.Userdata org.openmeetings.app.persistence.beans.user.Userlevel org.openmeetings.app.persistence.beans.user.UserSipData org.openmeetings.app.persistence.beans.user.Users org.openmeetings.app.persistence.beans.files.FileExplorerItem org.openmeetings.app.persistence.beans.sip.asterisk.AsteriskSipUsers= org.openmeetings.app.persistence.beans.sip.asterisk.Extensions org.openmeetings.app.persistence.beans.sip.asterisk.MeetMe false --bcaec54d3f845b7f3c04d0b04112-- From users-return-10510-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Thu Dec 13 02:04:45 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3DB1FD405 for ; Thu, 13 Dec 2012 02:04:45 +0000 (UTC) Received: (qmail 14873 invoked by uid 500); 13 Dec 2012 02:04:45 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 14786 invoked by uid 500); 13 Dec 2012 02:04:44 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 14777 invoked by uid 99); 13 Dec 2012 02:04:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 02:04:44 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of solomax666@gmail.com designates 209.85.210.46 as permitted sender) Received: from [209.85.210.46] (HELO mail-da0-f46.google.com) (209.85.210.46) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 02:04:37 +0000 Received: by mail-da0-f46.google.com with SMTP id p5so482805dak.33 for ; Wed, 12 Dec 2012 18:04:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=JGFt1wsCXXzNYb2PUFZDt74KPZTxOH2CtxPBYXSpdH0=; b=wXsAPM4wfIhJfD/y+OUrPNQ/hL+7QETsssGJ8/+Fg1DGScOgK0uVbYLJVxrvtgzXku unJO8UIDhGkyky7hEstRWHnAUQdHNuWbyTluRKQTLC6+7OwR4PMsw8GfyT+xrdCk73dJ i/bsA23QT8uEqqmOZufpi5Qyn4wcJtELd8Wwb8MgSx64i9ibCWhNUWW7JuRKA6zoRhUK ZuEkK3vUTb6ucN6bll52LI8By4ShThkwW1+lBdb3fxUXQSFRFh+9IIjG5fBtrvlz6q01 i+mtDMO18BzldZeQxsY2oGoFzMo3/eUv/iYB0VsvFcU3Lh2Bq/2nz//ofh8FTmxEwMEy HUrw== MIME-Version: 1.0 Received: by 10.66.83.6 with SMTP id m6mr1610224pay.52.1355364255783; Wed, 12 Dec 2012 18:04:15 -0800 (PST) Received: by 10.68.210.8 with HTTP; Wed, 12 Dec 2012 18:04:15 -0800 (PST) In-Reply-To: References: Date: Thu, 13 Dec 2012 09:04:15 +0700 Message-ID: Subject: Re: MySQL timeouts? From: Maxim Solodovnik To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=f46d042ef46f01dc1f04d0b25591 X-Virus-Checked: Checked by ClamAV on apache.org --f46d042ef46f01dc1f04d0b25591 Content-Type: text/plain; charset=UTF-8 On Thu, Dec 13, 2012 at 6:35 AM, Mikael Kurula wrote: > I don't know how to check which version of OpenJPA I'm using The version of OpenJPA is: openjpa-bundle-2.2.1.jar -- WBR Maxim aka solomax --f46d042ef46f01dc1f04d0b25591-- From users-return-10511-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Thu Dec 13 08:02:16 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F066AD7DF for ; Thu, 13 Dec 2012 08:02:15 +0000 (UTC) Received: (qmail 21538 invoked by uid 500); 13 Dec 2012 08:02:15 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 21351 invoked by uid 500); 13 Dec 2012 08:02:14 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 21327 invoked by uid 99); 13 Dec 2012 08:02:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 08:02:14 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of seba.wagner@gmail.com designates 209.85.220.46 as permitted sender) Received: from [209.85.220.46] (HELO mail-pa0-f46.google.com) (209.85.220.46) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 08:02:08 +0000 Received: by mail-pa0-f46.google.com with SMTP id bh2so1282380pad.33 for ; Thu, 13 Dec 2012 00:01:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=pVsLfVnnX5CRkFTvsC5AYw6jiiE0fmMaugyf32NlqlA=; b=WQF4MGHC9HGMu61B5S976I9q3hO9ObMRkghTCWjxp3nvTWIjUCJ6abxwn1BI0Y2NUI mbmbKL96+6y5y4BDphUfyFsFfq8Qz+pSCVsElgtqsv7E4grVn+DEVbELjGsr5JyGVpAI lEngX7g9U/8lBTbpsnS9Voon9OK5sgIiavONWTQJ61D0OOEe3YDkvMufyMiL0tZeROxF Ct3ChpENZQx4yunb6TpLit6modWNdhY9v4F1aor+Ky+/TUp2jLsIdhajifphBM3nWV16 q5E/keDuIjTK5nnT5EWccz7V54qoD8qsEHgTaSmHxrymBW18+t8rxscPnsV0+hjwPvM2 EPhQ== Received: by 10.68.189.163 with SMTP id gj3mr2968461pbc.110.1355385706792; Thu, 13 Dec 2012 00:01:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.68.0.231 with HTTP; Thu, 13 Dec 2012 00:01:26 -0800 (PST) In-Reply-To: References: From: "seba.wagner@gmail.com" Date: Thu, 13 Dec 2012 18:01:26 +1000 Message-ID: Subject: Re: MySQL timeouts? To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=e89a8ff1ccd296483e04d0b753f2 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8ff1ccd296483e04d0b753f2 Content-Type: text/plain; charset=ISO-8859-1 *is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing* => What is your value of the MySQL configuration wait_timeout ? See for example also: https://www.google.com.au/search?q=MySQL+configure+wait_timeout If you tell us your config value we can compare it to our running server(s) and if there is any discrepancy. Sebastian 2012/12/13 Maxim Solodovnik > On Thu, Dec 13, 2012 at 6:35 AM, Mikael Kurula wrote: > > > I don't know how to check which version of OpenJPA I'm using > > > The version of OpenJPA is: openjpa-bundle-2.2.1.jar > > > -- > WBR > Maxim aka solomax > -- Sebastian Wagner https://twitter.com/#!/dead_lock http://www.webbase-design.de http://www.wagner-sebastian.com seba.wagner@gmail.com --e89a8ff1ccd296483e04d0b753f2-- From users-return-10512-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Thu Dec 13 09:34:22 2012 Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1A12DDE75 for ; Thu, 13 Dec 2012 09:34:22 +0000 (UTC) Received: (qmail 74765 invoked by uid 500); 13 Dec 2012 09:34:21 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 74715 invoked by uid 500); 13 Dec 2012 09:34:20 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 74668 invoked by uid 99); 13 Dec 2012 09:34:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 09:34:19 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of alcarola@gmail.com designates 209.85.210.46 as permitted sender) Received: from [209.85.210.46] (HELO mail-da0-f46.google.com) (209.85.210.46) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2012 09:34:14 +0000 Received: by mail-da0-f46.google.com with SMTP id p5so685769dak.33 for ; Thu, 13 Dec 2012 01:33:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=bTPJLWFOtcO2/51T/1HOYbSF9b2A6oCOGVApZLddluU=; b=AwbDaruNNT9Wbd9yi7+9Djj5lgtIOYN7F4SiAmIGid4XZsA8yjI94DcW8VushHhrY4 IsEaCSZE+Xzp3tO2WVdtK32C7LrHXfaiDBdEqtgVnVNF99TNUf+RQIGOwsAJUEWqISII U4aJWp5gfxSDT6yYmNOB/LHMEi53HZDPjhRox2sVXYUco+jRJF1dop2v0/cqW2gTAaY5 oZmLWFNiEDxW3dwW8MpZGTgPSblbUmPBaE5afHeCFO3mGWHVS4PI3EO9+FDpP8r5AU2f uAVapVAuPzjVGLuaM48c94lRKXz7k8qfoDKO0PvZd7UQRSlEvDAZj0hEJ8+k6bd1qMq4 AZYA== MIME-Version: 1.0 Received: by 10.68.242.225 with SMTP id wt1mr3678403pbc.65.1355391234259; Thu, 13 Dec 2012 01:33:54 -0800 (PST) Received: by 10.68.73.167 with HTTP; Thu, 13 Dec 2012 01:33:54 -0800 (PST) In-Reply-To: References: Date: Thu, 13 Dec 2012 11:33:54 +0200 Message-ID: Subject: Re: MySQL timeouts? From: Mikael Kurula To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=047d7b339c870cb95904d0b89d76 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b339c870cb95904d0b89d76 Content-Type: text/plain; charset=ISO-8859-1 Hi! I'm not quite sure I understood what you want me to check; is this it? mysql> SHOW GLOBAL VARIABLES LIKE "wait_timeout"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) mysql> SHOW VARIABLES LIKE "wait_timeout"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) Friendly greetings, Mikael On 13 December 2012 10:01, seba.wagner@gmail.com wrote: > *is longer than the server configured value of > 'wait_timeout'. You should consider either expiring and/or testing* > > => What is your value of the MySQL configuration wait_timeout ? > > See for example also: > https://www.google.com.au/search?q=MySQL+configure+wait_timeout > > If you tell us your config value we can compare it to our running server(s) > and if there is any discrepancy. > > Sebastian > > > > 2012/12/13 Maxim Solodovnik > > > On Thu, Dec 13, 2012 at 6:35 AM, Mikael Kurula > wrote: > > > > > I don't know how to check which version of OpenJPA I'm using > > > > > > The version of OpenJPA is: openjpa-bundle-2.2.1.jar > > > > > > -- > > WBR > > Maxim aka solomax > > > > > > -- > Sebastian Wagner > https://twitter.com/#!/dead_lock > http://www.webbase-design.de > http://www.wagner-sebastian.com > seba.wagner@gmail.com > --047d7b339c870cb95904d0b89d76--