From users-return-26577-apmail-tomee-users-archive=tomee.apache.org@tomee.apache.org Fri Mar 16 09:17:44 2018 Return-Path: X-Original-To: apmail-tomee-users-archive@www.apache.org Delivered-To: apmail-tomee-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 54DF417C81 for ; Fri, 16 Mar 2018 09:17:44 +0000 (UTC) Received: (qmail 49870 invoked by uid 500); 16 Mar 2018 09:17:44 -0000 Delivered-To: apmail-tomee-users-archive@tomee.apache.org Received: (qmail 49849 invoked by uid 500); 16 Mar 2018 09:17:43 -0000 Mailing-List: contact users-help@tomee.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@tomee.apache.org Delivered-To: mailing list users@tomee.apache.org Received: (qmail 49821 invoked by uid 99); 16 Mar 2018 09:17:43 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2018 09:17:43 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id D9D85C0DE8 for ; Fri, 16 Mar 2018 09:17:42 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.042 X-Spam-Level: *** X-Spam-Status: No, score=3.042 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, HTML_OBFUSCATE_10_20=1.162, KAM_SHORT=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id jL3fpSoGavHC for ; Fri, 16 Mar 2018 09:17:41 +0000 (UTC) Received: from mail-yw0-f182.google.com (mail-yw0-f182.google.com [209.85.161.182]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 728D65F1B3 for ; Fri, 16 Mar 2018 09:17:41 +0000 (UTC) Received: by mail-yw0-f182.google.com with SMTP id r66so6505973ywh.10 for ; Fri, 16 Mar 2018 02:17:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=uJfMKMmujo5dnBJQBWiXystAaZ+SD2qXSmm0Xtc9cow=; b=pY6GeB2Y5SkxU4/0PoC4GVgn44+yFxoKmIJAh0l/xzG9JYxsg8n5W4EAnAPNWIy+tW SiNA7AQi9bKQQKAXdAwoCbZtQ5jYuXF6nRC1ZHRR8ArmS3EaZza1F1nNjpTR5A6hXqRP U0z3AKgNgY8Ao/vP/xQUZLBsNFR8M2MdVu9jP4Na7n1r+IqJhN8PPiPMGy83PDvCyvyY AlxOBac5zoysEGZVAcP6fgcxpkiN+5UkT2e1ToFvO0YSYFzAyuqHSc+wsvxQUkP51MJX Myc96POa7MEhrxXvydOnZQnH33thNRwH2rcxQ5vEJXgmodEaecQd0+NEkrTfHf+TlW+5 9t7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=uJfMKMmujo5dnBJQBWiXystAaZ+SD2qXSmm0Xtc9cow=; b=VH/sDr/mZS6iMfBevhVSSyyLuf5tfbMwsDm+QwXQF0LYpHaeW4ONFleQD3/8DCCQRJ C7VcKy4Amji/LRD/zvvJJy+upYF3owEhzJZ00tMBeEdEkuuj/svIoa0imR8L8fF8vbaV mIoSdY9NObhZPbnjx7KlrwM1hcgIyK3nxJuXqUrIe/UyKfNFlCJvAL3NJqjXi0BMPIz1 N/+6QOkHbdOkjvKqmSUW2lhJACyLvO3Lu19Xh/Yl0bZvo7GmvQqhxYec9WbC/XGcMyCW DQMcoPjdnXEIBPeCVK5sHM+J+E5Fu/v9/hrvBzsSDCCwDhcHN0HG69v9ZKU9P/btWn/L dY4Q== X-Gm-Message-State: AElRT7Hfhk7dG66Od26Pv/xZ9gRayKczzNr0Q3KmH8UXql6tkzIEnAoY YHPrDCUvVi3hPw3aMO9acLBhHtskc61B+no0MpQ= X-Google-Smtp-Source: AG47ELvO+aim7AiB41PL9s/Xg2QXPOBv8luR2aeNd46LVrxCf0TYdLx+k5DtfNHlrn7G+LA5E7czpxy//ipf+ccDFEs= X-Received: by 10.129.193.76 with SMTP id e12mr465478ywl.8.1521191855284; Fri, 16 Mar 2018 02:17:35 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a25:6dd4:0:0:0:0:0 with HTTP; Fri, 16 Mar 2018 02:17:14 -0700 (PDT) In-Reply-To: References: From: Romain Manni-Bucau Date: Fri, 16 Mar 2018 10:17:14 +0100 Message-ID: Subject: Re: [openjpa] multiple persistence units To: users@tomee.apache.org Content-Type: multipart/alternative; boundary="089e0821ff502b6807056784142e" --089e0821ff502b6807056784142e Content-Type: text/plain; charset="UTF-8" maybe activate sql logging to check what is happening exactly (LogSql=true for instance) Romain Manni-Bucau @rmannibucau | Blog | Old Blog | Github | LinkedIn | Book 2018-03-16 9:46 GMT+01:00 Matthew Broadhead : > they are both mysql databases > > On 16/03/2018 09:33, Romain Manni-Bucau wrote: > >> Hi, >> >> this is the way to do, maybe check your system properties and database >> configurations. With some DB you can need some more config (thinking to >> oracle and schemas for instance) >> >> >> Romain Manni-Bucau >> @rmannibucau | Blog >> | Old Blog >> | Github < >> https://github.com/rmannibucau> | >> LinkedIn | Book >> > high-performance> >> >> >> 2018-03-16 9:23 GMT+01:00 Matthew Broadhead < >> matthew.broadhead@nbmlaw.co.uk> >> : >> >> hi, >>> i just wrote an email to users@openjpa but there doesn't seem to be much >>> activity there. >>> do you know how to declare multiple persistence units? i created 2 >>> persistence units inside persistence.xml but it seems to create the >>> entities from the second PU in the database of the first one. my >>> persistence.xml is like this. the operator tables get created inside the >>> file database >>> >>> >> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence >>> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" >>> version="2.0"> >>> >>> file >>> uk.me.kissy.file.entities.jpa.Box >>> uk.me.kissy.file.entities.jpa.Category >>> uk.me.kissy.file.entities.jpa.CqsReview >>> uk.me.kissy.file.entities.jpa.Department >>> uk.me.kissy.file.entities.jpa.Enclosure >>> uk.me.kissy.file.entities.jpa.Event >>> uk.me.kissy.file.entities.jpa.EventData >>> uk.me.kissy.file.entities.jpa.EventType >>> >>> uk.me.kissy.file.entities.jpa.Log >>> uk.me.kissy.file.entities.jpa.Note >>> uk.me.kissy.file.entities.jpa.Payment >>> uk.me.kissy.file.entities.jpa.Price >>> uk.me.kissy.file.entities.jpa.Undertaking >>> uk.me.kissy.file.entities.jpa.UndertakingType >>> uk.me.kissy.file.entities.jpa.Workflow >>> >>> >> value="buildSchema(ForeignKeys=true)" /> >>> >>> >>> >>> operator >>> uk.me.kissy.file.entities.jpa.operator.Address >>> uk.me.kissy.file.entities.jpa.operator.Client >>> uk.me.kissy.file.entities.jpa.operator.Council >>> uk.me.kissy.file.entities.jpa.operator.Operator >>> uk.me.kissy.file.entities.jpa.operator.Posttown >>> uk.me.kissy.file.entities.jpa.operator.Wtr_auth >>> >>> >>> >>> > --089e0821ff502b6807056784142e--