From dev-return-20369-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Tue Apr 10 15:27:50 2012 Return-Path: X-Original-To: apmail-openjpa-dev-archive@www.apache.org Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8B0829CC4 for ; Tue, 10 Apr 2012 15:27:50 +0000 (UTC) Received: (qmail 31991 invoked by uid 500); 10 Apr 2012 15:27:50 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 31949 invoked by uid 500); 10 Apr 2012 15:27:50 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 31941 invoked by uid 99); 10 Apr 2012 15:27:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2012 15:27:50 +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; Tue, 10 Apr 2012 15:27:43 +0000 Received: by lbbgm6 with SMTP id gm6so80662lbb.33 for ; Tue, 10 Apr 2012 08:27:23 -0700 (PDT) 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=/hY17LEEw5ju+9HqREm+VTYPaKOQtaONl8OSaxh5ayo=; b=oJl9royWNWhoXoyAzO2bL/lalSgrJkfqVwRzVTlqyeh/cZ2g3qXpObHx4VTnuW3hAR 7/8djVl7bmt1Vi+iyzr+KAPvFwBGoVsxLbu+G6qWMkR1jVcmHKMr5QAGhA3zQ7HprF4z 6lxuBIVEDoedYRWsmjPx+cr3IdqRegIkFdYzDDmreuEJFwvaUHUNbO61OyTFSbMxnbF8 te447azP1N5+80oW2iIHMEGDUfCC3+Q7dTJQHqUBNGrFbyeZSnTpgiAl2fIV5id8R5XV alEnVWMtOOr5lFm2WTXmvzngAVTr6DwvSvlV2wC30U2oKUhH0MhkuIPCM8rbV/3ZRUsn 4iRw== Received: by 10.152.131.9 with SMTP id oi9mr15166508lab.6.1334071643011; Tue, 10 Apr 2012 08:27:23 -0700 (PDT) MIME-Version: 1.0 Received: by 10.112.42.7 with HTTP; Tue, 10 Apr 2012 08:27:02 -0700 (PDT) In-Reply-To: <2BDE089FC6E6734A8D04B19F6D35C0830794E7C9C1@DEWDFECCR09.wdf.sap.corp> References: <2BDE089FC6E6734A8D04B19F6D35C0830794E7C9C1@DEWDFECCR09.wdf.sap.corp> From: Kevin Sutter Date: Tue, 10 Apr 2012 10:27:02 -0500 Message-ID: Subject: Re: Access a new type of database with openJPA To: dev@openjpa.apache.org Content-Type: multipart/alternative; boundary=f46d042c647762f87504bd54c23c --f46d042c647762f87504bd54c23c Content-Type: text/plain; charset=ISO-8859-1 Hi, I would assume that SAP HANA is pretty close to some other existing database as far as JDBC and SQL support is concerned -- maybe Derby, DB2, or Oracle? I would start with one of those and extend your own "HanaDictionary" class. Or, you could always start by extending the base DBDictionary class and then modify it as necessary for the proper Hana support [1]. After you have created this dictionary, then you can plug this into the architecture via the openjpa.jdbc.DBDictionary property like this [2][3]: If you want to go a step further, you could also consider contributing this back to the Apache OpenJPA project and then modify the OpenJPA code to define an alias for this dictionary. This way, other future users could take advantage of your efforts and they could configure it as such: Hope this helps, Kevin [1] http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_dbsetup_dbsupport [2] http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#openjpa.jdbc.DBDictionary [3] http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_conf_plugins On Mon, Apr 9, 2012 at 9:56 PM, Qiu, Damon wrote: > Dear OpenJPA colleagues, > > This is Damon from SAP Business One team. Currently I want use OpenJPA as > OR Mapping framework in our project to support a new type of database(SAP > HANA). In document section 4, I see user can plug a dictionary in OpenJPA > to support a new database. > > I have tried several times, but always failed. Could you please give me > more detail configuration steps or guidelines? Thanks in advance. > > Best Regards, > Damon Qiu > > Remote Support Platform & Lifecycle Management & HANA | SAP Business One | > damon.qiu@sap.com | +86 21 6030 6031 > > --f46d042c647762f87504bd54c23c--