From open-jpa-dev-return-813-apmail-incubator-open-jpa-dev-archive=incubator.apache.org@incubator.apache.org Wed Oct 04 09:33:11 2006 Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 38229 invoked from network); 4 Oct 2006 09:33:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Oct 2006 09:33:11 -0000 Received: (qmail 68596 invoked by uid 500); 4 Oct 2006 09:33:10 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 68512 invoked by uid 500); 4 Oct 2006 09:33:10 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 68503 invoked by uid 99); 4 Oct 2006 09:33:10 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Oct 2006 02:33:10 -0700 Authentication-Results: idunn.apache.osuosl.org header.from=david_jencks@yahoo.com; domainkeys=good X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS DomainKey-Status: good X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 Received: from [68.142.206.243] ([68.142.206.243:34452] helo=smtp110.plus.mail.mud.yahoo.com) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id 09/D2-00170-4BF73254 for ; Wed, 04 Oct 2006 02:32:41 -0700 Received: (qmail 22334 invoked from network); 4 Oct 2006 07:31:14 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Mime-Version:In-Reply-To:References:Content-Type:Message-Id:Content-Transfer-Encoding:From:Subject:Date:To:X-Mailer; b=2U2KtFhJT+ramMIwVBm1fCDXLIG3FptfZOHA+t+DKCAzXdr40+/WpB/qCZvTcVlx1FzucUlXbWEQ84ZDFy14IG1A1H05sP+f8n1FOpTG4XHUZCB+vdUBljVxnGOw1xWRA5lf/JS/VFEvpoAo+xkpW6uJVAc4F7LaDa4UFDlDmRE= ; Received: from unknown (HELO ?10.11.55.38?) (david?jencks@63.105.20.225 with plain) by smtp110.plus.mail.mud.yahoo.com with SMTP; 4 Oct 2006 07:31:14 -0000 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <0A26A3B7-509D-4F99-877F-29E996343C57@bea.com> References: <64C583F5-C689-4AB5-82D6-63A0C37D9D23@yahoo.com> <0A26A3B7-509D-4F99-877F-29E996343C57@bea.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <9C1D8855-A573-4A76-B388-81EEE08AD8DA@yahoo.com> Content-Transfer-Encoding: 7bit From: David Jencks Subject: Re: Problem with sequence trying to commit inside a JTA tx Date: Wed, 4 Oct 2006 00:31:02 -0700 To: open-jpa-dev@incubator.apache.org X-Mailer: Apple Mail (2.752.2) X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Oct 3, 2006, at 9:54 AM, Abe White wrote: >> I'm trying to set up a really simple example inside geronimo with >> container managed transactions/persistence contexts. When I >> create and persist an object the TableJDBCSeq is trying to commit >> the connection before closing it: since it's in a JTA tx of course >> this fails. > > http://people.apache.org/~mprudhom/openjpa/site/openjpa-project/ > manual/ > ref_guide_dbsetup_thirdparty.html#ref_guide_dbsetup_thirdparty_enlist > > See above docs on managed and XA datasources. And right now we > unfortunately don't have a way to set the seq type (transactional, > etc) through JPA. If you'd like to take the initiative to make a > JIRA report on it, that'd be great. I'll comment on the report you > create with the steps necessary to expose this functionality to the > JPA layer. Following the advice there (and elsewhere) I managed to get my example working!!! The main step appears to be including a non-jta datasource. I'm still unable to figure out how to get the tables auto-created. Putting properties in persistence.xml or feeding them to persistenceProvider.createContainerEntityManagerFactory doesn't seem to have any discernable effect. Any advice on how to figure out what is going on? Is there an m2 plugin for running the tools for e.g. creating tables, db scripts, etc? With regard to your JIRA suggestion, are you saying there is no way using these properties to choose between e.g. TableJDBCSeq and ClassTableJDBCSeq or the oracle sequence sequence? I'm happy to file lots of jiras but I'd prefer to be a little more sure of what the problem is :-) Also, it appears that the documentation generally says property names are e.g. openjpa.jdbc.kernel.PropertyName whereas there is some indication in the code that they are the more correct org.apache.openjpa.jdbc.kernel.PropertyName. Which is right? If they are actually as per the docs shouldn't they be changed pronto? thanks! david jencks > ______________________________________________________________________ > _ > Notice: This email message, together with any attachments, may > contain > information of BEA Systems, Inc., its subsidiaries and > affiliated > entities, that may be confidential, proprietary, copyrighted > and/or > legally privileged, and is intended solely for the use of the > individual > or entity named in this message. If you are not the intended > recipient, > and have received this message in error, please immediately return > this > by email and then delete it.